Re: ARERR 299 Too many levels in filter processing

2010-06-03 Thread 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

Re: Trouble with ARSPerl ars_NTNotificationServer

2010-06-03 Thread 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

JOB - Washington DC - Remedy Developer

2010-06-03 Thread 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

JOB - Washington DC - Remedy Administrator

2010-06-03 Thread 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.

Re: PIR

2010-06-03 Thread 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

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

2010-06-03 Thread 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

Re: PIR

2010-06-03 Thread 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

Re: HP Openview Remedy Integration

2010-06-03 Thread 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

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

2010-06-03 Thread 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

Re: ARERR 299 Too many levels in filter processing

2010-06-03 Thread 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

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

2010-06-03 Thread 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,

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

2010-06-03 Thread 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

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

2010-06-03 Thread 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

Re: Mid-Tier 7.5 Patch 5 Win2008 64bit

2010-06-03 Thread 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

Re: ARERR 299 Too many levels in filter processing

2010-06-03 Thread 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

ARLABEL UTILITY AND ARTEXT UTILITY FOR 7.5

2010-06-03 Thread 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.

Re: ARERR 299 Too many levels in filter processing

2010-06-03 Thread 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

WAR deployment

2010-06-03 Thread 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?

Re: ARERR 299 Too many levels in filter processing

2010-06-03 Thread 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

Tickets creation through API

2010-06-03 Thread 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

User AR_ESCALATOR

2010-06-03 Thread 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

Re: WAR deployment

2010-06-03 Thread 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

Re: ARLABEL UTILITY AND ARTEXT UTILITY FOR 7.5

2010-06-03 Thread 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 elryal...@gmail.com wrote: Hi Folks... I am

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

2010-06-03 Thread 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

Re: User AR_ESCALATOR

2010-06-03 Thread 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

Re: Tickets creation through API

2010-06-03 Thread 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

Re: User AR_ESCALATOR

2010-06-03 Thread 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 jdso...@shyle.net wrote: ** ITSM 7 has changed a few things as to what roles are required to create and maintain contact

Re: WAR deployment

2010-06-03 Thread 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

Re: WWRUG10 Submission Deadline

2010-06-03 Thread Julie Sellers
Come on now...do you *really* want to see some of those folks in a swimsuit. ;-O From: Phil Bautista 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

Re: Tickets creation through API

2010-06-03 Thread 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

Re: WWRUG10 Submission Deadline

2010-06-03 Thread 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

Re: Tickets creation through API

2010-06-03 Thread 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

Re: User AR_ESCALATOR

2010-06-03 Thread 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

Re: WWRUG10 Submission Deadline

2010-06-03 Thread 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

Re: User AR_ESCALATOR

2010-06-03 Thread 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

Re: Tickets creation through API

2010-06-03 Thread 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,

Re: Tickets creation through API

2010-06-03 Thread 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

Question on entry in AR.CFG file...

2010-06-03 Thread 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?

7.5 ODBC Driver

2010-06-03 Thread 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.

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

2010-06-03 Thread 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

Curious filter issue

2010-06-03 Thread 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

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

2010-06-03 Thread 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

Re: Curious filter issue

2010-06-03 Thread 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

IIS config being corrupted

2010-06-03 Thread 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

Re: IIS config being corrupted

2010-06-03 Thread 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

Re: IIS config being corrupted

2010-06-03 Thread 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

Re: Curious filter issue

2010-06-03 Thread 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

Re: IIS config being corrupted

2010-06-03 Thread 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:

Re: Curious filter issue

2010-06-03 Thread 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)

Re: User AR_ESCALATOR

2010-06-03 Thread 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.

RKM Authentication

2010-06-03 Thread 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

Re: RKM Authentication

2010-06-03 Thread 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

Re: User AR_ESCALATOR

2010-06-03 Thread 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.

Re: RKM Authentication

2010-06-03 Thread 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

Re: Curious filter issue

2010-06-03 Thread 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,

Re: Mid-tier BOXI

2010-06-03 Thread 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

Re: WWRUG10 Submission Deadline

2010-06-03 Thread 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

Re: Curious filter issue

2010-06-03 Thread 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

Re: ARERR 299 Too many levels in filter processing

2010-06-03 Thread 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 m...@worsy.co.uk wrote: