WAR deployment

[John Baker]

I recently tried to deploy a Midtier war file in Weblogic and it failed.  I'd 
set up the LD_LIBRARY_PATH (it's tedious that MT 7.5 still requires the 
LD_LIBRARY_PATH, despite using the Java AR API and only relying on one or two 
calls from the 'util' part of the API, rant rant), but it still failed.  I 
didn't get around to investigating the exception - I simply deployed it in 
JBoss (have you considered JBoss?).  However, I would be surprised if MT 
"didn't work" in WL - it may involve pulling out jar files, native libs, etc., 
from the war file.  Why not try deploying the war and pasting the exception 
that occurs when WL starts?

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

RKM Authentication

[John Baker]

There's no official SSO interface for RKM where you can give users a URL and 
they'll log in to RKM without being presented for credentials.  The workflow 
solution isn't going to go down well with your local security team, and this 
prompted us to write one - see 2m35s into this movie:  
http://www.javasystemsolutions.com/jss/ssoplugin


JB

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

Re: ARERR 299 Too many levels in filter processing

[NNMN]

Hi Misi,Hany so  on :)
 Although this is something which i had tried, the problem here is that
although i would stop this very filter executing in this form through a
'DoNotFireMySubmitFilter'/flag , at the same time i have many other filters
running on a submit again with many complex qualification and which would
need to run many times in the same form. And lets just say i introduce this
particular 'DoNotFireMySubmitFilter' for all the other filters on the same
form it would end me up letting the other filters getting executed only once
for the life time of the record. So I cant go ahead with this. I was rather
trying through a set field in activelink and then doing a commit but very
wierdly it closes the AR user window!


Misi Mladoniczky wrote:
> 
> Hi,
> 
> Why not do a set-fields on the CURRENT TRANSACTION instead?
> 
> If that is not possible, you can allways create a Display-Only-field
> called something like DoNotFireMySubmitFilter=Yes, and skip the filter if
> it is set.
> 
> Best Regards - Misi, RRR AB, http://www.rrr.se
> 
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
> 
>> Hi fellow listers,
>>
>> This is something which i had tried.
>>
>> My need was to change a field value in a form after a record is
>> submitted/modified and the record for which i need the field value change
>> to
>> be made is the one which got submitted/modified.
>>
>> So I created a filter which gets triggerred(i.e on action Submit and
>> Modify)and then do a push field and change the value in the field for the
>> same form-record.
>>
>> Now my problem here is that as I am doing the push in the same form for
>> changing a value in the field, "ARERR 299 Too many levels in filter
>> processing" occurs. I know this happens because the Push field action
>> ultimately triggers a submit/modify action on the same form and the
>> filter
>> get triggerred infinitely.
>>
>> Can anyone suggest me a different approach to this?
>>
>> Cheers :)
>> --
>> View this message in context:
>> http://old.nabble.com/ARERR-299-Too-many-levels-in-filter-processing-tp28750990p28750990.html
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>
>> --
>> This message was scanned by ESVA and is believed to be clean.
>>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
> 
> 

-- 
View this message in context: 
http://old.nabble.com/ARERR-299-Too-many-levels-in-filter-processing-tp28750990p28776247.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: ARERR 299 Too many levels in filter processing

[Shafqat Ayaz]

the way i have gotten around this problem is to have a flag field and then run 
your action if the flag is set to yes or no whatever the case maybe. this will 
get you around the loop issue.

thanks

Shafqat Ayaz    
 



--- On Wed, 6/2/10, Matt Worsdell  wrote:

From: Matt Worsdell 
Subject: Re: ARERR 299 Too many levels in filter processing
To: arslist@ARSLIST.ORG
Date: Wednesday, June 2, 2010, 4:42 AM

I fail to see why, Direct SQL is a legitimate built in option.


> Hi,
>
> Direct SQL makes a system hard to manage. If there are built in options
> other than Direct SQL, use them instead!
>
>         Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> Another option would be to use a Direct SQL Action.
>>
>> Matt
>>
>>
>>> Hi fellow listers,
>>>
>>> This is something which i had tried.
>>>
>>> My need was to change a field value in a form after a record is
>>> submitted/modified and the record for which i need the field value
>>> change
>>> to
>>> be made is the one which got submitted/modified.
>>>
>>> So I created a filter which gets triggerred(i.e on action Submit and
>>> Modify)and then do a push field and change the value in the field for
>>> the
>>> same form-record.
>>>
>>> Now my problem here is that as I am doing the push in the same form for
>>> changing a value in the field, "ARERR 299 Too many levels in filter
>>> processing" occurs. I know this happens because the Push field action
>>> ultimately triggers a submit/modify action on the same form and the
>>> filter
>>> get triggerred infinitely.
>>>
>>> Can anyone suggest me a different approach to this?
>>>
>>> Cheers :)
>>> --
>>> View this message in context:
>>> http://old.nabble.com/ARERR-299-Too-many-levels-in-filter-processing-tp28750990p28750990.html
>>> Sent from the ARS (Action Request System) mailing list archive at
>>> Nabble.com.
>>>
>>> ___
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>>
>>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>
>> --
>> This message was scanned by ESVA and is believed to be clean.
>>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
>

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





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

Re: Curious filter issue

[LJ LongWing]

Anne,

The reason it's changing back to 'current transaction' is because you aren't
setting a field on your form with a field from the search..it's an annoying
feature, but it's there..

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 7:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

 

** 

The filter log is not helpful, it just shows the field being set to the
current time stamp (because the value isn't being pulled from the form it's
supposed to be because the filter is incorrectly changing to "current
transaction" from the correct selection criteria).  I didn't grab the SQL
log, I'll have to do that and see what it says.

 

Anne Ramey

***

E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Thursday, June 03, 2010 5:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

 

** 

Depending on what you have used to set that field, take an active link or a
filter or escalation log and see what happens when that piece of workflow
fires...

 

An SQL log might be useful too..

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 5:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

** 

I checked, it's Date/Time

 

Anne Ramey

***

E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Thursday, June 03, 2010 4:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

 

** 

Anne,

 

Make sure that the field you have created is not a Date Only field but a
Date and Time field.. If its a Date Only field then your calculation should
be $DATE$*$NumberOfDays$.

 

The Date Only field type uses $DATE$ and is different from the Date and Time
field type which uses $TIMESTAMP$ for setting values to it..

 

Cheers

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Curious filter issue

** 

I have a set fields action that just doesn't like what I'm setting the field
to.  I'm trying to set a date field using math; I'm trying to set 

Required Resolution Date (date/time field) to
$TIMESTAMP$+(60*60*24*$NumberOfDays$)  

on some custom forms and it just doesn't work.  If I set it with another
date/time field, it works, but if I try and calculate time using timestamp,
it doesn't.  According to abydos, if I put in the calucation, the other part
of the action changes from selecting from my form to "current
transaction"--but this is not reflected on the screen when looking at the
filter in administrator.  I came up with a work around, but I wonder if this
is expected behavior, if I'm doing something wrong, or if I found a weird
bug.  Has anyone else seen this type of thing before?

 

ARS 7.1 

ITSM 7.0.3

CMDB 2.1 p4

 

Anne Ramey

***

E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.

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

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


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

Re: WWRUG10 Submission Deadline

[Daniel Bloom]

If I hadn't torn it all out already it would be :-)

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: June 3, 2010 1:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG10 Submission Deadline


** 
I'm with Julie.  I know many of you, and I think highly of most of you, but
I can't think of 5 of you I would want to see in a swimsuit.  Including
myself.  I think if we all hung around out there in swimsuits, they'd find a
way to close it for health reasons the next day - for the health of the
other people watching us.  Hawaiian shirts and shorts should be the uniform
of the day for all but the young and fit.
 
On a completely unrelated note, has anyone ever investigated what a Twinkie
will do to a pool filter?  (That sound you hear is Dan's hair turning
grayer).
 
Rick

On Thu, Jun 3, 2010 at 10:47 AM, Julie Sellers  wrote:


** 
Come on now...do you *really* want to see some of those folks in a swimsuit.
;-O



  _  

From: Phil Bautista 
To: arslist@ARSLIST.ORG
Sent: Thu, June 3, 2010 12:17:01 AM
Subject: WWRUG10 Submission Deadline

** 

Dear ARSListers,

 

The end of May marked the half way point for the window of accepting topics
for the WWRUG10 Conference.  We will continue to accept initial topics for
consideration up until July 10th.  We are already getting some great topics
and looking forward to updates on many others.  With the schedule this year
about a month earlier, the famous Hard Rock Pool will be open so don't
forget to pack your swimming attire!

 

Here are the links to WWRUG10   and the Submissions
Page
 .  

 

Don't delay, submit today!

 

Phil Bautista, WWRUG10 Advisory Board

512-731-0304

http://www.linkedin.com/in/philbautista

http://www.wwrug.org/wwrug10/contact_phil.html

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

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


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

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

Re: Mid-tier & BOXI

[Ramey, Anne]

OK, I had a problem with IIS where I couldn't browse the arreports virtual 
directory.  That has been fixed now, so instead of getting a 500 error, I get:

HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)

?

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne
Sent: Wednesday, May 26, 2010 10:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-tier & BOXI

Ok, this is the URL it's trying to pull up:
http:///arsys/m11c23c11b16/56FB4E5FAFEA4D336FC6EE4CE9E26851/null
or
http:///crystalreportviewers11/arsys/m11c23c11b16/56FB4E5FAFEA4D336FC6EE4CE9E26851/null

Does that look right?  arsys is not the name of the reports directory or any 
part of the reports configuration.
Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne
Sent: Wednesday, May 26, 2010 9:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-tier & BOXI

I've removed the redirect and tried both the home (where the now blank default 
page is) and the /crystalreportviewers11 location, but get:
The page cannot be found

When trying to run a report, but I do get the blank index page and the 
authorization error when I access the sites directly.  I've also tried the 
/businessobjects and /enterprise11 directories (why not, at this point).  I've 
double checked that all of my servers are running in the BO, including RAS.

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of strauss
Sent: Tuesday, May 25, 2010 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-tier & BOXI

That redirect is probably the problem.  My servers have the iisstart.htm in 
them, which will display if you point a web browser at :80 or 
localhost:80, but no redirect page.

My guess is that the redirect is interfering with the DefaultAppPool where 
/crystalreportviewers11 is defined as one of the default applications (I have 
three - root, /businessobjects, and /crystalreportviewers11.  Try specifying 
the URL to the /crystalreportviewers11 location in mid-tier.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne
Sent: Tuesday, May 25, 2010 1:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-tier & BOXI

I guess that is the problem.  The IIS server that does BOXI is multi-purpose 
and doesn't just do BO.  Is there a way in BO I can tell where the Crystal/BO 
Report Engine is?  What URL to use?  Http://:80 is just a text index 
page that redirects to a login page.

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of strauss
Sent: Tuesday, May 25, 2010 1:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-tier & BOXI

Well, you only use 
http:///businessobjects/enterprise11/admin/en/admin.cwr with the 
Administrator login to go and check/set your license keys (if the BOXI 
installer did not do it for you).

The mid-tier Report Settings simply point at http://:80 on my 
machines, with the Crystal/BO Report Engine Deployment field set to 
"BOXI/Crystal Report Server 11 on this machine"

I am using Crystal Report Server XI, but it only works properly when you select 
the CMS Machine Connection Details for Business Objects Enterprise XI, where 
the settings are:

AR System ODBC Data Source
ARReports
Administrator


The CMS Machine Name is the short name for the web server, which in my case 
corresponds to the local SQL Server 2005 instance name that is hosting the 
BOE11 database.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne
Sent: Tuesday, 

Re: Curious filter issue

[Ramey, Anne]

The filter log is not helpful, it just shows the field being set to the current 
time stamp (because the value isn't being pulled from the form it's supposed to 
be because the filter is incorrectly changing to "current transaction" from the 
correct selection criteria).  I didn't grab the SQL log, I'll have to do that 
and see what it says.

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Thursday, June 03, 2010 5:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

**
Depending on what you have used to set that field, take an active link or a 
filter or escalation log and see what happens when that piece of workflow 
fires...

An SQL log might be useful too..

Joe
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 5:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue
**
I checked, it's Date/Time

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Thursday, June 03, 2010 4:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

**
Anne,

Make sure that the field you have created is not a Date Only field but a Date 
and Time field.. If its a Date Only field then your calculation should be 
$DATE$*$NumberOfDays$.

The Date Only field type uses $DATE$ and is different from the Date and Time 
field type which uses $TIMESTAMP$ for setting values to it..

Cheers

Joe
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Curious filter issue
**
I have a set fields action that just doesn't like what I'm setting the field 
to.  I'm trying to set a date field using math; I'm trying to set
Required Resolution Date (date/time field) to 
$TIMESTAMP$+(60*60*24*$NumberOfDays$)
on some custom forms and it just doesn't work.  If I set it with another 
date/time field, it works, but if I try and calculate time using timestamp, it 
doesn't.  According to abydos, if I put in the calucation, the other part of 
the action changes from selecting from my form to "current transaction"--but 
this is not reflected on the screen when looking at the filter in 
administrator.  I came up with a work around, but I wonder if this is expected 
behavior, if I'm doing something wrong, or if I found a weird bug.  Has anyone 
else seen this type of thing before?

ARS 7.1
ITSM 7.0.3
CMDB 2.1 p4

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: RKM Authentication

[Lyle Taylor]

The OOB integration of Remedy with RKM sets it up so that you don't need to do 
this.  What exactly are you trying to do?  What it boils down to is that a 
session ID must be generated and stored for the given user in the KMS:Session 
form.  This session ID then gets included in the query portion of the URL used 
to access RKM.  When RKM sees this, it validates the session ID and IP address 
the user is coming from with the one stored in Remedy.  If there is not already 
an IP address, it adds it to the groups field on the form.  If the session ID 
is found in the form, and the IP address matches (if there was already one 
there), then it uses the login stored with that session ID as the login 
credential for that session.

Lyle

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Carin Grobler
Sent: Thursday, June 03, 2010 8:10 PM
To: arslist@ARSLIST.ORG
Subject: RKM Authentication

Hi, 

Has anyone integrated RKM with Remedy and managed to pass the current user
information so it does not prompt for a user name every time.

AR Server 7.1 patch 6
RKM 7.2

Carin

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


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.

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

Re: User AR_ESCALATOR

[Mahesh]

Yeah, I agree. This will require the same amount of filters as below. I
missed the execution order in my previous post. The filter(s) should fire at
an execution order less than the one that is causing the error message and
the GOTO action should be one greater than the object causing the error.

The advantage is that you are just creating custom objects without messing
OOB work-flow and since the tag is unique, nothing is affected.

Thanks
Mahesh

On Thu, Jun 3, 2010 at 5:22 PM, Thad K Esser  wrote:

> **
> That's a good general strategy, however for this type of integration, the
> workflow on CTM:People should fire (sets up user records, default values,
> etc).  The filters listed are ones that can be safely bypassed by an
> automated process that is designed to create and/or update the people
> records.  Also note that the execution order for these filters are all over
> the place, so you'd have to put the bypass in in multiple places.
>
> *Thad Esser*
> Remedy Developer
>
>
>  From: Mahesh  To: arslist@ARSLIST.ORG Date: 06/03/2010
> 02:54 PM Subject: Re: User AR_ESCALATOR Sent by: "Action Request System
> discussion list(ARSList)" 
> --
>
>
>
> ** If you want to stay away from touching the OOB work-flow and minimize
> the maintenance effort especially during patch/version upgrade, you can do
> the following.
>
> 1. Pass a "z1D Action" tag value to the People record along with other
> values. Example: "XXX:PPL:Update". I use company abbreviation in place of
> XXX.
>
> 2. Using the above tag as "Run If" qualification, create a filter to bypass
> the workflow that is causing the issue (GOTO action).
>
> Thanks
> Mahesh
>
> On Thu, Jun 3, 2010 at 1:46 PM, Thad K Esser 
> <*tkes...@regence.com*>
> wrote:
> **
> Kevin,
>
> In order to get our integration to work, I added "AND ($USER$ !=
>  "AR_ESCALATOR" )" to the run if of the following filters (ITSM 7.0.3 p9,
> ARS 7.1)
> CTM:PPL:VerifyManageInfo_142_Msg
> CTM:PPL:GetStatusRuleSet_030
> CTM:PPL:VerifyManageInfo_141_Check
> CTM:PPL:ChkUnrestrictedAccess-Fail2_596
> CTM:PPL:ChkUnrestrictedAccess-Fail_596
>
> Also, the CTM:PPL:UpdateLoginID_795 filter uses TR values on the Remedy
> Login ID field, so if you are pushing that field to CTM:People and it hasn't
> changed, a whole bunch (no, really, a lot) of workflow will fire needlessly.
> *
> Thad Esser*
> Remedy Developer
>
>   From: "Maher, Jeff" <*jma...@fas.harvard.edu* >
> To: *arsl...@arslist.org*   Date: 06/03/2010 11:32 AM
> Subject: Re: User AR_ESCALATOR  Sent by: "Action Request System discussion
> list(ARSList)" <*arsl...@arslist.org* >
>
>  --
>
>
>
> **
>
> Hi Kevin, I had a similar issue, but it was actually caused somewhere in
> the process of upgrading to ITSM 7 patch 9 from patch 4. There was some new
> filter workflow added (or fixed so it actually did something) that now
> checks roles when creating new users, login id’s, etc. A little bit of
> logging and you can find the bugger that is missing ‘AND $USER$ !=
> “AR_ESCALATOR”’ in the qualification so your stuff will work again. However
> like Joe said, probably is a better choice to do something using the AIE. I
> didn’t really have that option in my scenario.
>   *
> From:* Action Request System discussion list(ARSList) [*
> mailto:arsl...@arslist.org* ] *On Behalf Of *Kevin
> Begosh*
> Sent:* Thursday, June 03, 2010 1:42 PM*
> To:* *arsl...@arslist.org* *
> Subject:* Re: User AR_ESCALATOR
>
> ** this was working with 7.1, we just upgraded to 7.5 and getting these
> messages now.  Good suggestion with the AIE though.
> On Thu, Jun 3, 2010 at 1:34 PM, Joe D'Souza 
> <*jdso...@shyle.net*>
> wrote:
> **
> ITSM 7 has changed a few things as to what roles are required to create and
> maintain contact information.. The roles that you see have to be added to
> the user that creates or updates this information in the CTM:People form..
>
> Instead of using escalations to do what you are doing, I would suggest
> creating a regular AR User account that has all these roles, and other
> permissions needed, and use AIE to do the same thing you are doing.. I have
> done it that way and it works well.. You can schedule AIE to run the job
> just like you are using your Escalation.. Make sure you configure AIE to use
> the user that you have created..
>
> Joe
> -Original Message-*
> From:* Action Request System discussion list(ARSList) [mailto:*
> arsl...@arslist.org* ]*On Behalf Of *Kevin Begosh*
> Sent:* Thursday, June 03, 2010 1:27 PM*
> To:* *arsl...@arslist.org*  *
> Subject:* User AR_ESCALATOR
> **
> I have a process and staging forms that pull employee data from a view form
> on remedy, send it to a staging form and then creates a people record if
> that ID does not exist on the people form.  Well it worked before and then
> we upgraded from 7.0 to 7.5 AR Server and now it is not working. We are
> getting the following error message
>
> You must have one of the following permissions to cr

Re: RKM Authentication

[Joe D'Souza]

Carin

The integration does not take the current user name.. There is a user (I
think called SelfHelp) that is created that is automatically used by RKM
that is used in the data visualization field to display the contents of the
knowledge base..

Has that user been created in RKM??

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Carin Grobler
Sent: Thursday, June 03, 2010 10:10 PM
To: arslist@ARSLIST.ORG
Subject: RKM Authentication


Hi,

Has anyone integrated RKM with Remedy and managed to pass the current user
information so it does not prompt for a user name every time.

AR Server 7.1 patch 6
RKM 7.2

Carin

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

RKM Authentication

[Carin Grobler]

Hi, 

Has anyone integrated RKM with Remedy and managed to pass the current user
information so it does not prompt for a user name every time.

AR Server 7.1 patch 6
RKM 7.2

Carin

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

Re: User AR_ESCALATOR

[Thad K Esser]

**
That's a good general strategy, however
for this type of integration, the workflow on CTM:People should fire (sets
up user records, default values, etc).  The filters listed are ones
that can be safely bypassed by an automated process that is designed to
create and/or update the people records.  Also note that the execution
order for these filters are all over the place, so you'd have to put the
bypass in in multiple places.

Thad Esser
Remedy Developer





From:
Mahesh 

To:
arslist@ARSLIST.ORG

Date:
06/03/2010 02:54 PM

Subject:
Re: User AR_ESCALATOR

Sent by:
"Action Request System discussion
list(ARSList)" 




** If you want to stay
away from touching the OOB work-flow and minimize the maintenance effort
especially during patch/version upgrade, you can do the following.

1. Pass a "z1D Action" tag value to the People record along with
other values. Example: "XXX:PPL:Update". I use company abbreviation
in place of XXX.

2. Using the above tag as "Run If" qualification, create a filter
to bypass the workflow that is causing the issue (GOTO action).

Thanks
Mahesh

On Thu, Jun 3, 2010 at 1:46 PM, Thad K Esser 
wrote:
** 
Kevin, 

In order to get our integration to work, I added "AND ($USER$ !=  "AR_ESCALATOR"
)" to the run if of the following filters (ITSM 7.0.3 p9, ARS 7.1)

CTM:PPL:VerifyManageInfo_142_Msg 
CTM:PPL:GetStatusRuleSet_030 
CTM:PPL:VerifyManageInfo_141_Check 
CTM:PPL:ChkUnrestrictedAccess-Fail2_596 
CTM:PPL:ChkUnrestrictedAccess-Fail_596 

Also, the CTM:PPL:UpdateLoginID_795 filter uses TR values on the Remedy
Login ID field, so if you are pushing that field to CTM:People and it hasn't
changed, a whole bunch (no, really, a lot) of workflow will fire needlessly.


Thad Esser
Remedy Developer 




From:

"Maher, Jeff" 


To:

arslist@ARSLIST.ORG


Date:

06/03/2010 11:32 AM


Subject:

Re: User AR_ESCALATOR


Sent by:

"Action Request System discussion
list(ARSList)" 





** 
 

Hi Kevin, I had a similar issue, but it was actually caused somewhere in
the process of upgrading to ITSM 7 patch 9 from patch 4. There was some
new filter workflow added (or fixed so it actually did something) that
now checks roles when creating new users, login id’s, etc. A little bit
of logging and you can find the bugger that is missing ‘AND $USER$ !=
“AR_ESCALATOR”’ in the qualification so your stuff will work again.
However like Joe said, probably is a better choice to do something using
the AIE. I didn’t really have that option in my scenario.

  
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Kevin Begosh
Sent: Thursday, June 03, 2010 1:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: User AR_ESCALATOR 
  
** this was working with 7.1, we just upgraded to 7.5 and getting these
messages now.  Good suggestion with the AIE though.

On Thu, Jun 3, 2010 at 1:34 PM, Joe D'Souza 
wrote: 
** 
ITSM 7 has changed a few things as to what roles are required to create
and maintain contact information.. The roles that you see have to be added
to the user that creates or updates this information in the CTM:People
form.. 
  
Instead of using escalations to do what you are doing, I would suggest
creating a regular AR User account that has all these roles, and other
permissions needed, and use AIE to do the same thing you are doing.. I
have done it that way and it works well.. You can schedule AIE to run the
job just like you are using your Escalation.. Make sure you configure AIE
to use the user that you have created.. 
  
Joe 
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On
Behalf Of Kevin Begosh
Sent: Thursday, June 03, 2010 1:27 PM
To: arslist@ARSLIST.ORG

Subject: User AR_ESCALATOR 
** 
I have a process and staging forms that pull employee data from a view
form on remedy, send it to a staging form and then creates a people record
if that ID does not exist on the people form.  Well it worked before
and then we upgraded from 7.0 to 7.5 AR Server and now it is not working.
We are getting the following error message 
  
You must have one of the following permissions to create a person with
a login ID: 'Contact Organization Admin', 'Contact Support Admin'. (ARERR
45530) 
  
and none of the profiles are being create.  Has something change with
AR_ESCALATOR between 7.0 and 7.5?  Am I missing something?

  
ARS 7.5 Patch 4 
ITSM 7.03 Patch 9 
CMDB 7.6 Patch 1

-- 
Kevin Begosh 
_attend WWRUG10 www.wwrug.com
ARSlist: "Where the Answers Are"_ 



-- 
Kevin Begosh
_attend WWRUG10 www.wwrug.com
ARSlist: "Where the Answers Are"_ 
_attend WWRUG10 www.wwrug.com
ARSlist: "Where the Answers Are"_ 
*IMPORTANT NOTICE: This communication, including any attachment,
contains information that may be confidential or privileged, and is intended
solely for the entity or individual to whom it is addressed. If you are
not the intended recipient, you should 

Re: Curious filter issue

[Joe D'Souza]

Depending on what you have used to set that field, take an active link or a
filter or escalation log and see what happens when that piece of workflow
fires...

An SQL log might be useful too..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
  Sent: Thursday, June 03, 2010 5:49 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Curious filter issue


  **
  I checked, it's Date/Time



  Anne Ramey

  ***

  E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.



  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
  Sent: Thursday, June 03, 2010 4:36 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Curious filter issue



  **

  Anne,



  Make sure that the field you have created is not a Date Only field but a
Date and Time field.. If its a Date Only field then your calculation should
be $DATE$*$NumberOfDays$.



  The Date Only field type uses $DATE$ and is different from the Date and
Time field type which uses $TIMESTAMP$ for setting values to it..



  Cheers



  Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Curious filter issue

**

I have a set fields action that just doesn't like what I'm setting the
field to.  I'm trying to set a date field using math; I'm trying to set

Required Resolution Date (date/time field) to
$TIMESTAMP$+(60*60*24*$NumberOfDays$)

on some custom forms and it just doesn't work.  If I set it with another
date/time field, it works, but if I try and calculate time using timestamp,
it doesn't.  According to abydos, if I put in the calucation, the other part
of the action changes from selecting from my form to "current
transaction"--but this is not reflected on the screen when looking at the
filter in administrator.  I came up with a work around, but I wonder if this
is expected behavior, if I'm doing something wrong, or if I found a weird
bug.  Has anyone else seen this type of thing before?



ARS 7.1

ITSM 7.0.3

CMDB 2.1 p4



Anne Ramey

***

E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties only
by an authorized State Official.

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

Re: User AR_ESCALATOR

[Mahesh]

If you want to stay away from touching the OOB work-flow and minimize the
maintenance effort especially during patch/version upgrade, you can do the
following.

1. Pass a "z1D Action" tag value to the People record along with other
values. Example: "XXX:PPL:Update". I use company abbreviation in place of
XXX.

2. Using the above tag as "Run If" qualification, create a filter to bypass
the workflow that is causing the issue (GOTO action).

Thanks
Mahesh

On Thu, Jun 3, 2010 at 1:46 PM, Thad K Esser  wrote:

> **
> Kevin,
>
> In order to get our integration to work, I added "AND ($USER$ !=
>  "AR_ESCALATOR" )" to the run if of the following filters (ITSM 7.0.3 p9,
> ARS 7.1)
> CTM:PPL:VerifyManageInfo_142_Msg
> CTM:PPL:GetStatusRuleSet_030
> CTM:PPL:VerifyManageInfo_141_Check
> CTM:PPL:ChkUnrestrictedAccess-Fail2_596
> CTM:PPL:ChkUnrestrictedAccess-Fail_596
>
> Also, the CTM:PPL:UpdateLoginID_795 filter uses TR values on the Remedy
> Login ID field, so if you are pushing that field to CTM:People and it hasn't
> changed, a whole bunch (no, really, a lot) of workflow will fire needlessly.
>
> *Thad Esser*
> Remedy Developer
>
>
>  From: "Maher, Jeff"  To: arslist@ARSLIST.ORG
> Date: 06/03/2010 11:32 AM Subject: Re: User AR_ESCALATOR Sent by: "Action
> Request System discussion list(ARSList)" 
> --
>
>
>
> **
>
> Hi Kevin, I had a similar issue, but it was actually caused somewhere in
> the process of upgrading to ITSM 7 patch 9 from patch 4. There was some new
> filter workflow added (or fixed so it actually did something) that now
> checks roles when creating new users, login id’s, etc. A little bit of
> logging and you can find the bugger that is missing ‘AND $USER$ !=
> “AR_ESCALATOR”’ in the qualification so your stuff will work again. However
> like Joe said, probably is a better choice to do something using the AIE. I
> didn’t really have that option in my scenario.
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Kevin
> Begosh*
> Sent:* Thursday, June 03, 2010 1:42 PM*
> To:* arsl...@arslist.org*
> Subject:* Re: User AR_ESCALATOR
>
> ** this was working with 7.1, we just upgraded to 7.5 and getting these
> messages now.  Good suggestion with the AIE though.
> On Thu, Jun 3, 2010 at 1:34 PM, Joe D'Souza 
> <*jdso...@shyle.net*>
> wrote:
> **
> ITSM 7 has changed a few things as to what roles are required to create and
> maintain contact information.. The roles that you see have to be added to
> the user that creates or updates this information in the CTM:People form..
>
> Instead of using escalations to do what you are doing, I would suggest
> creating a regular AR User account that has all these roles, and other
> permissions needed, and use AIE to do the same thing you are doing.. I have
> done it that way and it works well.. You can schedule AIE to run the job
> just like you are using your Escalation.. Make sure you configure AIE to use
> the user that you have created..
>
> Joe
> -Original Message-*
> From:* Action Request System discussion list(ARSList) [mailto:*
> arsl...@arslist.org* ]*On Behalf Of *Kevin Begosh*
> Sent:* Thursday, June 03, 2010 1:27 PM*
> To:* *arsl...@arslist.org* 
> *Subject:* User AR_ESCALATOR
> **
> I have a process and staging forms that pull employee data from a view form
> on remedy, send it to a staging form and then creates a people record if
> that ID does not exist on the people form.  Well it worked before and then
> we upgraded from 7.0 to 7.5 AR Server and now it is not working. We are
> getting the following error message
>
> You must have one of the following permissions to create a person with a
> login ID: 'Contact Organization Admin', 'Contact Support Admin'. (ARERR
> 45530)
>
> and none of the profiles are being create.  Has something change with
> AR_ESCALATOR between 7.0 and 7.5?  Am I missing something?
>
> ARS 7.5 Patch 4
> ITSM 7.03 Patch 9
> CMDB 7.6 Patch 1
>
> --
> Kevin Begosh
> _attend WWRUG10 *www.wwrug.com*  ARSlist: "Where
> the Answers Are"_
>
>
>
> --
> Kevin Begosh
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>  *IMPORTANT NOTICE: This communication, including any attachment, contains
> information that may be confidential or privileged, and is intended solely
> for the entity or individual to whom it is addressed. If you are not the
> intended recipient, you should delete this message and are hereby notified
> that any disclosure, copying, or distribution of this message is strictly
> prohibited. Nothing in this email, including any attachment, is intended to
> be a legally binding signature. *
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "W

Re: IIS config being corrupted

[Joe D'Souza]

Anything that gets written to the Windows Event log (Application, System,
etc) at the time the server goes down? Anything that you see in those same
logs at the time that you attempt to bring up the server once it is down but
when it fails to come back up?

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Smith, Ron [TBC]
Sent: Thursday, June 03, 2010 5:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: IIS config being corrupted


Oh yeah, I guess I should have included that.  We are running ServletExec
5.0, which was the preferred Servlet engine back then.

Thanks,

Ron Smith
Remedy/Web Developer
Providence Health & Services OR
ron.sm...@providence.org
503-216-7866

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Chuck
Sent: Thursday, June 03, 2010 2:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: IIS config being corrupted

If you are using Tomcat, then Use Apache web server. OR don't use Apache,
use Tomcat on Port 80 w/APR it will serve files just as fast. But if you
need a web server for other reasons, then try Apache - Tomcat combination,
the Mod)JK AJP protocol between Apache and Tomcat is a bit faster than the
IIS Tomcat redirector ISAPI.

On Jun 3, 3:45 pm, "Smith, Ron [TBC]" 
wrote:
> We have two brand new Win 2003 VMWare instances that serve as our Midtier
servers.  We are running version 6.3 Patch 21 of both Midtier and AR server.
These were brought up in January, one for our Production environment and one
for our Development environment.  Back in April, our Production servers IIS
configuration became corrupt.  It would not start back up.  In the event
logs, we saw that it was a slow degradation starting a 7-10 days prior,
where it began having to restart IIS.  After that period, IIS would no
longer start up and our users got the error of Service Unavailable.  We
swapped our Dev server into Prod, and rebuilt the old Prod server into the
new Dev server.  Another 6 weeks go by and the new Prod Server had the same
issue, completely shutting down on Memorial day.  So we swapped out the
servers again, taking the Dev server and making it the Prod server.  I have
a gut feeling that we will see this again.  The previous servers were
running Windows 2000, and ran flawlessly for 5 years.  We are tentatively
upgrading later this year, but I really do not want to go through this
exercise  every 6 weeks until we finally have them upgraded.
>
> Has anyone seen this kind of behavior?
>
> Thanks in advance,
>
> Ron Smith
> Remedy/Web Developer
> Providence Health & Services OR
> ron.sm...@providence.org
> 503-216-7866

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

Re: Curious filter issue

[Ramey, Anne]

I checked, it's Date/Time

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Thursday, June 03, 2010 4:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Curious filter issue

**
Anne,

Make sure that the field you have created is not a Date Only field but a Date 
and Time field.. If its a Date Only field then your calculation should be 
$DATE$*$NumberOfDays$.

The Date Only field type uses $DATE$ and is different from the Date and Time 
field type which uses $TIMESTAMP$ for setting values to it..

Cheers

Joe
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
Sent: Thursday, June 03, 2010 3:49 PM
To: arslist@ARSLIST.ORG
Subject: Curious filter issue
**
I have a set fields action that just doesn't like what I'm setting the field 
to.  I'm trying to set a date field using math; I'm trying to set
Required Resolution Date (date/time field) to 
$TIMESTAMP$+(60*60*24*$NumberOfDays$)
on some custom forms and it just doesn't work.  If I set it with another 
date/time field, it works, but if I try and calculate time using timestamp, it 
doesn't.  According to abydos, if I put in the calucation, the other part of 
the action changes from selecting from my form to "current transaction"--but 
this is not reflected on the screen when looking at the filter in 
administrator.  I came up with a work around, but I wonder if this is expected 
behavior, if I'm doing something wrong, or if I found a weird bug.  Has anyone 
else seen this type of thing before?

ARS 7.1
ITSM 7.0.3
CMDB 2.1 p4

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: IIS config being corrupted

[Smith, Ron [TBC]]

Oh yeah, I guess I should have included that.  We are running ServletExec 5.0, 
which was the preferred Servlet engine back then.

Thanks,

Ron Smith
Remedy/Web Developer
Providence Health & Services OR
ron.sm...@providence.org
503-216-7866

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Chuck
Sent: Thursday, June 03, 2010 2:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: IIS config being corrupted

If you are using Tomcat, then Use Apache web server. OR don't use
Apache, use Tomcat on Port 80 w/APR it will serve files just as fast.
But if you need a web server for other reasons, then try Apache -
Tomcat combination, the Mod)JK AJP protocol between Apache and Tomcat
is a bit faster than the IIS Tomcat redirector ISAPI.

On Jun 3, 3:45 pm, "Smith, Ron [TBC]" 
wrote:
> We have two brand new Win 2003 VMWare instances that serve as our Midtier 
> servers.  We are running version 6.3 Patch 21 of both Midtier and AR server.  
> These were brought up in January, one for our Production environment and one 
> for our Development environment.  Back in April, our Production servers IIS 
> configuration became corrupt.  It would not start back up.  In the event 
> logs, we saw that it was a slow degradation starting a 7-10 days prior, where 
> it began having to restart IIS.  After that period, IIS would no longer start 
> up and our users got the error of Service Unavailable.  We swapped our Dev 
> server into Prod, and rebuilt the old Prod server into the new Dev server.  
> Another 6 weeks go by and the new Prod Server had the same issue, completely 
> shutting down on Memorial day.  So we swapped out the servers again, taking 
> the Dev server and making it the Prod server.  I have a gut feeling that we 
> will see this again.  The previous servers were running Windows 2000, and ran 
> flawlessly for 5 years.  We are tentatively upgrading later this year, but I 
> really do not want to go through this exercise  every 6 weeks until we 
> finally have them upgraded.
>
> Has anyone seen this kind of behavior?
>
> Thanks in advance,
>
> Ron Smith
> Remedy/Web Developer
> Providence Health & Services OR
> ron.sm...@providence.org
> 503-216-7866
>
>   
> This message is intended for the sole use of the addressee, and may contain 
> information that is privileged, confidential and exempt from disclosure under 
> applicable law. If you are not the addressee you are hereby notified that you 
> may not use, copy, disclose, or distribute to anyone the message or any 
> information contained in the message. If you have received this message in 
> error, please immediately advise the sender by reply email and delete this 
> message.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

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


This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the sender by reply email and delete this 
message.

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

Re: IIS config being corrupted

[Chuck]

If you are using Tomcat, then Use Apache web server. OR don't use
Apache, use Tomcat on Port 80 w/APR it will serve files just as fast.
But if you need a web server for other reasons, then try Apache -
Tomcat combination, the Mod)JK AJP protocol between Apache and Tomcat
is a bit faster than the IIS Tomcat redirector ISAPI.

On Jun 3, 3:45 pm, "Smith, Ron [TBC]" 
wrote:
> We have two brand new Win 2003 VMWare instances that serve as our Midtier 
> servers.  We are running version 6.3 Patch 21 of both Midtier and AR server.  
> These were brought up in January, one for our Production environment and one 
> for our Development environment.  Back in April, our Production servers IIS 
> configuration became corrupt.  It would not start back up.  In the event 
> logs, we saw that it was a slow degradation starting a 7-10 days prior, where 
> it began having to restart IIS.  After that period, IIS would no longer start 
> up and our users got the error of Service Unavailable.  We swapped our Dev 
> server into Prod, and rebuilt the old Prod server into the new Dev server.  
> Another 6 weeks go by and the new Prod Server had the same issue, completely 
> shutting down on Memorial day.  So we swapped out the servers again, taking 
> the Dev server and making it the Prod server.  I have a gut feeling that we 
> will see this again.  The previous servers were running Windows 2000, and ran 
> flawlessly for 5 years.  We are tentatively upgrading later this year, but I 
> really do not want to go through this exercise  every 6 weeks until we 
> finally have them upgraded.
>
> Has anyone seen this kind of behavior?
>
> Thanks in advance,
>
> Ron Smith
> Remedy/Web Developer
> Providence Health & Services OR
> ron.sm...@providence.org
> 503-216-7866
>
>   
> This message is intended for the sole use of the addressee, and may contain 
> information that is privileged, confidential and exempt from disclosure under 
> applicable law. If you are not the addressee you are hereby notified that you 
> may not use, copy, disclose, or distribute to anyone the message or any 
> information contained in the message. If you have received this message in 
> error, please immediately advise the sender by reply email and delete this 
> message.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

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

IIS config being corrupted

[Smith, Ron [TBC]]

We have two brand new Win 2003 VMWare instances that serve as our Midtier 
servers.  We are running version 6.3 Patch 21 of both Midtier and AR server.  
These were brought up in January, one for our Production environment and one 
for our Development environment.  Back in April, our Production servers IIS 
configuration became corrupt.  It would not start back up.  In the event logs, 
we saw that it was a slow degradation starting a 7-10 days prior, where it 
began having to restart IIS.  After that period, IIS would no longer start up 
and our users got the error of Service Unavailable.  We swapped our Dev server 
into Prod, and rebuilt the old Prod server into the new Dev server.  Another 6 
weeks go by and the new Prod Server had the same issue, completely shutting 
down on Memorial day.  So we swapped out the servers again, taking the Dev 
server and making it the Prod server.  I have a gut feeling that we will see 
this again.  The previous servers were running Windows 2000, and ran flawlessly 
for 5 years.  We are tentatively upgrading later this year, but I really do not 
want to go through this exercise  every 6 weeks until we finally have them 
upgraded.

Has anyone seen this kind of behavior?

Thanks in advance,

Ron Smith
Remedy/Web Developer
Providence Health & Services OR
ron.sm...@providence.org
503-216-7866



  
This message is intended for the sole use of the addressee, and may contain 
information that is privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby notified that you 
may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in 
error, please immediately advise the sender by reply email and delete this 
message.

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

Re: Curious filter issue

[Joe D'Souza]

Anne,

Make sure that the field you have created is not a Date Only field but a
Date and Time field.. If its a Date Only field then your calculation should
be $DATE$*$NumberOfDays$.

The Date Only field type uses $DATE$ and is different from the Date and Time
field type which uses $TIMESTAMP$ for setting values to it..

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne
  Sent: Thursday, June 03, 2010 3:49 PM
  To: arslist@ARSLIST.ORG
  Subject: Curious filter issue


  **
  I have a set fields action that just doesn't like what I'm setting the
field to.  I'm trying to set a date field using math; I'm trying to set

  Required Resolution Date (date/time field) to
$TIMESTAMP$+(60*60*24*$NumberOfDays$)

  on some custom forms and it just doesn't work.  If I set it with another
date/time field, it works, but if I try and calculate time using timestamp,
it doesn't.  According to abydos, if I put in the calucation, the other part
of the action changes from selecting from my form to "current
transaction"--but this is not reflected on the screen when looking at the
filter in administrator.  I came up with a work around, but I wonder if this
is expected behavior, if I'm doing something wrong, or if I found a weird
bug.  Has anyone else seen this type of thing before?



  ARS 7.1

  ITSM 7.0.3

  CMDB 2.1 p4



  Anne Ramey



  ***

  E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.

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

Re: Question on entry in AR.CFG file...

[Richard Copits]

Great! Thank you!

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Thursday, June 03, 2010 3:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question on entry in AR.CFG file...

** I believe those entries are for the types of approval notifications which 
can be used. Look in the AP Administration area of ITSM and look under Server 
Settings (or something like that). You will get a dialog box listing all of the 
different notifications and there status.

On Thu, Jun 3, 2010 at 3:26 PM, Richard Copits 
mailto:richard@bwc.state.oh.us>> wrote:
**
In the ar.cfg file on a 7.5 system there area number of entries 
"Approval-Notify: n1.n2" where n1 seems to range from 3 to 29 and
except for one entry n2 is 0. The only entry that is non-zero for n2 is 113675. 
Can someone tell me what these are related to and
where I can find out more about them? Google didn't help except to show one 
other person with an error  Thanks.
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers 
Are"_

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

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

Curious filter issue

[Ramey, Anne]

I have a set fields action that just doesn't like what I'm setting the field 
to.  I'm trying to set a date field using math; I'm trying to set
Required Resolution Date (date/time field) to 
$TIMESTAMP$+(60*60*24*$NumberOfDays$)
on some custom forms and it just doesn't work.  If I set it with another 
date/time field, it works, but if I try and calculate time using timestamp, it 
doesn't.  According to abydos, if I put in the calucation, the other part of 
the action changes from selecting from my form to "current transaction"--but 
this is not reflected on the screen when looking at the filter in 
administrator.  I came up with a work around, but I wonder if this is expected 
behavior, if I'm doing something wrong, or if I found a weird bug.  Has anyone 
else seen this type of thing before?

ARS 7.1
ITSM 7.0.3
CMDB 2.1 p4

Anne Ramey

***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


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

Re: Question on entry in AR.CFG file...

[Frank Caruso]

I believe those entries are for the types of approval notifications which
can be used. Look in the AP Administration area of ITSM and look under
Server Settings (or something like that). You will get a dialog box listing
all of the different notifications and there status.


On Thu, Jun 3, 2010 at 3:26 PM, Richard Copits
wrote:

> **
>
> In the ar.cfg file on a 7.5 system there area number of entries
> “Approval-Notify: n1.n2” where n1 seems to range from 3 to 29 and
>
> except for one entry n2 is 0. The only entry that is non-zero for n2 is
> 113675. Can someone tell me what these are related to and
>
> where I can find out more about them? Google didn’t help except to show
> one other person with an error …. Thanks.
>  _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

7.5 ODBC Driver

[Kathy Morris]

Hi,
 
We just want to test the 7.5 ODBC driver on a desktop that does not have  
the Remedy user client installed.  How do I get the 7.5 ODBC driver for  
testing.
We can not install the client user tool for testing purposes.
 
 

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

Question on entry in AR.CFG file...

[Richard Copits]

In the ar.cfg file on a 7.5 system there area number of entries 
"Approval-Notify: n1.n2" where n1 seems to range from 3 to 29 and
except for one entry n2 is 0. The only entry that is non-zero for n2 is 113675. 
Can someone tell me what these are related to and
where I can find out more about them? Google didn't help except to show one 
other person with an error  Thanks.

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

Re: Tickets creation through API

[Donald Morton]

I'd suggest two things:

First, check the arapi log for your arserverd. Grep for your processes  
userid, and check the timings in between the API calls. If the create  
call only takes a few seconds to resolve, then you know that workflow  
and database stuff isn't your issue. This can help you narrow down  
where the bottleneck is.


Secondly, set up a private thread in the admin console, and change  
your program to connect to that thread's port. That can help a lot,  
because your not competing with other clients for the attention of the  
arserverd.


Sent from my iPod

On Jun 3, 2010, at 12:54 PM, SriSamSri Appecherla > wrote:



**
Hi Joe,

Thanks for the mail. My ARS 7.5, works on a multi tenancy mode. The  
Event Monitoring system triggers the Java API which in turn creates  
tickets.Taking this into consideration, 25 tickets in a minute  
appears to be a very small number as the events being generated,  
though suppressed when duplicates, are generally large in number  
(about 1000 non duplicate events per minute).


If anyone has worked with tickets creation using Java API, I want to  
know how many tickets per minute at max can be created that Remedy  
can handle.


Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008


On Thu, Jun 3, 2010 at 11:10 PM, Joe D'Souza   
wrote:

**
When an incident is getting created, there are several searched that  
are run across various tables for various things.. Take a filter log  
to check all these and make sure that these searches are all  
optimized.. In the recent versions I have not found problems with  
the OTB searches, but maybe you have some customizations done that  
run some customized workflow that performs a search that is not  
optimized?


Optimizing all this would reduce the time an incident takes to get  
created. And if everything checks out and 25 is the best you can get  
to in a minute, I would think it is a good enough number no?


If you really have 25 automated incidents to be created in a minute  
in your system, you are either a really big company or a small  
company with lots of problems :-) Kidding..


Joe
-Original Message-
From: Action Request System discussion list(ARSList)  
[mailto:arsl...@arslist.org]on Behalf Of SriSamSri Appecherla

Sent: Thursday, June 03, 2010 1:24 PM
To: arslist@ARSLIST.ORG
Subject: Tickets creation through API

**
Hi Listers,

I am trying to create Incidents in Remedy using Java API using  
single login (with fixed license) but multiple threads. I am able to  
create about 25 Incidents in a minute. Can this count be increased?  
What are the configurations that I need to look into?


Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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


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

Re: Tickets creation through API

[Chuck]

Also you may want to do the following:
Best Practice for Automated Agents creating tickets into Remedy is to
put them on a Private Server and set the number of threads to a value
that will take care of the processing of the tickets in a timely
manner but not swamp the server

On Jun 3, 12:23 pm, SriSamSri Appecherla 
wrote:
> Hi Listers,
>
> I am trying to create Incidents in Remedy using Java API using single login
> (with fixed license) but multiple threads. I am able to create about 25
> Incidents in a minute. Can this count be increased? What are the
> configurations that I need to look into?
>
> Regards,
> SriSamSri Appecherla
> Mobile# +91 991 610 6008
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

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

Re: User AR_ESCALATOR

[Thad K Esser]

**
Kevin,

In order to get our integration to work,
I added "AND ($USER$ !=  "AR_ESCALATOR" )" to
the run if of the following filters (ITSM 7.0.3 p9, ARS 7.1)
CTM:PPL:VerifyManageInfo_142_Msg
CTM:PPL:GetStatusRuleSet_030
CTM:PPL:VerifyManageInfo_141_Check
CTM:PPL:ChkUnrestrictedAccess-Fail2_596
CTM:PPL:ChkUnrestrictedAccess-Fail_596

Also, the CTM:PPL:UpdateLoginID_795
filter uses TR values on the Remedy Login ID field, so if you are pushing
that field to CTM:People and it hasn't changed, a whole bunch (no, really,
a lot) of workflow will fire needlessly.

Thad Esser
Remedy Developer





From:
"Maher, Jeff" 

To:
arslist@ARSLIST.ORG

Date:
06/03/2010 11:32 AM

Subject:
Re: User AR_ESCALATOR

Sent by:
"Action Request System discussion
list(ARSList)" 




** 
 
Hi Kevin, I had a similar
issue, but it was actually caused somewhere in the process of upgrading
to ITSM 7 patch 9 from patch 4. There was some new filter workflow added
(or fixed so it actually did something) that now checks roles when creating
new users, login id’s, etc. A little bit of logging and you can find the
bugger that is missing ‘AND $USER$ != “AR_ESCALATOR”’ in the qualification
so your stuff will work again. However like Joe said, probably is a better
choice to do something using the AIE. I didn’t really have that option
in my scenario.
 
From: Action Request System discussion
list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Kevin Begosh
Sent: Thursday, June 03, 2010 1:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: User AR_ESCALATOR
 
** this was working with 7.1, we
just upgraded to 7.5 and getting these messages now.  Good suggestion
with the AIE though.
On Thu, Jun 3, 2010 at 1:34 PM,
Joe D'Souza 
wrote:
** 
ITSM 7 has changed a
few things as to what roles are required to create and maintain contact
information.. The roles that you see have to be added to the user that
creates or updates this information in the CTM:People form..
 
Instead of using escalations
to do what you are doing, I would suggest creating a regular AR User account
that has all these roles, and other permissions needed, and use AIE to
do the same thing you are doing.. I have done it that way and it works
well.. You can schedule AIE to run the job just like you are using your
Escalation.. Make sure you configure AIE to use the user that you have
created..
 
Joe
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On
Behalf Of Kevin Begosh
Sent: Thursday, June 03, 2010 1:27 PM
To: arslist@ARSLIST.ORG
Subject: User AR_ESCALATOR
** 
I have a process and staging forms
that pull employee data from a view form on remedy, send it to a staging
form and then creates a people record if that ID does not exist on the
people form.  Well it worked before and then we upgraded from 7.0
to 7.5 AR Server and now it is not working. We are getting the following
error message
 
You must have one of the following
permissions to create a person with a login ID: 'Contact Organization Admin',
'Contact Support Admin'. (ARERR 45530)
 
and none of the profiles are being
create.  Has something change with AR_ESCALATOR between 7.0 and 7.5?
 Am I missing something?
 
ARS 7.5 Patch 4
ITSM 7.03 Patch 9
CMDB 7.6 Patch 1

-- 
Kevin Begosh
_attend WWRUG10 www.wwrug.com
ARSlist: "Where the Answers Are"_ 



-- 
Kevin Begosh
_attend WWRUG10 www.wwrug.com
ARSlist: "Where the Answers Are"_ 
_attend WWRUG10 www.wwrug.com
ARSlist: "Where the Answers Are"_ 



*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed.  If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited.  Nothing in this email, including any attachment, is intended to be a legally binding signature.
*

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

Re: WWRUG10 Submission Deadline

[Shellman, David]

Well we are attempting to draw a larger group this year.  Maybe after a few 
beers at night with engineering ...  Maybe I shouldn't go there.

Twinkies.  Pool filter.  Twinkies - a sponge like substance.  Hmmm.  Now I have 
to ask what made you think of this combination.

Dave

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: Thursday, June 03, 2010 1:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG10 Submission Deadline

**
I'm with Julie.  I know many of you, and I think highly of most of you, but I 
can't think of 5 of you I would want to see in a swimsuit.  Including myself.  
I think if we all hung around out there in swimsuits, they'd find a way to 
close it for health reasons the next day - for the health of the other people 
watching us.  Hawaiian shirts and shorts should be the uniform of the day for 
all but the young and fit.

On a completely unrelated note, has anyone ever investigated what a Twinkie 
will do to a pool filter?  (That sound you hear is Dan's hair turning grayer).

Rick
On Thu, Jun 3, 2010 at 10:47 AM, Julie Sellers 
mailto:julsell...@yahoo.com>> wrote:
**
Come on now...do you *really* want to see some of those folks in a swimsuit.
;-O


From: Phil Bautista mailto:bauti...@bullcreek.com>>
To: arslist@ARSLIST.ORG
Sent: Thu, June 3, 2010 12:17:01 AM
Subject: WWRUG10 Submission Deadline

**
Dear ARSListers,

The end of May marked the half way point for the window of accepting topics for 
the WWRUG10 Conference.  We will continue to accept initial topics for 
consideration up until July 10th.  We are already getting some great topics and 
looking forward to updates on many others.  With the schedule this year about a 
month earlier, the famous Hard Rock Pool will be open so don't forget to pack 
your swimming attire!

Here are the links to WWRUG10 and the Submissions 
Page.

Don't delay, submit today!

Phil Bautista, WWRUG10 Advisory Board
512-731-0304
http://www.linkedin.com/in/philbautista
http://www.wwrug.org/wwrug10/contact_phil.html
_attend WWRUG10 www.wwrug.com ARSlist: "Where the 
Answers Are"_

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

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

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

Re: User AR_ESCALATOR

[Maher, Jeff]

Hi Kevin, I had a similar issue, but it was actually caused somewhere in the 
process of upgrading to ITSM 7 patch 9 from patch 4. There was some new filter 
workflow added (or fixed so it actually did something) that now checks roles 
when creating new users, login id's, etc. A little bit of logging and you can 
find the bugger that is missing 'AND $USER$ != "AR_ESCALATOR"' in the 
qualification so your stuff will work again. However like Joe said, probably is 
a better choice to do something using the AIE. I didn't really have that option 
in my scenario.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh
Sent: Thursday, June 03, 2010 1:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: User AR_ESCALATOR

** this was working with 7.1, we just upgraded to 7.5 and getting these 
messages now.  Good suggestion with the AIE though.
On Thu, Jun 3, 2010 at 1:34 PM, Joe D'Souza 
mailto:jdso...@shyle.net>> wrote:
**
ITSM 7 has changed a few things as to what roles are required to create and 
maintain contact information.. The roles that you see have to be added to the 
user that creates or updates this information in the CTM:People form..

Instead of using escalations to do what you are doing, I would suggest creating 
a regular AR User account that has all these roles, and other permissions 
needed, and use AIE to do the same thing you are doing.. I have done it that 
way and it works well.. You can schedule AIE to run the job just like you are 
using your Escalation.. Make sure you configure AIE to use the user that you 
have created..

Joe
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG]On Behalf Of Kevin 
Begosh
Sent: Thursday, June 03, 2010 1:27 PM
To: arslist@ARSLIST.ORG
Subject: User AR_ESCALATOR
**
I have a process and staging forms that pull employee data from a view form on 
remedy, send it to a staging form and then creates a people record if that ID 
does not exist on the people form.  Well it worked before and then we upgraded 
from 7.0 to 7.5 AR Server and now it is not working. We are getting the 
following error message

You must have one of the following permissions to create a person with a login 
ID: 'Contact Organization Admin', 'Contact Support Admin'. (ARERR 45530)

and none of the profiles are being create.  Has something change with 
AR_ESCALATOR between 7.0 and 7.5?  Am I missing something?

ARS 7.5 Patch 4
ITSM 7.03 Patch 9
CMDB 7.6 Patch 1

--
Kevin Begosh
_attend WWRUG10 www.wwrug.com ARSlist: "Where the 
Answers Are"_



--
Kevin Begosh
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: Tickets creation through API

[LJ LongWing]

SriSamSri,

I don't work with the OOTB apps at all, and I know that's what you are
talking about.but one thing you WILL want to tweak is the 'next id chunk
size' because with that volume of submits, the ARSchema table quickly
becomes a bottleneck..

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla
Sent: Thursday, June 03, 2010 11:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Tickets creation through API

 

** 

Hi Joe,

 

Thanks for the mail. My ARS 7.5, works on a multi tenancy mode. The Event
Monitoring system triggers the Java API which in turn creates tickets.Taking
this into consideration, 25 tickets in a minute appears to be a very small
number as the events being generated, though suppressed when duplicates, are
generally large in number (about 1000 non duplicate events per minute). 

 

If anyone has worked with tickets creation using Java API, I want to know
how many tickets per minute at max can be created that Remedy can handle.


Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008



On Thu, Jun 3, 2010 at 11:10 PM, Joe D'Souza  wrote:

** 

When an incident is getting created, there are several searched that are run
across various tables for various things.. Take a filter log to check all
these and make sure that these searches are all optimized.. In the recent
versions I have not found problems with the OTB searches, but maybe you have
some customizations done that run some customized workflow that performs a
search that is not optimized?

 

Optimizing all this would reduce the time an incident takes to get created.
And if everything checks out and 25 is the best you can get to in a minute,
I would think it is a good enough number no?

 

If you really have 25 automated incidents to be created in a minute in your
system, you are either a really big company or a small company with lots of
problems :-) Kidding..

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of SriSamSri Appecherla
Sent: Thursday, June 03, 2010 1:24 PM
To: arslist@ARSLIST.ORG

Subject: Tickets creation through API

** 

Hi Listers,

 

I am trying to create Incidents in Remedy using Java API using single login
(with fixed license) but multiple threads. I am able to create about 25
Incidents in a minute. Can this count be increased? What are the
configurations that I need to look into? 


Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008

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


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


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

Re: WWRUG10 Submission Deadline

[Rick Cook]

I'm with Julie.  I know many of you, and I think highly of most of you, but
I can't think of 5 of you I would want to see in a swimsuit.  Including
myself.  I think if we all hung around out there in swimsuits, they'd find a
way to close it for health reasons the next day - for the health of the
other people watching us.  Hawaiian shirts and shorts should be the uniform
of the day for all but the young and fit.

On a completely unrelated note, has anyone ever investigated what a Twinkie
will do to a pool filter?  (That sound you hear is Dan's hair turning
grayer).

Rick
On Thu, Jun 3, 2010 at 10:47 AM, Julie Sellers  wrote:

> **
>  Come on now...do you *really* want to see some of those folks in a
> swimsuit.
> ;-O
>
>  --
> *From:* Phil Bautista 
> *To:* arslist@ARSLIST.ORG
> *Sent:* Thu, June 3, 2010 12:17:01 AM
> *Subject:* WWRUG10 Submission Deadline
>
> **
>
> Dear ARSListers,
>
>
>
> The end of May marked the half way point for the window of accepting
> topics for the WWRUG10 Conference.  We will continue to accept initial
> topics for consideration up until July 10th.  We are already getting some
> great topics and looking forward to updates on many others.  With the
> schedule this year about a month earlier, the famous Hard Rock Pool will be
> open so don’t forget to pack your swimming attire!
>
>
>
> Here are the links to WWRUG10  and the Submissions
> Page.
>
>
>
>
> Don’t delay, submit today!
>
>
>
> Phil Bautista, WWRUG10 Advisory Board
>
> 512-731-0304
>
> http://www.linkedin.com/in/philbautista
>
> http://www.wwrug.org/wwrug10/contact_phil.html
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: Tickets creation through API

[SriSamSri Appecherla]

Hi Joe,

Thanks for the mail. My ARS 7.5, works on a multi tenancy mode. The Event
Monitoring system triggers the Java API which in turn creates tickets.Taking
this into consideration, 25 tickets in a minute appears to be a very small
number as the events being generated, though suppressed when duplicates, are
generally large in number (about 1000 non duplicate events per minute).

If anyone has worked with tickets creation using Java API, I want to know
how many tickets per minute at max can be created that Remedy can handle.

Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008


On Thu, Jun 3, 2010 at 11:10 PM, Joe D'Souza  wrote:

> **
> When an incident is getting created, there are several searched that are
> run across various tables for various things.. Take a filter log to check
> all these and make sure that these searches are all optimized.. In the
> recent versions I have not found problems with the OTB searches, but maybe
> you have some customizations done that run some customized workflow that
> performs a search that is not optimized?
>
> Optimizing all this would reduce the time an incident takes to get created.
> And if everything checks out and 25 is the best you can get to in a minute,
> I would think it is a good enough number no?
>
> If you really have 25 automated incidents to be created in a minute in your
> system, you are either a really big company or a small company with lots of
> problems :-) Kidding..
>
> Joe
>
>  -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org]*on Behalf Of *SriSamSri Appecherla
> *Sent:* Thursday, June 03, 2010 1:24 PM
> *To:* arslist@ARSLIST.ORG
>  *Subject:* Tickets creation through API
>
>  **
> Hi Listers,
>
> I am trying to create Incidents in Remedy using Java API using single login
> (with fixed license) but multiple threads. I am able to create about 25
> Incidents in a minute. Can this count be increased? What are the
> configurations that I need to look into?
>
> Regards,
> SriSamSri Appecherla
> Mobile# +91 991 610 6008
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: WWRUG10 Submission Deadline

[Julie Sellers]

Come on now...do you *really* want to see some of those folks in a swimsuit.
;-O




From: Phil Bautista 
To: arslist@ARSLIST.ORG
Sent: Thu, June 3, 2010 12:17:01 AM
Subject: WWRUG10 Submission Deadline

**  
Dear ARSListers,
 
The end of May marked the
half way point for the window of accepting topics for the WWRUG10
Conference.  We will continue to accept initial topics for consideration
up until July 10th.  We are already getting some great topics
and looking forward to updates on many others.  With the schedule this
year about a month earlier, the famous Hard Rock Pool will be open so
don’t forget to pack your swimming attire!
 
Here are the links to WWRUG10 and the Submissions
Page.  
 
Don’t delay, submit today!
 
Phil Bautista, WWRUG10 Advisory Board
512-731-0304
http://www.linkedin.com/in/philbautista
http://www.wwrug.org/wwrug10/contact_phil.html
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ 




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

Re: WAR deployment

[LJ LongWing]

Well….I got my hands on a doc that says it all

 

Configuring your BEA WebLogic web server

To install the mid tier with a BEA WebLogic web server, complete the following 

steps:

Step 1 Install the BEA WebLogic web server. (See the BEA WebLogic product 

documentation.)

Step 2 Configure a new domain. (See page 8.)

Step 3 Install the mid tier as described in the BMC Remedy Action Request 
System 7.5.00: 

Installation Guide. Choose “Other” for your web server and “Other” for your JSP 

engine.

Step 4 Install an enterprise application. (See page 9.)

Step 5 Change the context name to the standard name. (See page 10.)

 

IMPORTANT  

BMC Software recommends that you do not use the .war file to deploy the mid 
tier 

on WebLogic at this point. Instead, use the mid tier installer and follow the 

configuration steps outlined in this white paper

 

so basically….’you can’t’

 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Shinde, Vikram
Sent: Thursday, June 03, 2010 11:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: WAR deployment

 

You may like to share deployment error logs.

 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: Thursday, June 03, 2010 9:18 AM
To: arslist@ARSLIST.ORG
Subject: WAR deployment

 

** 

Trying to get Mid-Tier 7.5 Patch 5 deployed on WebLogic.  I thought I may be 
able to simply take the WAR file and tell Weblogic to deploy the WAR….this 
doesn’t seem to work.  Does anyone have suggestions on how to deploy with the 
WAR file? 

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


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

Re: User AR_ESCALATOR

[Kevin Begosh]

this was working with 7.1, we just upgraded to 7.5 and getting these
messages now.  Good suggestion with the AIE though.

On Thu, Jun 3, 2010 at 1:34 PM, Joe D'Souza  wrote:

> **
> ITSM 7 has changed a few things as to what roles are required to create and
> maintain contact information.. The roles that you see have to be added to
> the user that creates or updates this information in the CTM:People form..
>
> Instead of using escalations to do what you are doing, I would suggest
> creating a regular AR User account that has all these roles, and other
> permissions needed, and use AIE to do the same thing you are doing.. I have
> done it that way and it works well.. You can schedule AIE to run the job
> just like you are using your Escalation.. Make sure you configure AIE to use
> the user that you have created..
>
> Joe
>
>  -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org]*on Behalf Of *Kevin Begosh
> *Sent:* Thursday, June 03, 2010 1:27 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* User AR_ESCALATOR
>
>  **
> I have a process and staging forms that pull employee data from a view form
> on remedy, send it to a staging form and then creates a people record if
> that ID does not exist on the people form.  Well it worked before and then
> we upgraded from 7.0 to 7.5 AR Server and now it is not working. We are
> getting the following error message
>
> You must have one of the following permissions to create a person with a
> login ID: 'Contact Organization Admin', 'Contact Support Admin'. (ARERR
> 45530)
>
> and none of the profiles are being create.  Has something change with
> AR_ESCALATOR between 7.0 and 7.5?  Am I missing something?
>
> ARS 7.5 Patch 4
> ITSM 7.03 Patch 9
> CMDB 7.6 Patch 1
>
> --
> Kevin Begosh
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_




-- 
Kevin Begosh

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

Re: Tickets creation through API

[Joe D'Souza]

When an incident is getting created, there are several searched that are run
across various tables for various things.. Take a filter log to check all
these and make sure that these searches are all optimized.. In the recent
versions I have not found problems with the OTB searches, but maybe you have
some customizations done that run some customized workflow that performs a
search that is not optimized?

Optimizing all this would reduce the time an incident takes to get created.
And if everything checks out and 25 is the best you can get to in a minute,
I would think it is a good enough number no?

If you really have 25 automated incidents to be created in a minute in your
system, you are either a really big company or a small company with lots of
problems :-) Kidding..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of SriSamSri Appecherla
  Sent: Thursday, June 03, 2010 1:24 PM
  To: arslist@ARSLIST.ORG
  Subject: Tickets creation through API


  **
  Hi Listers,

  I am trying to create Incidents in Remedy using Java API using single
login (with fixed license) but multiple threads. I am able to create about
25 Incidents in a minute. Can this count be increased? What are the
configurations that I need to look into?

  Regards,
  SriSamSri Appecherla
  Mobile# +91 991 610 6008

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

Re: User AR_ESCALATOR

[Joe D'Souza]

ITSM 7 has changed a few things as to what roles are required to create and
maintain contact information.. The roles that you see have to be added to
the user that creates or updates this information in the CTM:People form..

Instead of using escalations to do what you are doing, I would suggest
creating a regular AR User account that has all these roles, and other
permissions needed, and use AIE to do the same thing you are doing.. I have
done it that way and it works well.. You can schedule AIE to run the job
just like you are using your Escalation.. Make sure you configure AIE to use
the user that you have created..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Kevin Begosh
  Sent: Thursday, June 03, 2010 1:27 PM
  To: arslist@ARSLIST.ORG
  Subject: User AR_ESCALATOR


  **
  I have a process and staging forms that pull employee data from a view
form on remedy, send it to a staging form and then creates a people record
if that ID does not exist on the people form.  Well it worked before and
then we upgraded from 7.0 to 7.5 AR Server and now it is not working. We are
getting the following error message

  You must have one of the following permissions to create a person with a
login ID: 'Contact Organization Admin', 'Contact Support Admin'. (ARERR
45530)

  and none of the profiles are being create.  Has something change with
AR_ESCALATOR between 7.0 and 7.5?  Am I missing something?

  ARS 7.5 Patch 4
  ITSM 7.03 Patch 9
  CMDB 7.6 Patch 1

  --
  Kevin Begosh

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

Re: RKM ITSM Form Indexing Issue After Initial RKM Install-RESOLVED

[jc2010]

Resolved.

This issue was related to an incorrect installation path for Apache Tomcat.
Findings indicated that the ITSM indexed forms are NOT obtained from the
RKM_METADATA table, but rather from definitions within AR System (likely the
KMS:OnIIndexTable form). Our issue was a partial lack of connectivity from
RKM/Tomcat to ARSystem.

Thanks,

John
-- 
View this message in context: 
http://old.nabble.com/RKM-ITSM-Form-Indexing-Issue-After-Initial-RKM-Install-tp28754126p28770670.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: ARLABEL UTILITY AND ARTEXT UTILITY FOR 7.5

[Elry]

Ok - looks like it was a silly question:

Turns out that all the utilities are automatically installed in the
same
directory as the AR System server; therefore, if you have the product
installed you have all the utilities.


On Jun 3, 10:41 am, Elry  wrote:
> Hi Folks...
>
> I am looking for the artext/arlable utility for the 7.5 API.  Tried
> using the 6.0 utility - it can export, but the import fails miserably.
>
> Can't seem to find it in the BMC Community.
>
> Maybe I am just not conducting my search properly.
>
> I would hate to have translate forms manually.
>
> Anyone know where to find this?
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

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

Re: WAR deployment

[Shinde, Vikram]

You may like to share deployment error logs.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: Thursday, June 03, 2010 9:18 AM
To: arslist@ARSLIST.ORG
Subject: WAR deployment

**
Trying to get Mid-Tier 7.5 Patch 5 deployed on WebLogic.  I thought I may be 
able to simply take the WAR file and tell Weblogic to deploy the WAR….this 
doesn’t seem to work.  Does anyone have suggestions on how to deploy with the 
WAR file?
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

User AR_ESCALATOR

[Kevin Begosh]

I have a process and staging forms that pull employee data from a view form
on remedy, send it to a staging form and then creates a people record if
that ID does not exist on the people form.  Well it worked before and then
we upgraded from 7.0 to 7.5 AR Server and now it is not working. We are
getting the following error message

You must have one of the following permissions to create a person with a
login ID: 'Contact Organization Admin', 'Contact Support Admin'. (ARERR
45530)

and none of the profiles are being create.  Has something change with
AR_ESCALATOR between 7.0 and 7.5?  Am I missing something?

ARS 7.5 Patch 4
ITSM 7.03 Patch 9
CMDB 7.6 Patch 1

-- 
Kevin Begosh

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

Tickets creation through API

[SriSamSri Appecherla]

Hi Listers,

I am trying to create Incidents in Remedy using Java API using single login
(with fixed license) but multiple threads. I am able to create about 25
Incidents in a minute. Can this count be increased? What are the
configurations that I need to look into?

Regards,
SriSamSri Appecherla
Mobile# +91 991 610 6008

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

Re: ARERR 299 Too many levels in filter processing

[Joe D'Souza]

One problem with updating from LASTCOUNT would be that if you choose the
escalation method, this update will happen only periodically.

The only way to keep it real time is to update it with every transaction.
Then in this case you would need to update this count when a record is
deleted or archived. It just may get a little more complicated than you
bargained for..

I don't think it will be faster than count(*).

I'm not sure how all databases handle count(*) but in the case of Oracle, I
think value is derived from a fast full index scan of the on a indexed
field.. The ARS has Field 1 as an indexed field even if no other custom
index has been added. Maybe if someone has the time to do EXPLAIN and verify
this, we could know the results..

I doubt other databases would be very different from this. Try a SHOW QUERY
PLAN on MS-SQL or Sybase..

And the biggest advantage of using count(*) is you can design it such that,
you use it only when needed. For e.g. a tab that holds this statistic, and a
tab that is seldom used. And the calculation to happen only when the user
gains focus to that tab.. or maybe even a dialog box on the press of a
button that displays this information..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Misi Mladoniczky
Sent: Thursday, June 03, 2010 4:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 299 Too many levels in filter processing


Hi,

Unions are not possible as such, but it is not hard, and quite robust, to
create filters that sync the relevant data from various forms into another
form, which will then have the same data as the union would have.

Instead of count(*), you can create counter-records in a counter-forms that
are updated by filters. Possibly with a slow safe-guard count of records
done by escalations each night. It can use $LASTCOUNT$ instead of direct
SQL. The end result may be even faster than the count(*) direct SQL :-)

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> Another situation is query unionswe have several locations in our app
> where we need to union several searches together into a single resultset,
> not possible within the Remedy architecture.
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
> Sent: Wednesday, June 02, 2010 3:48 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
> To do what you need to do when all else fails or if it is impossible to do
> it directly..
>
> I once had the requirement in a multi tenant environment (Submitter mode
> locked) to change the contents of field 2.. Only and admin user was to
> have
> the permissions to change that. How would you be able to do it from within
> the ARS if the workflow didn't run a Direct SQL?
>
> Other times I use it is when I'm dead sure using it would save time and
> that
> chances are bleak that the syntax would ever change.. Simple update or set
> statements that are hardly likely to change in syntax on that database or
> if
> you move across from databases are fine to use..
>
> Counting records in a table is another example where I'd rather use a
> Direct
> SQL than the ARS as it would be way faster.. And what are the chances that
> the count(*) function would ever change when used in a select statement?
>
> So there are exceptions such as that where some things are just not
> possible
> without resorting to Direct SQL. It is like a 911 call.. Just because you
> have that option you do not call it for recreational purposes..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Matt Worsdell
> Sent: Wednesday, June 02, 2010 5:43 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
>
> I fail to see why, Direct SQL is a legitimate built in option.
>
>
>> Hi,
>>
>> Direct SQL makes a system hard to manage. If there are built in options
>> other than Direct SQL, use them instead!
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia:
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>>> Another option would be to use a Direct SQL Action.
>>>
>>> Matt
>>>
>>>
 Hi fellow listers,

 This is something which i had tried.

 My need was to change a field value in a form after a record is
 submitted/modified and the record for which i need the field value
 c

Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database

[Bilinski, John CTR WHS/ITMD/ASD]

Thank you sir. I think that route may be the better way. I am going to setup
a test now.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Thursday, June 03, 2010 10:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring AR System 7.6 to support a View Form for a remote
SQL Server database

No.   Remedy does not mess with objects in the database it is not working
with.  The reason I do it that way is my dev Remedy has to pull data from
the dev provisioning system here (the same with test to test and production
to production).  When I migrate the Remedy forms and workflow nothing has to
change.  I can tell management my Remedy code is truly the same in all
environments.

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD
Sent: Thursday, June 03, 2010 9:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring AR System 7.6 to support a View Form for a remote
SQL Server database

So, you create a view in the local ARSystem database, is this dangerous?
Would an upgrade of the ARSystem database overwrite this view?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Thursday, June 03, 2010 9:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring AR System 7.6 to support a View Form for a remote
SQL Server database

You have to have the Remedy database be able to read data from the external
(remote) database.  In MS SQL Server this is called a link (in Oracle it is
a dbLink).  In SQL Management you set up a link so the Remedy database can
connect to the external (remote) database.  Think of pure a SQL select
statement.  How would you do a select of data in an external (remote)
database while connected to the local Remedy databse?

Personally I do it a bit differently.  I set up the link and a database View
of the data in the external (remote) database in the local Remedy database
and then create my Remedy view form against that local database view.  This
way I can adjust for dev/test/production environments at the database level
and Remedy is the same for each.

Say the Remedy database is called LocalRemedy and the external (remote)
database is CompanyDatabase.  In LocalRemedy you set up a link to
CompanyDatabase called Companylink.  You can then create a Remedy view form
against CompanyLink.CompanyDatabase.dbo.People.

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD
Sent: Thursday, June 03, 2010 7:46 AM
To: arslist@ARSLIST.ORG
Subject: Configuring AR System 7.6 to support a View Form for a remote SQL
Server database

Question,


I am reading page 177 of the AR Server Integration guide v7.5 on how to
configure a VIEW FORM to connect to an external database. My system runs on
SQL Server 2005 64-bit, both OS are Windows Server 2003. I am a bit confused
by this line in the integrations guide:

"Create a link to the remote database and either give ARAdmin an account on
the remote database or use the proper login credentials."

What do they mean by link? Do they mean an ODBC datasource connection on the
database server? Or is this something that needs to be setup in SQL
Management Studio?

Also, a couple lines down from this setup task the guide says:

"The format for the table name is:LINKNAME.DATABASENAME.OWNER.TABLENAME"

Do I have to create this table in my ARSystem Database? I think they are
leaving out some important information about how to handle this in SQL
Server. 

Need help.

Thanks.


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

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


smime.p7s
Description: S/MIME cryptographic signature

Re: WAR deployment

[Axton]

You should be able to simply deploy the war but you will also need to set up
library resolution for the native libraries.  This is done with the
LD_LIBRARY_PATH env var on posix operating systems and is done with the PATH
env var on Windows.  I don't know the specifics of how to get this set up
properly with WebLogic.

Axton

The opinions, statements, and/or suggested courses of action expressed in
this E-mail do not necessarily reflect those of BMC Software, Inc.  My
voluntary participation in this forum is not intended to convey a role as a
spokesperson, liaison or public relations representative for BMC Software,
Inc.

On Thu, Jun 3, 2010 at 11:17 AM, LJ LongWing  wrote:

> **
>
> Trying to get Mid-Tier 7.5 Patch 5 deployed on WebLogic.  I thought I may
> be able to simply take the WAR file and tell Weblogic to deploy the
> WAR….this doesn’t seem to work.  Does anyone have suggestions on how to
> deploy with the WAR file?
>  _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

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

WAR deployment

[LJ LongWing]

Trying to get Mid-Tier 7.5 Patch 5 deployed on WebLogic.  I thought I may be 
able to simply take the WAR file and tell Weblogic to deploy the WAR….this 
doesn’t seem to work.  Does anyone have suggestions on how to deploy with the 
WAR file? 


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

Re: ARERR 299 Too many levels in filter processing

[William Rentfrow]

There are times where the OOB box of a Remedy app can't be made to work
with workflow.

For example - in IM 7.03 - the "Transfers between groups/individuals" #
is wrong out of the box.  Most people do not notice it because the
number that is displayed on the screen in an Incident is right - but
what is actually stored is wrong.  The count would be updated when the
Incident was opened and the change flag was reset.

Our local rules dictate that any base product issues get kicked up to
BMC tech support first.  They actually could not find a workflow
solution to this given the way the app was built.  They registered a
defect.

I fixed it just using a direct SQL call.  The other choice was ripping
out a bunch of base product workflow and re-writing custom code.

I haven't checked to see if this was fixed in 7.5.  Anyone play with
that?


William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Blog: www.williamrentfrow.com
O 715-592-5185
C 715-410-8056

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Thursday, June 03, 2010 3:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 299 Too many levels in filter processing

Hi,

Unions are not possible as such, but it is not hard, and quite robust,
to create filters that sync the relevant data from various forms into
another form, which will then have the same data as the union would
have.

Instead of count(*), you can create counter-records in a counter-forms
that are updated by filters. Possibly with a slow safe-guard count of
records done by escalations each night. It can use $LASTCOUNT$ instead
of direct SQL. The end result may be even faster than the count(*)
direct SQL
:-)

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
Find these products, and many free tools and utilities, at
http://rrr.se.

> Another situation is query unionswe have several locations in our 
> app where we need to union several searches together into a single 
> resultset, not possible within the Remedy architecture.
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
> Sent: Wednesday, June 02, 2010 3:48 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
> To do what you need to do when all else fails or if it is impossible 
> to do it directly..
>
> I once had the requirement in a multi tenant environment (Submitter 
> mode
> locked) to change the contents of field 2.. Only and admin user was to

> have the permissions to change that. How would you be able to do it 
> from within the ARS if the workflow didn't run a Direct SQL?
>
> Other times I use it is when I'm dead sure using it would save time 
> and that chances are bleak that the syntax would ever change.. Simple 
> update or set statements that are hardly likely to change in syntax on

> that database or if you move across from databases are fine to use..
>
> Counting records in a table is another example where I'd rather use a 
> Direct SQL than the ARS as it would be way faster.. And what are the 
> chances that the count(*) function would ever change when used in a 
> select statement?
>
> So there are exceptions such as that where some things are just not 
> possible without resorting to Direct SQL. It is like a 911 call.. Just

> because you have that option you do not call it for recreational 
> purposes..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org]on Behalf Of Matt Worsdell
> Sent: Wednesday, June 02, 2010 5:43 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
>
> I fail to see why, Direct SQL is a legitimate built in option.
>
>
>> Hi,
>>
>> Direct SQL makes a system hard to manage. If there are built in 
>> options other than Direct SQL, use them instead!
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia:
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy 
>> logs.
>> Find these products, and many free tools and utilities, at 
>> http://rrr.se.
>>
>>> Another option would be to use a Direct SQL Action.
>>>
>>> Matt
>>>
>>>
 Hi fellow listers,

 This is something which i had tried.

 My need was to change a field value in a form after a record is 
 submitted/modified and the record for which i need the field value 
 change to be made is the one which got submitted/modified.

 So I created a filter which gets triggerred(i.e on action Submit 
 and Modify)and then do a push field and change the v

ARLABEL UTILITY AND ARTEXT UTILITY FOR 7.5

[Elry]

Hi Folks...

I am looking for the artext/arlable utility for the 7.5 API.  Tried
using the 6.0 utility - it can export, but the import fails miserably.

Can't seem to find it in the BMC Community.

Maybe I am just not conducting my search properly.

I would hate to have translate forms manually.

Anyone know where to find this?

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

Re: ARERR 299 Too many levels in filter processing

[LJ LongWing]

Misi,
I know this is an extreme examplebut one where using Remedy $LASTCOUNT$
was a HORRIBLE solution.  I have a table on a form, the table has roughly
150,000 records in it.  I need to do a SUM of the records in it for 3
separate columns.  Doing this work via Filter and Remedy workflow, the way
that Remedy did it was very simple.  It took the 'Server Table Field Chunk
Size' value on the Configuration tab of the server information dialog, which
defaults to 1000 and performs a search on the db table the table field is
based on saying 'select top 1000 ...', it finds that there are more than
1000 records, so it does it again for 'select top 2000 ...', it keeps
incrementing the 'top' section by the chunk size till it finds a count that
does not exceed the current chunk size.  Each time it increases the number
by chunk size, it of course takes longer for the query to returnin this
example it needed to perform this recursive increase 150 times to get up to
the 150K valueand it did this for each SUM I needed to do, which was
3...so to get the SUM of 3 columns in a table of 150K was taking about 10
min's.  Converted it to select SUM() direct SQL setfields and it takes less
than a second for all 3.  This is a situation where deferred processing was
not an option.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Thursday, June 03, 2010 2:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 299 Too many levels in filter processing

Hi,

Unions are not possible as such, but it is not hard, and quite robust, to
create filters that sync the relevant data from various forms into another
form, which will then have the same data as the union would have.

Instead of count(*), you can create counter-records in a counter-forms
that are updated by filters. Possibly with a slow safe-guard count of
records done by escalations each night. It can use $LASTCOUNT$ instead of
direct SQL. The end result may be even faster than the count(*) direct SQL
:-)

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> Another situation is query unionswe have several locations in our app
> where we need to union several searches together into a single resultset,
> not possible within the Remedy architecture.
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
> Sent: Wednesday, June 02, 2010 3:48 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
> To do what you need to do when all else fails or if it is impossible to do
> it directly..
>
> I once had the requirement in a multi tenant environment (Submitter mode
> locked) to change the contents of field 2.. Only and admin user was to
> have
> the permissions to change that. How would you be able to do it from within
> the ARS if the workflow didn't run a Direct SQL?
>
> Other times I use it is when I'm dead sure using it would save time and
> that
> chances are bleak that the syntax would ever change.. Simple update or set
> statements that are hardly likely to change in syntax on that database or
> if
> you move across from databases are fine to use..
>
> Counting records in a table is another example where I'd rather use a
> Direct
> SQL than the ARS as it would be way faster.. And what are the chances that
> the count(*) function would ever change when used in a select statement?
>
> So there are exceptions such as that where some things are just not
> possible
> without resorting to Direct SQL. It is like a 911 call.. Just because you
> have that option you do not call it for recreational purposes..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Matt Worsdell
> Sent: Wednesday, June 02, 2010 5:43 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
>
> I fail to see why, Direct SQL is a legitimate built in option.
>
>
>> Hi,
>>
>> Direct SQL makes a system hard to manage. If there are built in options
>> other than Direct SQL, use them instead!
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia:
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>>> Another option would be to use a Direct SQL Action.
>>>
>>> Matt
>>>
>>>
 Hi fellow listers,

 This is something which i had tried.

 My need was to change a field value in a form after

Re: Mid-Tier 7.5 Patch 5 Win2008 64bit

[Rodriguez, Rafael J x23718]

Joe thanks for you response but I had already made sure that I had all
permissions set. I did find the following in BMC KB which actually
resolved my issues:
 
Mid-tier install failed on Windows 2008 with IIS 7 - receiving HTTP 404
or 500 responses
Print
 Highlight
 Close
 
Details
Self Help Document  
ID:  20016123   
Type:Problem Solution   
 
Problem

Ran install of Mid-tier 7.5 on a Windows 2008 machine;  chose IIS as
webserver and Tomcat as JSP engine. Receiving either HTTP 404 or 500
errors when trying to reach the Mid-tier config page, or 500 errors.

AR/Mid-tier installer logs may show this severe error:

Severe error encountered:

SEVERE


com.bmc.install.product.arsuitekit.platforms.arsystemservers.midtier.Mid
TierTomcatUpdate

THROWABLE EVENT {Description=[Failed to execute
updateWorkerPortNumber]}

Throwable=[java.io.FileNotFoundException:
\conf\workers.properties.minimal (The system cannot find the path
specified)
java.io.FileInputStream.open(Native Method)
java.io.FileInputStream.(Native Method)

com.bmc.install.utility.io.FileHelper.readLines(FileHelper.java:708)

com.bmc.install.utility.io.FileHelper.readLines(FileHelper.java:687)
..


Windows Server 2008 Standard (32-bit and 64-bit) Service Pack 1

Product
BMC Remedy AR System Server (version 7.5.00)
Environment
DR: AR System Mid Tier;
Solution

Here are the steps taken at one site to ensure that the ISAPI redirector
would install correctly (using the Midtier installer).

NOTE: If Mid-tier & Tomcat are already installed, please
uninstall both via the Mid-tier uninstaller.  Please then download the
latest patch of the AR/Mid-tier installer for step #3.

1.  in IIS7, had to add new Roles to enable: ISAPI Filters and ISAPI
extensions, CGI, IIS6 Metabase Compatibility 
2.  had to set User Access Control for Windows in general to
"disable" (OR log in as a local administrator account!) 
3.  run Mid-tier installer, selecting IIS and Tomcat 
4.  from the IIS Manager, open the 'ISAPI and CGI Restriction' icon 

1.  add path to the isapi_redirect.dll 
2.  check the 'Allow extension path to execute box' 

if individual pages like login.jsp are getting sent back to the browser
as a file-to-open, follow step #3 here:

http://www.mhsoftware.com/caldemo/manual/en/921.htm
 

 

If the home page login gives 404.11 from IIS (a double-escape security
error):

1.  followed the procedures here, 
http://support.microsoft.com/kb/942076
 

 

NOTE: If all steps are taken and the requests through the redirector
receive a HTTP 503 response, a reboot of the Windows machine may be
needed.



 

On 64-bit Windows with IIS7, the command-line procedures in the
Installation Guide to allow the 32-bit .DLL still apply - however, two
additional roles may need to be added to IIS before running those
commands.

- IIS6 WMI Compatibility
- IIS6 Scripting Tools

More information:

"1) Install the 6.0 compatibility role for IIS 7, and
you should get the adsutil.vbs script; OR

2) Use the appcmd feature in IIS7 - see URL 
http://blogs.msdn.com/vijaysk/archive/2009/03/06/iis-7-tip-2-you-can-now
-run-32-bit-and-64-bit-applications-on-the-same-server.aspx
 

With IIS 7.0 the Enable32bitAppOnWin64 key has
been moved to the Application Pool level. So you can now set the bitness
of a particular Application Pool:

appcmd set apppool /apppool.name:DefaultAppPool
/enable32bitapponwin64:true

There is also a menu option for this ...see the
URL. "

 
 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Wednesday, June 02, 2010 5:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.5 Patch 5 Win2008 64bit


** 
Rafael,
 
This message happens when the client (web browser) is able to
communicate to the web server, but the web server is not able to find
the resource. This could be because the web server is perhaps not having
the necessary permissions to look up the page so make sure that the
mid-tier di

Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database

[Grooms, Frederick W]

No.   Remedy does not mess with objects in the database it is not working with. 
 The reason I do it that way is my dev Remedy has to pull data from the dev 
provisioning system here (the same with test to test and production to 
production).  When I migrate the Remedy forms and workflow nothing has to 
change.  I can tell management my Remedy code is truly the same in all 
environments.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD
Sent: Thursday, June 03, 2010 9:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring AR System 7.6 to support a View Form for a remote SQL 
Server database

So, you create a view in the local ARSystem database, is this dangerous?
Would an upgrade of the ARSystem database overwrite this view?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Thursday, June 03, 2010 9:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring AR System 7.6 to support a View Form for a remote
SQL Server database

You have to have the Remedy database be able to read data from the external
(remote) database.  In MS SQL Server this is called a link (in Oracle it is
a dbLink).  In SQL Management you set up a link so the Remedy database can
connect to the external (remote) database.  Think of pure a SQL select
statement.  How would you do a select of data in an external (remote)
database while connected to the local Remedy databse?

Personally I do it a bit differently.  I set up the link and a database View
of the data in the external (remote) database in the local Remedy database
and then create my Remedy view form against that local database view.  This
way I can adjust for dev/test/production environments at the database level
and Remedy is the same for each.

Say the Remedy database is called LocalRemedy and the external (remote)
database is CompanyDatabase.  In LocalRemedy you set up a link to
CompanyDatabase called Companylink.  You can then create a Remedy view form
against CompanyLink.CompanyDatabase.dbo.People.

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD
Sent: Thursday, June 03, 2010 7:46 AM
To: arslist@ARSLIST.ORG
Subject: Configuring AR System 7.6 to support a View Form for a remote SQL
Server database

Question,


I am reading page 177 of the AR Server Integration guide v7.5 on how to
configure a VIEW FORM to connect to an external database. My system runs on
SQL Server 2005 64-bit, both OS are Windows Server 2003. I am a bit confused
by this line in the integrations guide:

"Create a link to the remote database and either give ARAdmin an account on
the remote database or use the proper login credentials."

What do they mean by link? Do they mean an ODBC datasource connection on the
database server? Or is this something that needs to be setup in SQL
Management Studio?

Also, a couple lines down from this setup task the guide says:

"The format for the table name is:LINKNAME.DATABASENAME.OWNER.TABLENAME"

Do I have to create this table in my ARSystem Database? I think they are
leaving out some important information about how to handle this in SQL
Server. 

Need help.

Thanks.

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

Re: ******** Change issues Classification > "Timing" "Timing Reason" etc.

[Guillaume Rheault]

Sorry to jump so late in this discussion, but you might want to have a 
close-down approval on latent changes from the business (the end-user), just to 
make sure that the end-user is satisfied with the change done:

- If the close-down approval is approved, that means the user is satisfied. The 
change can be closed with closed status reason = successful
- if the close-down approval is rejected, that means the end user is not 
satisfied. The change can be closed with a closed status reason that reflects 
the end-user perceptions. At this point, a new change can be created, and 
linked to the latent change, to either roll-back the latent change or perform 
any work that still needs to be done.

>From an  audit and control perspective, you still want approvals for 
>non-standard (non-routine) latent changes. It is a key audit control to have 
>somebody (other than the implementer) to approve the change, even if the 
>change has already happened. Auditors are quite serious about this. Of course, 
>if your company/organization does not get audited for change controls, then 
>you're fine.

Guillaume


From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Martinez, Marcelo A [marc...@cpchem.com]
Sent: Tuesday, May 18, 2010 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re:  Change issues Classification > "Timing" "Timing Reason" 
etc.

**
Enslin,
You must first take a hard look at your Change Mgmt policies before deciding 
how to utilize the module. As Rick mentioned, the module is very ITIL driven.
Here is more or less how we’ve defined ours:
Normal: a change entered ahead of time, proper approvals, testing, 
documentation. Reviewed during weekly change meetings.
Latent: change has already taken place. No approvals needed. (what for?).
Emergency: relates to the immediate resolution to a known production problem 
where an outage is eminent. Approvals needed.
Expedited: changes that did not make the weekly change meeting. Used by people 
who “forget” to enter changes and do it last minute. Approval needed. You could 
add a special approval level here (i.e. all expedited tickets must be approved 
by their department head).
-all changes which require approval must be approved before performing the 
change, otherwise it is considered unauthorized and tracked as such. Change 
Mgmt has override approval authority at all levels.

PS. Don’t mind going down there to help (if you have tickets to the World Cup! 
:) )


Marcelo

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: Tuesday, May 18, 2010 10:20 AM
To: arslist@ARSLIST.ORG
Subject: Re:  Change issues Classification > "Timing" "Timing Reason" 
etc.

**
My first impression was that your company is attempting to use non-ITIL 
processes in an ITIL software package.  That will cause problems similar to 
what you are seeing.  Could I suggest that you attempt to get your people to 
use the proper process, rather than tweak the software to enforce an improper 
process?

Rick
On Tue, May 18, 2010 at 7:34 AM, Enslin Van Blerk - MWEB 
mailto:evanbl...@mweb.com>> wrote:
**
Hi

I require your assistance please. I don’t really work with the Change 
management module thus I am a bit in the dark here, asking this question.

We have occasions where people will do a change in production and then 3hours 
later, they want to log the change and resolve it etc.

According to what I found in the documentation these changes can be logged as a 
Latent Change and will then close automatically. We can use this but it is not 
always the case and sometimes for record purposes we still require people to 
approve.

People log tickets as an emergency in these situations and because this was 
logged as an emergency we cannot close the ticket because it was logged after 
the actual start dates.


First we get a message, telling us it will be saved to Expedited because the 
Requested Date is before the earliest Start Date.
I will save it as expedited, enter the times for actual start/end date.

Then it will tell me, Only Latent changes can have actual start dates that come 
after the infrastructure change submit date.
At this point we have values in “Earliest Start Date” and “Submitted Date”
If we try to save the timing field to latent we just receive ARNOTE again 
telling us it will be saved to Expedited because the Requested Date is before 
the earliest Start Date.

We are not able to close this change with the correct times now, what can we do 
with these situations?



Regards
Enslin


Error! Filename not specified.

This electronic communication and the attached file(s) are subject to a 
disclaimer which can be accessed on the following link: 
Disclaimer
- or copy the following URL into your browser - 
http://www.mweb.co.za/disclaimer. If you are unabl

Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database

[Bilinski, John CTR WHS/ITMD/ASD]

So, you create a view in the local ARSystem database, is this dangerous?
Would an upgrade of the ARSystem database overwrite this view?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Thursday, June 03, 2010 9:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Configuring AR System 7.6 to support a View Form for a remote
SQL Server database

You have to have the Remedy database be able to read data from the external
(remote) database.  In MS SQL Server this is called a link (in Oracle it is
a dbLink).  In SQL Management you set up a link so the Remedy database can
connect to the external (remote) database.  Think of pure a SQL select
statement.  How would you do a select of data in an external (remote)
database while connected to the local Remedy databse?

Personally I do it a bit differently.  I set up the link and a database View
of the data in the external (remote) database in the local Remedy database
and then create my Remedy view form against that local database view.  This
way I can adjust for dev/test/production environments at the database level
and Remedy is the same for each.

Say the Remedy database is called LocalRemedy and the external (remote)
database is CompanyDatabase.  In LocalRemedy you set up a link to
CompanyDatabase called Companylink.  You can then create a Remedy view form
against CompanyLink.CompanyDatabase.dbo.People.

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD
Sent: Thursday, June 03, 2010 7:46 AM
To: arslist@ARSLIST.ORG
Subject: Configuring AR System 7.6 to support a View Form for a remote SQL
Server database

Question,


I am reading page 177 of the AR Server Integration guide v7.5 on how to
configure a VIEW FORM to connect to an external database. My system runs on
SQL Server 2005 64-bit, both OS are Windows Server 2003. I am a bit confused
by this line in the integrations guide:

"Create a link to the remote database and either give ARAdmin an account on
the remote database or use the proper login credentials."

What do they mean by link? Do they mean an ODBC datasource connection on the
database server? Or is this something that needs to be setup in SQL
Management Studio?

Also, a couple lines down from this setup task the guide says:

"The format for the table name is:LINKNAME.DATABASENAME.OWNER.TABLENAME"

Do I have to create this table in my ARSystem Database? I think they are
leaving out some important information about how to handle this in SQL
Server. 

Need help.

Thanks.


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

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


smime.p7s
Description: S/MIME cryptographic signature

Re: ARERR 299 Too many levels in filter processing

[L G Robinson]

Hi Folks,

Having just completed a migration from Sybase to Oracle, I can tell you
from personal experience that direct SQL can pose some challenges:

- Literals... ""s are ok in Sybase, Oracle requires ''s.

- Stored procedures... they "work" quite differently in Oracle with
  respect to returning results. This cost me much effort in my conversion.

Although it was easier at the time to use direct SQL, I did end up
converting many of the instances back to Remedy workflow when possible,
even though I do not anticipate another data base platform change.  :-)

Hope this is helpful.
Larry

Larry Robinson   n...@ncsu.edu
Office of Information Technology
NC State University  919-515-5432 Voice
Raleigh, NC  27695-7109  919-513-0877 FAX


On Jun 2, 2010, at 10:07 AM, William Rentfrow wrote:

> I've found a few rare instances where using direct SQL was the best way
> to accomplish the task at hand.  It is rare.
> 
> When using direct SQL by far the biggest issue you're likely to run into
> is having the "T" (B, H) table be wrong between systems.
> 
> The steps below are pretty simple - when I did use direct SQL I always
> did the following.
> 
> 1.) Add field name T_table
> 2.) First action executed was always a set fields that used direct SQL
> to set the correct T-table # in the T_table field like...
> 
> Select schemaid from arschema where name='HPD:Help Desk'
> 
> From there on you just used "T"+T_table in your direct SQL calls.
> 
> That way it was portable across systems, etc.  If you take those steps
> then direct SQL's downsides are mostly mitigated right from the start.
> There are other implications of course (E.G., exporting workflow from an
> Oracle database system to  SQL Server database system) but the odds of
> running into them are low. 
> 
> 
> William Rentfrow
> Principal Consultant, StrataCom Inc.
> wrentf...@stratacominc.com
> Blog: www.williamrentfrow.com
> O 715-592-5185
> C 715-410-8056
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell
> Sent: Wednesday, June 02, 2010 8:51 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
> 
> All valid points, however it is still a legitimate option and doesn't
> necessarily mean a system is hard to manage.

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

Re: Configuring AR System 7.6 to support a View Form for a remote SQL Server database

[Grooms, Frederick W]

You have to have the Remedy database be able to read data from the external 
(remote) database.  In MS SQL Server this is called a link (in Oracle it is a 
dbLink).  In SQL Management you set up a link so the Remedy database can 
connect to the external (remote) database.  Think of pure a SQL select 
statement.  How would you do a select of data in an external (remote) database 
while connected to the local Remedy databse?

Personally I do it a bit differently.  I set up the link and a database View of 
the data in the external (remote) database in the local Remedy database and 
then create my Remedy view form against that local database view.  This way I 
can adjust for dev/test/production environments at the database level and 
Remedy is the same for each.

Say the Remedy database is called LocalRemedy and the external (remote) 
database is CompanyDatabase.  In LocalRemedy you set up a link to 
CompanyDatabase called Companylink.  You can then create a Remedy view form 
against CompanyLink.CompanyDatabase.dbo.People.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Bilinski, John CTR WHS/ITMD/ASD
Sent: Thursday, June 03, 2010 7:46 AM
To: arslist@ARSLIST.ORG
Subject: Configuring AR System 7.6 to support a View Form for a remote SQL 
Server database

Question,


I am reading page 177 of the AR Server Integration guide v7.5 on how to
configure a VIEW FORM to connect to an external database. My system runs on
SQL Server 2005 64-bit, both OS are Windows Server 2003. I am a bit confused
by this line in the integrations guide:

"Create a link to the remote database and either give ARAdmin an account on
the remote database or use the proper login credentials."

What do they mean by link? Do they mean an ODBC datasource connection on the
database server? Or is this something that needs to be setup in SQL
Management Studio?

Also, a couple lines down from this setup task the guide says:

"The format for the table name is:LINKNAME.DATABASENAME.OWNER.TABLENAME"

Do I have to create this table in my ARSystem Database? I think they are
leaving out some important information about how to handle this in SQL
Server. 

Need help.

Thanks.

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

Re: HP Openview Remedy Integration

[Nowak, James]

No issues.  There is workflow that we have on the ARS side to help with the 
assignment of tickets, notification, etc when an event is fed from OV.  We also 
have significant correlation and filtering happening on the OV side so that we 
only create HD tickets on important events.

Jim Nowak
IT Operations

TEL: 630.864.5366 | CELL: 630.414.0193 | jamesno...@officemax.com
263 Shuman Blvd., Naperville, IL 60563 | http://www.officemax.com



CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached 
document(s) may contain confidential information that is intended only for the 
addressee(s). If you are not the intended recipient, you are hereby advised 
that any disclosure, copying, distribution or the taking of any action in 
reliance upon the information is prohibited. If you have received this e-mail 
in error, please immediately notify the sender and delete it from your system.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Donald Morton
Sent: Wednesday, June 02, 2010 12:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: HP Openview Remedy Integration

Just wondering if there are any issues like the process table getting  
filled up from spawning too many processes, or maybe heavy CPU usage.  
It seems like this sort of integration would be better suited to an  
arfilter plugin, a webservice, or even a vendor or view form.

Sent from my iPod

On Jun 2, 2010, at 12:46 PM, "Nowak, James"   
wrote:

> I'm assuming you are talking about the Remedy SPI.  We use it as a  
> way to feed events from Operations Manager into Remedy and then  
> populate updates from Remedy back to the OV event.
>
> Jim Nowak
> IT Operations
>
> TEL: 630.864.5366 | CELL: 630.414.0193 | jamesno...@officemax.com
> 263 Shuman Blvd., Naperville, IL 60563 | http://www.officemax.com
>
>
>
> CONFIDENTIALITY NOTICE: The information contained in this e-mail and  
> attached document(s) may contain confidential information that is  
> intended only for the addressee(s). If you are not the intended  
> recipient, you are hereby advised that any disclosure, copying,  
> distribution or the taking of any action in reliance upon the  
> information is prohibited. If you have received this e-mail in  
> error, please immediately notify the sender and delete it from your  
> system.
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)  
> [mailto:arsl...@arslist.org] On Behalf Of Donald Morton
> Sent: Wednesday, June 02, 2010 11:23 AM
> To: arslist@ARSLIST.ORG
> Subject: HP Openview Remedy Integration
>
> Has anyone used HP Openview's Remedy Integration? They have an
> integration that lets their event console see when Remedy tickets have
> been updated. It's a Run Process action that fires a C program every
> time a ticket is modified.
>
> Has anyone run into any issues with this?
>
>
>
> Sent from my iPod
>
> ___
 

> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> ___
 

> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

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

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

Re: PIR

[Ramey, Anne]

That is about what we do now.

Anne Ramey
**
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Dennis Ruble
Sent: Thursday, June 03, 2010 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: PIR

**
Anne,
We're still on ITSP 4.0, but I expect we'd implement PIR's much the same way in 
ITSM if BMC doesn't have it included...

We only force PIRs on Large and Enterprise changes. We added a seperate PIR 
form that gathers the information we want to know.  In Change there are active 
links that advises the user on a "Completed" change that they must complete a 
PIR(button activated) before advancing the change any further.  We have a 
filter that prevents advancing any further unless a completed PIR exists.

HTH,
Dennis Ruble
Rockwell Collins


"Ramey, Anne" 
Sent by: "Action Request System discussion list(ARSList)" 

06/02/2010 10:22 AM
Please respond to
arslist@ARSLIST.ORG


To

arslist@ARSLIST.ORG

cc

Subject

PIR







**
Does anyone else have customization in place to do PIRs in Remedy for change?  
How do you handle it?  Does anyone know if BMC is planning on coding this into 
the product for ITSM 8?

Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by an 
authorized State Official.


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

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

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

Configuring AR System 7.6 to support a View Form for a remote SQL Server database

[Bilinski, John CTR WHS/ITMD/ASD]

Question,


I am reading page 177 of the AR Server Integration guide v7.5 on how to
configure a VIEW FORM to connect to an external database. My system runs on
SQL Server 2005 64-bit, both OS are Windows Server 2003. I am a bit confused
by this line in the integrations guide:

"Create a link to the remote database and either give ARAdmin an account on
the remote database or use the proper login credentials."

What do they mean by link? Do they mean an ODBC datasource connection on the
database server? Or is this something that needs to be setup in SQL
Management Studio?

Also, a couple lines down from this setup task the guide says:

"The format for the table name is:LINKNAME.DATABASENAME.OWNER.TABLENAME"

Do I have to create this table in my ARSystem Database? I think they are
leaving out some important information about how to handle this in SQL
Server. 

Need help.

Thanks.

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


smime.p7s
Description: S/MIME cryptographic signature

Re: PIR

[Dennis Ruble]

Anne,
We're still on ITSP 4.0, but I expect we'd implement PIR's much the same 
way in ITSM if BMC doesn't have it included...

We only force PIRs on Large and Enterprise changes. We added a seperate 
PIR form that gathers the information we want to know.  In Change there 
are active links that advises the user on a "Completed" change that they 
must complete a PIR(button activated) before advancing the change any 
further.  We have a filter that prevents advancing any further unless a 
completed PIR exists.

HTH,
Dennis Ruble
Rockwell Collins




"Ramey, Anne"  
Sent by: "Action Request System discussion list(ARSList)" 

06/02/2010 10:22 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
PIR






** 
Does anyone else have customization in place to do PIRs in Remedy for 
change?  How do you handle it?  Does anyone know if BMC is planning on 
coding this into the product for ITSM 8?
 
Anne Ramey
***
E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties only by 
an authorized State Official.
 
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ 

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

JOB - Washington DC - Remedy Administrator

[bob lind]

Another position in DC that is more on the admin side.

KLSL Consulting is looking for Remedy consultants to work in Washington DC.
These positions are frequently continued on 1 year contracts.  Given the
rate and long term nature of the projects, local Washington DC area
consultants only please.  Also no third parties, we only work directly with
consultants.  If interested contact Bob Lind at bob.l...@klslconsulting.com

Remedy Sysadmin Level 2 (5+ Years)

Complete Description:
Remedy Administrator will provide crucial system admin support during the
District's Remedy 7.5 upgrade project.

Candidate provides support during the 7.5 upgrade project such as adding
users, creating new CTI's, building new reports, extracting statistical data
and performing minor to moderate system configuration updates on all Remedy
applications during the 7.5 upgrade project.

Candidate will be tasked with administrative support projects during the 7.5
upgrade of all Remedy ITSM Suite applications as well as some custom built
applications. Candidate works closely with Remedy Engineers and Developers
in support of the 7.5 upgrade project. Candidate will interact with and
fulfill customer requests during the 7.5 upgrade project and therefore must
have strong customer service skills.

Must have experience performing assessments on Remedy forms and modules in
order to determine if their functioning conforms to customer's stated
requirements.

Must have good understanding of service desk, change management and asset
management standard work flow.

Must have experience performing QA analysis and running system tests on
development output.

Experience developing system documentation and training end users is highly
desired. Knowledge of ITIL v3 best practice method is desired.


Responsibilities:
• Provide administrative upgrade support for Remedy Application solutions.
• Perform administrative enhancements on Remedy Applications during the
upgrade and in the new environment while the 7.5 upgrade is underway.
• Work closely with developers to understand solutions in BMC Remedy Action
Request System (ARS) up to 7.5 as well as ITSM suite, CMDB, SRM, Mid-Tier
and related tools.
• Guide the user community through a migration from earlier Remedy version
to 7.5. Perform administrator functions as needed to support the major
version upgrade project.
• Develop Crystal Reports and deploy in Crystal Enterprise Server in support
of the 7.5 upgrade Recommended Experience:
• At least 5 years experience in Remedy 5.x up to and including to current
versions.
• At least 8 years total work experience.
• A minimum of a bachelor’s degree.

Behavior Characteristics:
Remedy ARS (version 5 – present)  Required  5  Years
Remedy ITSM (version 5 – present)  Required  5  Years
Report Writer Administration  Required  3  Years
OS/Network Administration  Required  2  Years
Knowledge of Java based web applications  Nice to have  2  Years

Must have Green Card or be US Citizen.
May be required to stay "on call" for occasional after hours support.
There are no reimbursable expenses.

Work Location:  Remedy Service Group: 441 4th St NW, Suite 1045



-- 
Bob Lind
IT Jobs posted daily on
klslconsulting.com/jobs

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

JOB - Washington DC - Remedy Developer

[bob lind]

KLSL Consulting is looking for Remedy consultants to work in Washington DC.
These positions are frequently continued on 1 year contracts.  Given the
rate and long term nature of the projects, local Washington DC area
consultants only please.  Also no third parties, we only work directly with
consultants.  If interested contact Bob Lind at bob.l...@klslconsulting.com

Remedy Developer Level 3
8+ Years

Complete Description:
Remedy Developer will serve as one of several technical resources for the
District's Remedy 7.5 upgrade project. The candidate will work under the
supervision of a Development Manager to upgrade all of the District's Remedy
Services, including custom applications built using the Remedy ARS platform,
to the latest Remedy version of 7.5.
Current version 5.5.

Candidate will also advise executives on best practices, as required during
the upgrade project. Candidate undertakes complex development efforts, is
responsible for delivering solutions on-time and on-budget. Strong
communication skills as well as the ability to drive creative solutions to
business problems is highly desired.

Responsibilities:
• Act as a key technical resource in the Remedy 7.5 upgrade project.
• Develops Remedy ITSM Suite and Custom Application solutions in new 7.5
environment.
• Architect solutions in BMC Remedy Action Request System (ARS) up to 7.x as
well as ITSM suite, CMDB, SRM, Mid-Tier and related tools.
• As required during the 7.5 upgrade project: Analyze, design and develop
new requirements, customize existing ITSM applications, upgrading ITSM App
from earlier version to 7.x and developing complex applications using ARS
development environment.
• Develop Crystal Reports and deploy in Crystal Enterprise Server in support
of the 7.5 upgrade project.
• Integrate various external integration tools with ARS Including but not
limited to HP Open View, LDAP, Business Objects and Mobile Device Platforms
in support of the 7.5 upgrade project.


Recommended Experience:
• At least 5 years experience in development.
• At least 8 years total work experience.
• A minimum of a bachelor’s degree.

Remedy ARS (version 5 – present) Required 5 Years
Remedy ITSM (version 5 – present) Required 5 Years
Report Writer Administration Required 3 Years
OS/Network Administration Required 3 Years
SQL DBA - Writing complex SQL statements Desired 2 Years
Oracle Database Administration Desired 2 Years
CMDB Implementation Experience Nice to have 2 Years
Knowledge of Java based web applications Nice to have 2 Years
Experience with Remedy Platform major version upgrade Highly desired

Candidate must have Green Card or is a US Citizen
Candidate  may be required to stay "on call" for occasional after hours
support.
There are no reimbursable expenses.


Work Location: Remedy Service Group: 441 4th St NW, Suite 1045 North

-- 
Bob Lind
IT Jobs posted daily on
klslconsulting.com/jobs

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

Re: Trouble with ARSPerl ars_NTNotificationServer

[L G Robinson]

Yup... that is exactly what I did and it works great. Thanks Fred.
Larry

On Jun 2, 2010, at 2:18 PM, Grooms, Frederick W wrote:

> As a quick test you might try putting a submit/merge filter on Alert Events 
> to do an LTRIM(RTRIM($Request$)) on the Request  field.
> 
> Fred
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of L G Robinson
> Sent: Wednesday, June 02, 2010 12:21 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Trouble with ARSPerl ars_NTNotificationServer
> 
> Thanks Frederick... I wish I'd thought of that.
> 
> Yes, 5.1 does have the Alert Events form. A quick check of some existing 
> entries in that form showed that the 'Request' field was in fact right-padded 
> to a length of 15. I edited one entry, reloaded the Alert list and it worked!
> 
> I will change my Perl code to do a submit as you suggest but the 2 minute 
> solution was to add a filter to the Alert Events form to do an RTRIM on 
> 'Request'.
> 
> Thanks again... chalk up another win for "the list"!
> Larry
> 
> On Jun 2, 2010, at 10:50 AM, Grooms, Frederick W wrote:
> 
>> I can't remember but did 5.1 have the Alert Events form?  If so you could 
>> change your Perl to just do a submit to the Alert Events form and that will 
>> trigger the Alert to the user.  You don't have to actually call the 
>> NotificationServer call.
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

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

Re: ARERR 299 Too many levels in filter processing

[Misi Mladoniczky]

Hi,

Unions are not possible as such, but it is not hard, and quite robust, to
create filters that sync the relevant data from various forms into another
form, which will then have the same data as the union would have.

Instead of count(*), you can create counter-records in a counter-forms
that are updated by filters. Possibly with a slow safe-guard count of
records done by escalations each night. It can use $LASTCOUNT$ instead of
direct SQL. The end result may be even faster than the count(*) direct SQL
:-)

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> Another situation is query unionswe have several locations in our app
> where we need to union several searches together into a single resultset,
> not possible within the Remedy architecture.
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
> Sent: Wednesday, June 02, 2010 3:48 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
> To do what you need to do when all else fails or if it is impossible to do
> it directly..
>
> I once had the requirement in a multi tenant environment (Submitter mode
> locked) to change the contents of field 2.. Only and admin user was to
> have
> the permissions to change that. How would you be able to do it from within
> the ARS if the workflow didn't run a Direct SQL?
>
> Other times I use it is when I'm dead sure using it would save time and
> that
> chances are bleak that the syntax would ever change.. Simple update or set
> statements that are hardly likely to change in syntax on that database or
> if
> you move across from databases are fine to use..
>
> Counting records in a table is another example where I'd rather use a
> Direct
> SQL than the ARS as it would be way faster.. And what are the chances that
> the count(*) function would ever change when used in a select statement?
>
> So there are exceptions such as that where some things are just not
> possible
> without resorting to Direct SQL. It is like a 911 call.. Just because you
> have that option you do not call it for recreational purposes..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Matt Worsdell
> Sent: Wednesday, June 02, 2010 5:43 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARERR 299 Too many levels in filter processing
>
>
> I fail to see why, Direct SQL is a legitimate built in option.
>
>
>> Hi,
>>
>> Direct SQL makes a system hard to manage. If there are built in options
>> other than Direct SQL, use them instead!
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia:
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>>> Another option would be to use a Direct SQL Action.
>>>
>>> Matt
>>>
>>>
 Hi fellow listers,

 This is something which i had tried.

 My need was to change a field value in a form after a record is
 submitted/modified and the record for which i need the field value
 change
 to
 be made is the one which got submitted/modified.

 So I created a filter which gets triggerred(i.e on action Submit and
 Modify)and then do a push field and change the value in the field for
 the
 same form-record.

 Now my problem here is that as I am doing the push in the same form
 for
 changing a value in the field, "ARERR 299 Too many levels in filter
 processing" occurs. I know this happens because the Push field action
 ultimately triggers a submit/modify action on the same form and the
 filter
 get triggerred infinitely.

 Can anyone suggest me a different approach to this?

 Cheers :)
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>

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