Form:SLA Compliance

[BMC Remedy]

Hi All,


Can anyone please tell me which form is used to to generate SLA compliance
report and how is it calculated like the basic parameters used .

-- 
*Thanks & Regards
 Remedy User*

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

ITSM 7.6.00 Data Dictionary

[Gmail]

Any idea where I can find a copy of the ITSM 7.6.00 data dictionary?  I am
only interested in the Task Management System data dictionary. 

 

Regards,

Moe.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: AR Server or DB issue

[Axton]

API, SQL, and filter.  Make a copy of them before you restart arserver
so they are not overwritten or otherwise lost.  See what the last
entries in the logs are at the time it was hung.  This will most
likely point you to the cause.  These log entries are just symptomatic
of the underlying issue:
 - AssignEng : Timeout during database update
 - SLMCS : Timeout during database update
 - BRIE : Timeout during database query
 - CMDB Dispatcher : Timeout during database query
With the underlying issue being that your app server and/or db server
are unresponsive.  When it says unresponsive, it usually means a
rather long time, I think 5 minutes, if my memory serves me correctly.

If you inspect the SQL logs, you should be able to get a list of the
last sql statements issued to the database server.  Look for the
one(s) that have not returned.  If all the threads are blocked, you
will get this error.  Take a look at the server statistics and see if
you have any queue blocked items.

Check the Cache-Mode of your server and make sure it is in production
mode.  Escalations can cause the server to hang in this way if the
server is in Dev cache mode.

Not sure what OS you are using, but gathering a stack trace for all
the threads for arserver can be helpful in seeing what arserver is
doing at the time it is hung.

If possible, generate a core dump from the arserver process before
restarting.  This will let you dig into the state of the process at a
later time, after restoring services.

Axton Grams

On Tue, Feb 14, 2012 at 2:26 PM, Avy Mann  wrote:
> **
> Ron,
>
> I wanted to suggest looking at any actions that trigger at 6 am.
>  Escalations come to mind because I noticed a line in your log:
>
> Fri Feb 10 06:30:05 2012  BRIE : Timeout during database query -- consider
> using more specific search criteria to narrow the results, and retry the
> operation (OUR_AR_SERVER)  ARERR - 94
>
> I see this repeated.  I am thinking there maybe be something in the
> background running a bad query.  Just a thought.
>
>
> 
> From: "Peters, Ron" 
> To: arslist@ARSLIST.ORG
> Sent: Tuesday, February 14, 2012 3:12:25 PM
>
> Subject: Re: AR Server or DB issue
>
> **
> Hmm, that KB article is interesting. It sure does sound plausible. If the
> server is stuck in a loop, resetting its brain seems like the right
> solution. Since the server is unresponsive during our issues, what should I
> look for on the DB to see what is causing the issue?
>
> I’m working with the DBA on this and since it happened last week mon/wed/fri
> and again yesterday, I can reasonably assume it will happen again tomorrow
> morning. I’d like to set up some type of process to catch this in the act
> and I’d like to gather all the appropriate data. Thougths?
>
> Thanks.
>
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
> Sent: Monday, February 13, 2012 2:47 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR Server or DB issue
>
> **
> Hi Ron
>
> I noticed the arAPPnote - indicating an approval notice. I've recently
> hotfxed our servers which were presenting us with ARERR 93 (server busy) or
> the same error you are getting (ARERR 92). Our servers would hang upon
> handling some approval actions. The symtom turned out to be unbelievable
> numbers of notifications being triggered - by a single Approval on a change.
> We got 13 entries in NTE:SYS-NT Proces Control for a single change.
> hotfix was SW00369891 Knowledgebase article is KA 354923 - just a hunch -
> but check your NTE:SYS-NT Proces Control  form (or select from the Database
> if your server is unresponsive as ours was).
>
> br
>
> Jonas
>
> Den 10-02-2012 16:34, Peters, Ron skrev:
> **
> Hello all,
>
> Having some AR server issues. Something has been happening in the mornings
> about 6am in that our service desk can’t access Remedy. This started in
> Decemeber but only once. Then twice in January and now a couple times this
> week. The first few times it resolved itself after about 30 minutes but this
> week we had to restart the AR service on the server to get it back. The
> following is the arerror log from this morning. I’ve contacted our DBA’s to
> see if they notice anything but since an AR restart resolves it, I’m not
> convinced it’s a DB issue. Any thoughts?
>
> Thanks.
>
> Fri Feb 10 06:25:30 2012  AssignEng : Timeout during database update -- the
> operation has been accepted by the server and will usually complete
> successfully (OUR_AR_SERVER)  ARERR - 92
> Fri Feb 10 06:25:30 2012  AssignEng : AR System Application server
> terminated -- fatal error encountered (ARAPPNOTE 4501)
> Fri Feb 10 06:25:31 2012  SLMCS : Timeout during database update -- the
> operation has been accepted by the server and will usually complete
> successfully (OUR_AR_SERVER)  ARERR - 92
> Fri Feb 10 06:25:31 2012  SLMCS : AR System Application server terminated --
> fatal error encountered (ARAPPNOTE 4501)
> Fri F

Re: Caught exception: Unable to get value of the property 'replace':

[David Conrow]

We get this error periodically.  You may want to try clearing the browser cache 
of the user having problems. 

David Conrow 
.

On Feb 14, 2012, at 6:16 AM, Rob Dudley  wrote:

> **
> Try flushing the mid tier cache
> 
> On Feb 14, 2012 6:33 AM, "BMC Remedy"  wrote:
> ** Hi All,
> 
> OneITSM- Incident module: gives an error message when viewing work info 
> details: "Caught exception: Unable to get value of the property 'replace': 
> object is null or undefined."
> 
> 
> We are using 7.6
> Browser :IE 8
> 
> Thanks & Regards
> Math
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
> _attend WWRUG12 www.wwrug.com  ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Java Plugin Server - Class conflict

[John Baker]

Hello,

Surely the classpath is defined somewhere, and you can put your jar file ahead 
of the AR System jars?


John

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Java Plugin Server - Class conflict

[LJ LongWing]

Axton,
I have experienced that if you have the same classes in multiple jar files,
that it uses the one that's in the classpath first, first.  So...if you add
the newer versions of the classes in your jar first, then the plugin server
jar file, that I believe it should use the new ones before the old ones.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Tuesday, February 14, 2012 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Java Plugin Server - Class conflict

I am trying to use Apache Commons Codec 1.6 in a plugin I am writing.
The plugin server jar contains these classes, though an old version
(too old to do what I would like to do):

$ jar -tvf arpluginsvr75.jar |grep 'org/apache/commons/codec/'
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/binary/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/digest/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/language/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/net/
   268 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/BinaryDecoder.class
   268 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/BinaryEncoder.class
   248 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/Decoder.class
   391 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/DecoderException.class
   248 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/Encoder.class
   391 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/EncoderException.class
   300 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/StringDecoder.class
   300 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/StringEncoder.class
  1190 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/StringEncoderComparator.class
  5468 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/binary/Base64.class
  2969 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/binary/BinaryCodec.class
  2624 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/binary/Hex.class
   704 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/binary/package.html
  1860 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/digest/DigestUtils.class
   708 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/digest/package.html
  2470 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/language/DoubleMetaphone$DoubleMetaphoneResult.clas
s
 14791 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/language/DoubleMetaphone.class
  5050 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/Metaphone.class
  2349 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/RefinedSoundex.class
  3286 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/Soundex.class
  1583 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/SoundexUtils.class
   674 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/package.html
  2661 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/BCodec.class
  4052 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/QCodec.class
  4511 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/QuotedPrintableCodec.class
  2435 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/RFC1522Codec.class
   252 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/StringEncodings.class
  4432 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/URLCodec.class
   696 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/package.html
  1022 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/overview.html
  3283 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/package.html

The problem is that the plugin resolves and uses the classes in the
plugin server jar file, not the jar file I have referenced in my
plugin server configuration:


  ARF.PLUGIN
  FilterAPI
  JAVA
  /path/to/plugin.jar
  com.newyorklife.remedy.plugins.Extractor
  /path/to/javacsv.jar
  /path/to/commons-codec-1.6.jar
  /path/to/mail.jar
  /path/to/commons-lang3-3.1.jar
  
/path/to/config.properties
  


Any ideas on how I can change the behavior of the classloader?  Do I
need to use something like java.lang.classloader?

Thanks,
Axton Grams


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: No. of file descriptors not getting released in 7.6.4

[Axton]

Use pfiles or lsof to see what the handles are for.  That'll point you
in the right direction.

Axton Grams

On Tue, Feb 14, 2012 at 12:45 PM, Pavan  wrote:
> Hi,
>
> Just checking if anyone had experienced this issue before. We are seeing this 
> behavior only on our production server though.
>
> We are on Solaris 10 with Oracle 11g. For some reason the number of file 
> descriptors not getting released. It reaches certain limit which is 8192 and 
> then after that it gives RPC 91 for any new user who logs in and will not 
> allow them to get into the system until we restart remedy. System hardly has 
> 5 users. I only see Remedy Application Service logging in and out every 2-5 
> secs in aruser.log. Other than that no other frequent users. We are only SP1 
> 7.6.4 and using sp2 arserverd file
>
> Any thoughts. Did anyone experience this issue. We dont have any other 
> integration at this moment which is talking to this system.
>
> Thanks in advance.
>
> Pavan
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Java Plugin Server - Class conflict

[Axton]

I am trying to use Apache Commons Codec 1.6 in a plugin I am writing.
The plugin server jar contains these classes, though an old version
(too old to do what I would like to do):

$ jar -tvf arpluginsvr75.jar |grep 'org/apache/commons/codec/'
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/binary/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/digest/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/language/
 0 Sun Sep 20 09:23:16 EDT 2009 org/apache/commons/codec/net/
   268 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/BinaryDecoder.class
   268 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/BinaryEncoder.class
   248 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/Decoder.class
   391 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/DecoderException.class
   248 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/Encoder.class
   391 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/EncoderException.class
   300 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/StringDecoder.class
   300 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/StringEncoder.class
  1190 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/StringEncoderComparator.class
  5468 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/binary/Base64.class
  2969 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/binary/BinaryCodec.class
  2624 Sat Jul 10 16:13:00 EDT 2004 org/apache/commons/codec/binary/Hex.class
   704 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/binary/package.html
  1860 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/digest/DigestUtils.class
   708 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/digest/package.html
  2470 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/language/DoubleMetaphone$DoubleMetaphoneResult.class
 14791 Sat Jul 10 16:13:00 EDT 2004
org/apache/commons/codec/language/DoubleMetaphone.class
  5050 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/Metaphone.class
  2349 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/RefinedSoundex.class
  3286 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/Soundex.class
  1583 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/SoundexUtils.class
   674 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/language/package.html
  2661 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/net/BCodec.class
  4052 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/net/QCodec.class
  4511 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/QuotedPrintableCodec.class
  2435 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/RFC1522Codec.class
   252 Sat Jul 10 16:13:02 EDT 2004
org/apache/commons/codec/net/StringEncodings.class
  4432 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/net/URLCodec.class
   696 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/net/package.html
  1022 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/overview.html
  3283 Sat Jul 10 16:13:02 EDT 2004 org/apache/commons/codec/package.html

The problem is that the plugin resolves and uses the classes in the
plugin server jar file, not the jar file I have referenced in my
plugin server configuration:


  ARF.PLUGIN
  FilterAPI
  JAVA
  /path/to/plugin.jar
  com.newyorklife.remedy.plugins.Extractor
  /path/to/javacsv.jar
  /path/to/commons-codec-1.6.jar
  /path/to/mail.jar
  /path/to/commons-lang3-3.1.jar
  
/path/to/config.properties
  


Any ideas on how I can change the behavior of the classloader?  Do I
need to use something like java.lang.classloader?

Thanks,
Axton Grams

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: SRD take offline Modify all... 7.6.04

[patrick zandi]

escalation worked just fine

On Tue, Feb 14, 2012 at 3:19 PM, patrick zandi  wrote:

> is there a way to do modify all and take them all offline..
> I can most likely do an escalation, but was wondering..
> I have 2289 of them..
>
>
> --
> Patrick Zandi
>



-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: AR Server or DB issue

[Avy Mann]

Ron,

I wanted to suggest looking at any actions that trigger at 6 am.  Escalations 
come to mind because I noticed a line in your log:

Fri Feb 10 06:30:05 2012  BRIE : Timeout during database query -- consider 
using more specific search criteria to narrow the results, and retry the 
operation (OUR_AR_SERVER)  ARERR - 94 


I see this repeated.  I am thinking there maybe be something in the background 
running a bad query.  Just a thought.




 From: "Peters, Ron" 
To: arslist@ARSLIST.ORG 
Sent: Tuesday, February 14, 2012 3:12:25 PM
Subject: Re: AR Server or DB issue
 

**  
Hmm, that KB article is interesting. It sure does sound plausible. If the 
server is stuck in a loop, resetting its brain seems like the right solution. 
Since the server is unresponsive during our issues, what should I look for on 
the DB to see what is causing the issue? 
 
I’m working with the DBA on this and since it happened last week mon/wed/fri 
and again yesterday, I can reasonably assume it will happen again tomorrow 
morning. I’d like to set up some type of process to catch this in the act and 
I’d like to gather all the appropriate data. Thougths?
 
Thanks.
 
From:Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
Sent: Monday, February 13, 2012 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR Server or DB issue
 
** 
Hi Ron

I noticed the arAPPnote - indicating an approval notice. I've recently hotfxed 
our servers which were presenting us with ARERR 93 (server busy) or the same 
error you are getting (ARERR 92). Our servers would hang upon handling some 
approval actions. The symtom
 turned out to be unbelievable numbers of notifications being triggered - by a 
single Approval on a change. We got 13 entries in NTE:SYS-NT Proces Control 
for a single change. hotfix was SW00369891 Knowledgebase article is KA 354923 - 
just a hunch - but
 check your NTE:SYS-NT Proces Control  form (or select from the Database if 
your server is unresponsive as ours was).

br

Jonas

Den 10-02-2012 16:34, Peters, Ron skrev: 
** 
Hello all,
 
Having some AR server issues. Something has been happening in the mornings 
about 6am in that our service desk can’t access Remedy. This started in 
Decemeber but only once. Then twice in January and now a couple times this 
week. The first few times it resolved itself after about 30 minutes but this 
week we had to restart the AR service on the server to get it back. The 
following is the arerror log from this morning. I’ve contacted our DBA’s to see 
if they notice anything but since an AR restart resolves it, I’m not convinced 
it’s a DB issue. Any thoughts?
 
Thanks.
 
Fri Feb 10 06:25:30 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:25:30 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:25:31 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:25:31 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:27:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:27:32 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:27:32 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:27:32 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:29:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:29:32 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:29:32 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:29:32 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:30:05 2012  BRIE : Timeout during database query -- consider 
using more specific search criteria to narrow the results, and retry the 
operation (OUR_AR_SERVER)  ARERR - 94
Fri Feb 10 06:31:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:31:32 2012  AssignEng : AR System Application server te

SRD take offline Modify all... 7.6.04

[patrick zandi]

is there a way to do modify all and take them all offline..
I can most likely do an escalation, but was wondering..
I have 2289 of them..


-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: AR Server or DB issue

[Peters, Ron]

Hmm, that KB article is interesting. It sure does sound plausible. If the 
server is stuck in a loop, resetting its brain seems like the right solution. 
Since the server is unresponsive during our issues, what should I look for on 
the DB to see what is causing the issue?

I'm working with the DBA on this and since it happened last week mon/wed/fri 
and again yesterday, I can reasonably assume it will happen again tomorrow 
morning. I'd like to set up some type of process to catch this in the act and 
I'd like to gather all the appropriate data. Thougths?

Thanks.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
Sent: Monday, February 13, 2012 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: AR Server or DB issue

**
Hi Ron

I noticed the arAPPnote - indicating an approval notice. I've recently hotfxed 
our servers which were presenting us with ARERR 93 (server busy) or the same 
error you are getting (ARERR 92). Our servers would hang upon handling some 
approval actions. The symtom turned out to be unbelievable numbers of 
notifications being triggered - by a single Approval on a change. We got 13 
entries in NTE:SYS-NT Proces Control for a single change. hotfix was SW00369891 
Knowledgebase article is KA 354923 - just a hunch - but check your NTE:SYS-NT 
Proces Control  form (or select from the Database if your server is 
unresponsive as ours was).

br

Jonas

Den 10-02-2012 16:34, Peters, Ron skrev:
**
Hello all,

Having some AR server issues. Something has been happening in the mornings 
about 6am in that our service desk can't access Remedy. This started in 
Decemeber but only once. Then twice in January and now a couple times this 
week. The first few times it resolved itself after about 30 minutes but this 
week we had to restart the AR service on the server to get it back. The 
following is the arerror log from this morning. I've contacted our DBA's to see 
if they notice anything but since an AR restart resolves it, I'm not convinced 
it's a DB issue. Any thoughts?

Thanks.

Fri Feb 10 06:25:30 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:25:30 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:25:31 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:25:31 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:27:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:27:32 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:27:32 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:27:32 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:29:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:29:32 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:29:32 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:29:32 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:30:05 2012  BRIE : Timeout during database query -- consider 
using more specific search criteria to narrow the results, and retry the 
operation (OUR_AR_SERVER)  ARERR - 94
Fri Feb 10 06:31:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:31:32 2012  AssignEng : AR System Application server terminated 
-- fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:31:32 2012  SLMCS : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:31:32 2012  SLMCS : AR System Application server terminated -- 
fatal error encountered (ARAPPNOTE 4501)
Fri Feb 10 06:33:32 2012  AssignEng : Timeout during database update -- the 
operation has been accepted by the server and will usually complete 
successfully (OUR_AR_SERVER)  ARERR - 92
Fri Feb 10 06:33:32 2012  AssignEng : AR System Application server terminated 
-- fa

When we reboot Remedy server all the midtair links do not work

[Ramesh Danam]

Hello

We have DOT NET web interface using Remedy WEB SERVICE to create a Tickets to 
Remedy Form.
How ever When ever re booting the ARS Server Web Interface does not work .


Each time we REfresh the Cashe at Midtair. Even though we have AUTO CACHE 
OPTION Checked on MID TAIR .


ANY BODY know why Even AUTO CACHE IS ON Still we need to Refresh Manually ?

Is it a DOTNET problem or some thing else?

Please reply

Thanks
Ramesh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

No. of file descriptors not getting released in 7.6.4

[Pavan]

Hi,

Just checking if anyone had experienced this issue before. We are seeing this 
behavior only on our production server though.

We are on Solaris 10 with Oracle 11g. For some reason the number of file 
descriptors not getting released. It reaches certain limit which is 8192 and 
then after that it gives RPC 91 for any new user who logs in and will not allow 
them to get into the system until we restart remedy. System hardly has 5 users. 
I only see Remedy Application Service logging in and out every 2-5 secs in 
aruser.log. Other than that no other frequent users. We are only SP1 7.6.4 and 
using sp2 arserverd file

Any thoughts. Did anyone experience this issue. We dont have any other 
integration at this moment which is talking to this system.

Thanks in advance.

Pavan

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Midtier SSO for 7.6.04 64bit

[Danny Kellett]

Hi Shawn,

I did reply to explain there shouldn’t be any problem as the C plugin server is 
still 32 bit and I will be happy to help with whatever issues he is having. 
Compiling or otherwise. 

We don’t always push our product, I am, and have been, an AR System guy long 
before an SSO architect :)

Thanks for the kind words
Danny

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn
Sent: 14 February 2012 15:55
To: arslist@ARSLIST.ORG
Subject: Re: Midtier SSO for 7.6.04 64bit

I'm surprised that the JSS guys haven't responded to you, but we use their 
product and it works well.  It was cheaper to simply purchase that than to 
spend time trying to get BMC's solution to work with the oddities in my 
environment.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of E. Thornton
Sent: Monday, February 13, 2012 12:52 PM
To: arslist@ARSLIST.ORG
Subject: Midtier SSO for 7.6.04 64bit

Has anyone implemented Midtier SSO in a 64bit environment?  I have been using a 
modified version of code provided by BMC. It was written for 32bit systems and 
errors out when attempting to use it on a 64bit system. I just wanted to know 
if  there are any solutions out there for 64bit environments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: 7.6.04 SP2 Becon's to address... to terracotta

[LJ LongWing]

If it is.I know that when Tomcat starts it does an 'upgrade check' and
reports on my servers that there is a new version available.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Tuesday, February 14, 2012 9:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: 7.6.04 SP2 Becon's to address... to terracotta

 

** 

My guess is that it's something to do with ehcache.

 

Regards,

 

Andrew Goodall

Software Engineer 2 | Development Services |  jcpenney . www.jcp.com
   

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi
Sent: Tuesday, February 14, 2012 10:36 AM
To: arslist@ARSLIST.ORG
Subject: 7.6.04 SP2 Becon's to address... to terracotta

 

** I have a question:: why does my server Becon out to this address when all
I have installed is ITSM / and ARS/ 
is this bad code? going to terracotta?

 

MY-HOST-IP.53698   64.95.112.233.80 0  0 49640  0 SYN_SENT

 



-- 
Patrick Zandi
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 


The information transmitted is intended only for the person or entity to
which it is addressed and 
may contain confidential and/or privileged material. If the reader of this
message is not the intended
recipient, you are hereby notified that your access is unauthorized, and any
review, dissemination,
distribution or copying of this message including any attachments is
strictly prohibited. If you are not
the intended recipient, please contact the sender and delete the material
from any computer.

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: 7.6.04 SP2 Becon's to address... to terracotta

[patrick zandi]

Actually Axton: I did not .. but I thought about it.. I might pursue
looking at this..
I think it during startup of the server only, then it disappears..


On Tue, Feb 14, 2012 at 12:05 PM, Axton  wrote:

> Any chance you have a recording of the conversation.  I be curious to
> see the payload in the get/post.
>
> Axton Grams
>
> On Tue, Feb 14, 2012 at 10:36 AM, patrick zandi 
> wrote:
> > ** I have a question:: why does my server Becon out to this address when
> all
> > I have installed is ITSM / and ARS/
> > is this bad code? going to terracotta?
> >
> >
> > MY-HOST-IP.53698   64.95.112.233.80 0  0 49640  0
> SYN_SENT
> >
> >
> >
> >
> > --
> > Patrick Zandi
> > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>



-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: 7.6.04 SP2 Becon's to address... to terracotta

[Rick Cook]

My guess is that it is leftover test data.  Wouldn't be the first time.

Rick
On Feb 14, 2012 12:05 PM, "Axton"  wrote:

> Any chance you have a recording of the conversation.  I be curious to
> see the payload in the get/post.
>
> Axton Grams
>
> On Tue, Feb 14, 2012 at 10:36 AM, patrick zandi 
> wrote:
> > ** I have a question:: why does my server Becon out to this address when
> all
> > I have installed is ITSM / and ARS/
> > is this bad code? going to terracotta?
> >
> >
> > MY-HOST-IP.53698   64.95.112.233.80 0  0 49640  0
> SYN_SENT
> >
> >
> >
> >
> > --
> > Patrick Zandi
> > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: 7.6.04 SP2 Becon's to address... to terracotta

[Axton]

Any chance you have a recording of the conversation.  I be curious to
see the payload in the get/post.

Axton Grams

On Tue, Feb 14, 2012 at 10:36 AM, patrick zandi  wrote:
> ** I have a question:: why does my server Becon out to this address when all
> I have installed is ITSM / and ARS/
> is this bad code? going to terracotta?
>
>
> MY-HOST-IP.53698   64.95.112.233.80 0  0 49640  0 SYN_SENT
>
>
>
>
> --
> Patrick Zandi
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: 7.6.04 SP2 Becon's to address... to terracotta

[Andrew C Goodall]

My guess is that it's something to do with ehcache.

 

Regards,

 

Andrew Goodall

Software Engineer 2 | Development Services |  jcpenney . www.jcp.com
  



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi
Sent: Tuesday, February 14, 2012 10:36 AM
To: arslist@ARSLIST.ORG
Subject: 7.6.04 SP2 Becon's to address... to terracotta

 

** I have a question:: why does my server Becon out to this address when
all I have installed is ITSM / and ARS/ 
is this bad code? going to terracotta?

 

MY-HOST-IP.53698   64.95.112.233.80 0  0 49640  0
SYN_SENT

 



-- 
Patrick Zandi
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

The information transmitted is intended 
only for the person or entity to which it is addressed and may contain 
confidential and/or privileged material. If the reader of this message is not 
the intendedrecipient, you are hereby notified that your access is 
unauthorized, and any review, dissemination,distribution or copying of this 
message including any attachments is strictly prohibited. If you are notthe 
intended recipient, please contact the sender and delete the material from any 
computer.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

7.6.04 SP2 Becon's to address... to terracotta

[patrick zandi]

I have a question:: why does my server Becon out to this address when all I
have installed is ITSM / and ARS/
is this bad code? going to terracotta?


MY-HOST-IP.53698  * 64.95.112.233.80* 0  0 49640  0 SYN_SENT




-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Midtier SSO for 7.6.04 64bit

[John Baker]

Shawn,

Your environment was not really odd; it was relatively easy compared to some of 
the integrations we perform. Although always a pleasure to work with an AR 
System admin who wants to get their hands dirty with SSO and understand how it 
works.

I've spotted AR System admins putting SSO Plugin on their CV so perhaps it's 
about time we offered formal training/qualifications on SSO in the BMC market? 

Perhaps BMC can run the courses for us :-)


John

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Midtier SSO for 7.6.04 64bit

[Pierson, Shawn]

I'm surprised that the JSS guys haven't responded to you, but we use their 
product and it works well.  It was cheaper to simply purchase that than to 
spend time trying to get BMC's solution to work with the oddities in my 
environment.

Thanks,

Shawn Pierson
Remedy Developer | Southern Union

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of E. Thornton
Sent: Monday, February 13, 2012 12:52 PM
To: arslist@ARSLIST.ORG
Subject: Midtier SSO for 7.6.04 64bit

Has anyone implemented Midtier SSO in a 64bit environment?  I have been using a 
modified version of code provided by BMC. It was written for 32bit systems and 
errors out when attempting to use it on a 64bit system. I just wanted to know 
if  there are any solutions out there for 64bit environments.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Web Services

[White, Michael W (Mike)]

Listers,

We're starting to look at web services, ultimately to exchange 
data with our customer's applications.  At the moment, we're simply trying to 
consume a sample web service (from the integration guide) to prove the 
technology before we commit customer resources.

We've built a simple form with a pair of fields to get a stock 
quote and a Filter with a Set Fields/Data Source Web Service action to consume 
the web service.  "Reload" seems to read the WSDL (url).  When we test though, 
it returns "Cannot establish a network connection to the AR System Plug-In 
server (ARERR 8760)".  Per Integration Guide, we've verified that Web Services 
Plugin and Mid-Tier are installed (Mid Tier on a different server, has been 
operational for some time now).

Any suggestions?

We're running ARS 7.6.3 on an Oracle 11 db on Solaris 5.10 (Mid Tier is 7.6.4).

The sample WSDL is at:

http://www.restfulwebservices.net/wcf/StockQuoteService.svc?wsdl

Mike White
EMail michael.wh...@verizon.com
Office 813.978.2192


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: How to create an archival server in remedy in windows platform!!!

[Elry]

Hey Hari...

Some quick opinions :

1. Looks like you will be doing selective archiving & not fixed
archiving.  What this means for us is that you will be selecting
criteria for tickets that will be archived as opposed to archiving all
tickets for a fixed time period.  This means that you will have to
make multiple passes during each archive transaction to get older
tickets.
2. If you are going to close tickets - then you will probably want to
get all the data associated with the ticket (i.e. work logs,
attachments etc.).
3. You have to decide whether or not you want to use the same Remedy
interface to look at and retrieve the archived data (you could just
rely on reports).
4. If you use the Remedy interface then - you will have to stand up
another Remedy instance (granted - that there will be only viewing of
data - so there will not be a need for write licenses).
5. Frequency of archiving, and server performance will depend on how
much data you will be moving.
6. DSO may not be the best method for data migration.
7. If you use archive forms - note that the archive forms must be on
the same server as your Remedy instance (this still leaves your data
on your production box).
8. Remedy Migrator is another option (if you can afford it).  You are
able to configure private TCP ports to help reduce the load on the
server. Only drawback - it does not look like there is a way to delete
your record after archiving; therefore, this will have to be an
escalation or some other workflow.
9. In the past I have used EIE OR AIE OR AI - not sure what they are
calling it now.  This works ok, but it's newest incarnation that
leverages the Pentaho Spoon ETL engine looks to be superior (I think
you need version 7.6.04 of ITSM).

There are third party options like (rrchive is free and picks up where
the Migrator left off):

META-UPDATE: http://www.softwaretoolhouse.com/product/SthMupd/index.html
RRCHIVE:  http://www.rrr.se/en/


On Feb 14, 8:31 am, Hari Vishwakarma  wrote:
> Hi,
>
> We are planning to have archiving server with the following strategies in 
> place:
>
> 1. We will be moving our production server data to the newly created
> archiving server with certain conditions like incident=closed or
> cancelled, and we will be archiving the data on an interval of 2-3
> months.
>
> Here, i have few queries:
> a.Will this archival server requires any new hardware,os,remedy ars,
> remedy apps, licenses.
> Plz note that my current remedy environment is on windows 2003 server, sql 
> serv
>  er 2005 database,ARS 7.5.04,remedy ITSM apps7.6.01
> b. Can this archival server be synched on an database level, if yes then how?
>
> 2. what frequency shall we use to archive the data from the production?
>
> 3. will this hamper my production server performance?
>
> 4. We are planning to use archiving forms or DSO, please suggest its
> pros & cons while implementing.
>
> Please suggest .
>
> Regards
>
> Hari
>
> One more thing, how this movement of data will happen even after
> 1.We want our production data to be moved from production to archival se
>
>
>
>
>
>
>
>
>
> On Tue, Feb 14, 2012 at 1:17 AM, Elry  wrote:
>
> > Well Hari...
>
> > We currently just finishing up the creation of an archival server.
>
> > I guess my key questions would be:
>
> > 1. Do you have any Archive Policies in place (i.e. Incident Tickets
> > will be automatically closed after 90 Days).
> > 2. What applications are you running (i.e. ITSM or Custom
> > Applications)?
> > 3. What do you want to archive?
> > 4. How are you going to archive (Archive forms, DSO, Remedy Migrator,
> > DRIVER.EXE, etc.)?
>
> > On Feb 13, 1:32 pm, Hari Vishwakarma  wrote:
> > > Hi All,
>
> > > I want to create an archival server which will offload my production 
> > > server
> > > load & improves my production server performance
> > > Can anyone suggest what are all the prerequisites for the required 
> > > archival
> > > server.And what need to be kept in mind while configuring this. Also will
> > > it require any short of customizations for achieveing an archival server.
>
> > > Please suggest to achieve the same.
>
> > > --
> > > Best Regards,
>
> > > Hari shankar Vishwakarma
> > > Mobile:- +91-9833675872
> > > E-mail:- hsvishwaka...@gmail.com
>
> > > ___
> > >  
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are"
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or acc

Re: HPD Help Desk SLA

[Wirasat Siddiqi]

For 7.6.04 SP1 version, when you open a closed ticket, it opens a new 
ticket by copying old ticket information to the new ticket. And it starts 
a new SLA with the ticket. For older version, I believe it continues the 
same SLA when the ticket is re-opened if the 'Allow Service Target to 
Re-Open' is set to yes. 

Thanks,
Wirasat



From:   "Schon, Stuart" 
To: arslist@ARSLIST.ORG
Date:   02/13/2012 05:44 PM
Subject:Re: HPD Help Desk SLA
Sent by:"Action Request System discussion list(ARSList)" 




** 
I don?t believe that how it works in 7.1+, if you reopen a ticket it will 
reopen the same SLA and treat the period from when the SLA stopped to the 
reopen event as if the SLA was suspended, a new due date will be 
calculated and any remaining time on the SLA will be reinstigated.
 
The parameter mentioned below allows this to happen
 
Stuart Schon
Service Desk Systems - Manager

Fujitsu Australia Limited
2 Julius Avenue, North Ryde NSW 2113, Australia
T +61 2 9113 9435 M +61 458 592 245 
stuart.sc...@au.fujitsu.com
au.fujitsu.com


From: Action Request System discussion list(ARSList) [
mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi
Sent: Tuesday, 14 February 2012 01:59
To: arslist@ARSLIST.ORG
Subject: Re: HPD Help Desk SLA
 
** It will start a new SLA if you have set up the parameter 'Allow Service 
Target to Re-Open?' is set to Yes on SLA Measurement tab. 

 




Thanks, 
Wirasat Siddiqi 
Remedy Development Team 
Desk Phone: 202-502-3204 
Cell: 202-368-7190 
Email: wirasat_sidd...@ao.uscourts.gov 



From:Bhupesh Gupta  
To:arslist@ARSLIST.ORG 
Date:02/13/2012 05:53 AM 
Subject:HPD Help Desk SLA 
Sent by:"Action Request System discussion list(ARSList)" 
 




SLA for ticket re-open ? Does it reset and start fresh SLA , or
continue to use the same SLA

Please advise

-- 
Regards,
Bhupesh Gupta

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: How to create an archival server in remedy in windows platform!!!

[Hari Vishwakarma]

Hi,

We are planning to have archiving server with the following strategies in place:

1. We will be moving our production server data to the newly created
archiving server with certain conditions like incident=closed or
cancelled, and we will be archiving the data on an interval of 2-3
months.

Here, i have few queries:
a.Will this archival server requires any new hardware,os,remedy ars,
remedy apps, licenses.
Plz note that my current remedy environment is on windows 2003 server, sql serv
 er 2005 database,ARS 7.5.04,remedy ITSM apps7.6.01
b. Can this archival server be synched on an database level, if yes then how?

2. what frequency shall we use to archive the data from the production?

3. will this hamper my production server performance?

4. We are planning to use archiving forms or DSO, please suggest its
pros & cons while implementing.

Please suggest .

Regards

Hari

One more thing, how this movement of data will happen even after
1.We want our production data to be moved from production to archival se
On Tue, Feb 14, 2012 at 1:17 AM, Elry  wrote:
>
> Well Hari...
>
> We currently just finishing up the creation of an archival server.
>
> I guess my key questions would be:
>
> 1. Do you have any Archive Policies in place (i.e. Incident Tickets
> will be automatically closed after 90 Days).
> 2. What applications are you running (i.e. ITSM or Custom
> Applications)?
> 3. What do you want to archive?
> 4. How are you going to archive (Archive forms, DSO, Remedy Migrator,
> DRIVER.EXE, etc.)?
>
>
>
> On Feb 13, 1:32 pm, Hari Vishwakarma  wrote:
> > Hi All,
> >
> > I want to create an archival server which will offload my production server
> > load & improves my production server performance
> > Can anyone suggest what are all the prerequisites for the required archival
> > server.And what need to be kept in mind while configuring this. Also will
> > it require any short of customizations for achieveing an archival server.
> >
> > Please suggest to achieve the same.
> >
> > --
> > Best Regards,
> >
> > Hari shankar Vishwakarma
> > Mobile:- +91-9833675872
> > E-mail:- hsvishwaka...@gmail.com
> >
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Question about "Oracle-Clob-Storage-In-Row" setting

[Garrison, Sean (Norcross)]

The doc I had was from 2008 ... lol.  So yours is more recent than the one I 
had.  I am not aware of a newer one.

Sean

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: Monday, February 13, 2012 5:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about "Oracle-Clob-Storage-In-Row" setting

**
Sean,

Yep, got that handled.  Do you know if there is a more recent version of that 
white paper than the one I used from Oct 2009?

Thanks,
Thad
On Mon, Feb 13, 2012 at 12:35 PM, Garrison, Sean (Norcross) 
mailto:sean.garri...@fiserv.com>> wrote:
**
Just an FYI ... enabling this feature does not go back and fix all of the 
tables that are storing your data "Out of Row"  BMC has an oracle stored 
procedure for fixing that.  See page 10 and 11 of the "Using Oracle CLOBs with
BMC Remedy Action Request System" white paper.  Doing so will reduce your db 
size considerably (assuming you enabled it after installing ITSM).

Thanks,

Sean

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: Monday, February 13, 2012 3:26 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about "Oracle-Clob-Storage-In-Row" setting

**

I was just testing that scenario as you responded.  I created a new regular 
form, adding a character field with db length 8000 before the first save.

This is what showed in the logs (clipped for brevity) when I did save it:

CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 
number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 
number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null)
OK
CREATE UNIQUE  INDEX IT2011 ON T2011 (C1)
OK
CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 
varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) 
NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 
number(15,0) NULL,U4 varchar(254) NULL)
OK

...

...

ALTER TABLE T2011 ADD (C536870913 clob NULL)

Still no indication that it is accounting for the storage in row.  I'm sure 
it's there, I would just like to "see" it happening or be able to verify it 
somehow.

Thanks,
Thad

On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W 
mailto:frederick.w.gro...@xo.com>> wrote:
You will only see the clause if you add a 0 length character field (or a Diary 
or a field bigger than 4000 characters) as those are stored as a CLOB.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: Monday, February 13, 2012 1:50 PM
To: arslist@ARSLIST.ORG
Subject: Question about "Oracle-Clob-Storage-In-Row" setting

**
Hello,
We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) 
and reviewing our settings from prior versions.  We've set 
"Oracle-Clob-Storage-In-Row: T" in the ar.conf.
My understanding from reading the documents was that this setting causes ARS to 
add a clause to the CREATE TABLE statement so that clobs are stored in row.  In 
the "Using Oracle CLOBs with BMC Remedy Action Request System" (March 2009, 
89963) white paper it says:
  "To specify the storage option at the Oracle database level, use the 
ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement."

So with the setting set and sql logging turned on, I created a regular form, 
core fields only.  This is the entire CREATE TABLE statement from the log:
  CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 
number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 
number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null)

Shouldn't there be a part of that that says "STORAGE IN ROW" or something 
similar?  I tried googling for examples of what the SQL should look like, but 
didn't find anything definitive.
Is there a way to see if STORAGE IN ROW has been set for that table?
Out of curiousity, I ran the same test on our existing 7.1 dev server which has 
been running with that setting for years and got the same results.  So I figure 
I'm misunderstanding something and would appreciate any insights.
Thanks,
Thad
___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the 
Answers Are"

_attend WWRUG12 www.wwrug.com ARSlist: "Where the 
Answers Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the 
Answers Are"_

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
at

Re: Caught exception: Unable to get value of the property 'replace':

[Rob Dudley]

Try flushing the mid tier cache
On Feb 14, 2012 6:33 AM, "BMC Remedy"  wrote:

> ** Hi All,
>
> OneITSM- Incident module: gives an error message when viewing work info
> details: "Caught exception: Unable to get value of the property 'replace':
> object is null or undefined."
>
>
> We are using 7.6
> Browser :IE 8
>
> Thanks & Regards
> Math
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Caught exception: Unable to get value of the property 'replace':

[BMC Remedy]

Hi All,

OneITSM- Incident module: gives an error message when viewing work info
details: "Caught exception: Unable to get value of the property 'replace':
object is null or undefined."


We are using 7.6
Browser :IE 8

Thanks & Regards
Math

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"