Re: Table Loop Update issue - 3rd action of a guide not running

can you show your logs? both table looping is off and table looping is on i guess the only reason that the 3rd action of a guide not running is because it is empty table,nothing to loop. On Aug 21, 2:42 am, Shawn Stonequist [EMAIL PROTECTED] wrote: Greetings List!! Another Table Loop issue

Re: Table Loop Update issue - 3rd action of a guide not running

Hi Shawn, If you refresh the table you are looping through, I would think that Remedy considers the refreshed table a new table, so you have finished looping through the old table, so to speak. I think the way to do what you want to do, is loop through the table, do the refresh on a second (new)

Re: Table Loop Update issue - 3rd action of a guide not running

Guys (and Gals): There are many many problems with nested table loops in Active Link Huids. To work around them all: Do not refer to fields from the first table in the workflow or qualifications of the second table. Instead, have the first table loop guide copy the fields from the table

ITSM 7 OOtB emails

Good morning folks, I've been looking into the proper way to modify OOtB emails with ITSM 7. Specifically, I want to add some additional fields to the emails that aren't sent by default. I tried going into SYS:Form Field Selection and added a variable, for example Phone Number, from the Incident

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Joe, try the following: Change the table qualification to (EXTERNAL($ztmpQualification$)) AND ('Start Date' = $DATE$) Create display only field ztmpQualification. Create active link that sets ztmpQualification = ('Queue' = $Queue$) Create active link that does a table refresh You might have to

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Gary, (and maybe Joe too) I actually think the date stuff your seeing is actually related to these details... Ref: Workflow-Objects-700.pdf Pg 199 For example, if you have a table field with a qualification of EXTERNAL($Qualify Field$) and Qualify Field is a character field with a value of

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Carey, thanks for expanding upon this, but I'm not using any keywords such as $DATE$ or $TIMESTAMP$ in my external field's value. My situation only worked whenever I used EXTERNAL(), and I think that Joe is probably having the same thing. I was suggesting he try using the EXTERNAL, and if he

Re: WS2003 SP2 (AND Tomcat 5.5.17)

I can't speak to workflow causing issues in Mid-Tier, but the tcnative.dll issue is that Tomcat *sometimes* ends up eating 100% of 16 cpu's indefinitely. The dll is located in the tomcat\bin directory and is tcnative.dll Removing or renaming the dll fixes the CPU usage issues. I haven't had

Import into MS Access through a Remedy ARS Button and Active Link

Hello, Has anyone done an import of MS Access from an Active Link? I believe you can do it through series of DDE actions, but I'm having trouble with the right combination. I believe the first one has to be [OpenDatabase database], and the following actions should include a TransferText, etc. Do

Re: ARSystem 7.0.01 Patch 001 to Patch 002 ISSUES!!!

I'm glad to hear that I'm not the only person seeing these artifacts. I've attempted to contact BMC about it (via web, email), but have yet to receive a response. Thanks, Scott. On 8/20/07, Susan Palmer [EMAIL PROTECTED] wrote: ** Mine has y's with the double dots over the y. Not sure what

Re: WS2003 SP2 (AND Tomcat 5.5.17)

Tony, you could bump that tomcat up right ? 5.5.23 ? On 8/21/07, Tony Worthington [EMAIL PROTECTED] wrote: I can't speak to workflow causing issues in Mid-Tier, but the tcnative.dll issue is that Tomcat *sometimes* ends up eating 100% of 16 cpu's indefinitely. The dll is located in the

Customer Change Notifications

ARS 7.02 Patch 3 ITSM Patch 5 All our change notifications work except for notifications to the customer. In particular when a change is created I expect a notification to be sent to the requester informing them the change number. Is this a bug or some data configuration I am missing for

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Carey, Gary, Thanks for your notes. Carey, mine isn't the Date/time field but the Date field so $TIMESTAMP$ cannot be used to compare it but the $DATE$ keyword would have to be used instead. Gary, about using external, sure I can try that and see if it works. I don't yet see why this

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Joe, I agree that the qualification SHOULD work directly in the table field, but in my experiences, for some reason it does not. Give out the External a try, I'll bet you a Mt. Dew (if I ever meet you) that it will :) Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc.

Re: WS2003 SP2 (AND Tomcat 5.5.17)

Thanks Tony, I'll see if Tomcat is eating up my cpu's and if so will do as you say and see if that helps any.. Regards Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Tony Worthington Sent: Tuesday, August 21, 2007 9:12 AM

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

How did you know that's my favorite soda after coke :-) Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, August 21, 2007 10:38 AM To: arslist@ARSLIST.ORG Subject: Re: Bug with

Re: ITSM 7 OOtB emails

I had the same problem, Shawn. If I remember correctly, the '#' is added by the program. Try just entering the field name with '$', like normal - I think that was what worked. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson,

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Well, I've grown up on Mt. Dew. Anyone who knows me can attest that I have probably more Mt. Dew in my veins than blood at any one time! Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion

Re: WS2003 SP2 (AND Tomcat 5.5.17)

Is that the latest version of Tomcat? I thought 5.5.17 was.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of patrick zandi Sent: Tuesday, August 21, 2007 9:44 AM To: arslist@ARSLIST.ORG Subject: Re: WS2003 SP2 (AND

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

I've been that way with coke.. Anyway getting back to the thread, did you notice this on just the $DATE$ keyword or the $TIMESTAMP$ keyword as well? I am pretty sure the $TIMESTAMP$ keyword works as expected at least on version 6.3.x. I am not sure if the $DATE$ works on 6.3 as I don't think I

Character Fields as Dropdowns in 6.3...Fixed?

Anyone know if the issue about the CLEAR option not showing up in character fields set as dropdowns has been fixed by a patch in 6.3? I see patches 21 and 22 are out, but the description is blank. Another annoyance concerning character fields as dropdowns-the X and Y coordinates do not work.

Re: WS2003 SP2 (AND Tomcat 5.5.17)

http://tomcat.apache.org/ On 8/21/07, Joe D'Souza [EMAIL PROTECTED] wrote: ** Is that the latest version of Tomcat? I thought 5.5.17 was.. Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *patrick zandi *Sent:*

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Well, I'm not using either of the keywords, so I didn't have problem with those. What I had problem was the equivalent of your $Queue$ reference. For some reason, that wasn't expanding properly. It would not surprise me if the $Queue$ wasn't expanding properly for me, that you would also

Removing mass amount of Users

I'm wondering if I can't run an escalation to remove a bunch of users out of our test environment. We're using the configuration utility in Remedy and I know that I could just do a wipe of the user form but I want all the other data the configuration utility stores in other forms gone too. We're

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

I thought the NULL thingy was strange too. I didn't notice these qualifications behave differently on display only forms from regular forms though.. that's a new one to me. Did you ever raise a support call regarding that and if so what was the response you got? Not working as designed I hope..

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

What do your SQL logs say is being used for the qualification? Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Joe D'Souza [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/21/2007 07:36 AM

Re: ITSM 7 OOtB emails

Thanks Rick. I'll give that a shot. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, August 21, 2007 9:41 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 OOtB

Mid-Tier $TIMESTAMP$ Question

Hello Listers, ARServer 7.0.01 HelpDesk 6.0 I just noticied a weird anomaly regarding our Mid-Tier. 1) User creates a HD Case from website using the mid-tier. 2) Case worklog is updated from client in Central Standard Time. Case Worklog shows correct CST $TIMESTAMP$ in worklog. 3) User views

Re: Mid-Tier $TIMESTAMP$ Question

Jase, What's the time zone setting for the OS on the mid-tier server? I'm guessing that it's set up as Pacific Standard Time. Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Tuesday, August

Re: Mid-Tier $TIMESTAMP$ Question

My understand about mid-tier and timestamp is that it only does that if you are using a preference server and it uses the timezone in that preference record. Otherwise it uses the server timezone _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf

ARS Data Relationships

Is there a diagram that shows the relationships between the base AR forms? ... And maybe the ITSM 6/7 forms too? Thanks, Michael The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties

Re: Mid-Tier $TIMESTAMP$ Question

I have wondered why the mid-tier doesn't pick up the OS date, time, and time zone data automatically. It seems like there are java pieces that do that which could be easily incorporated into the Midtier. This would actually make it function more like the desktop client. Then the time zone

Re: ARS Data Relationships

Michael, you can view the database layout of all of the core remedy forms in the DatabaseRefGuide-630.pdf if you are on version 6.3. I'm not sure what it's called in 7.x. I do not have an answer for ITSM, as I do not use it. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications,

Table Field qualification

Hello Everyone I hope somebody can answer this… I have a form with the following fields LOCATION - A character field with a menu append POSITION - A character field with a menu append TABLE - A table field whose source form is a JOIN form of employee location and employee position. This

Re: Removing mass amount of Users

What version of ARS Application(s) are you running? My answer might be different... Thanks-n-advance; HDT Platform Incident / Problem Manager Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your

Re: Removing mass amount of Users

I'm sorry, I should have stated that first lol. I'm running Remedy 6.3 with the Change Management module and configuration module. I'm pretty sure it's not ITSM but just the Change Module. Has a bunch of SHR and SHRCFG forms I know that. On 8/21/07, Robert Molenda [EMAIL PROTECTED] wrote:

Re: Table Field qualification

Michael, Here is a link to Educational Viewlets on our website: http://www.buoyantsolutions.net/ARS_Education.html Look for the one using External() Keyword. HTH Regards...Gidd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Micheal

JOB: Senior Remedy Developer in San Diego

Good Morning, Serco is looking to add another Remedy Developer to its team. This is a regular/full time/exempt position, with full benefits (medical, dental, vision, life, 401K, vacation, sick time, 10 paid federal holidays, etc). The candidate must be eligible for a government security

Re: Table Field qualification

Why not just change the table qualification to $LOCATION$ LIKE % + 'LOCATION' = % AND $POSITION$ LIKE % + 'POSITION' + % ?? Sorry if I'm misunderstanding the issue and oversimplifying it. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: Removing mass amount of Users

No problem, we all sometimes press the SEND button a sentence short of a full-email ;) Unless they corrected it in ITSM6 the workflow on delete of 'User' table records does not cascade into the Application... And update of SHR:People Support Staff from Yes to No did not clean up the Application

Re: Error in query..URGENT

Nisha, It is a common mistake is to delete the attachment pool before the attachment fields. Are you sure you removed the attachment fields? Open the form in the Admin Tool and go to the Form (Menu) -- Current View (Menu) --Fields in View (Menu Item) and verify that these fields do not appear

Re: Removing mass amount of Users

You are the man Robert! The man! I didn't realize all the forms the user was tied to. And your right, the functionality of deleting a user is broken as I sometimes see ghost users when we assign Change tickets. Thanks a lot. Saves me some time trying to back trace everything ( though I need to

Re: Table Field qualification

Okay, my suggestion is that whenever the user chooses a location, on menu/row choice, set location = location + X where X is some delimiter you choose. Next, before you do the table refresh, you need to see if that delimiter is in the location field, if it is, then use substr and strstr to parse

Re: Table Field qualification

Hi Norm Thanks for your reply.. Let me explain the requirement in a more articulate way... When a user selects a value from the menu on the LOCATION field ( say ILLINOIS) and a value from the menu on the POSITION field ( say Supervisor) the table field gets the data pertaining to all

Re: Table Field qualification

Hi Gary Thanks for the reply..I will try it out. Thanks Mike On 8/21/07, Opela, Gary L Contr OC-ALC/ITMA [EMAIL PROTECTED] wrote: Okay, my suggestion is that whenever the user chooses a location, on menu/row choice, set location = location + X where X is some delimiter you choose. Next,

Re: Table Field qualification

You should be able to use the LIKE operator for that. When you append values, the character field holds multiple string values. One value is easy. Say Florida is the one value in the field. Then you can just use equals as the operator. When you append, however, the string becomes more

Re: ITSM 7 OOtB emails

Shawn, Phone Number is never actually passed into the notification system, thus the parser puts in a null value. You have to add it to the workflow that the parser uses to translate #Phone Number#. There are 3 (i think) filters that do this. One to the staging form and 2 other for individual

RKM issues when requiring Client Certificates

I'm putting in a call to help from the list for anyone out there using Remedy Knowledge Management via the MidTier on a web server which is set to require client certificates. I can think of only one other ARSLister at the moment (Mr. Tony Worthington) who uses RKM at all. My RKM

orphaned tasks

Has anybody found a search that works when looking for orphaned tasks (the task was created, but the ticket wasn't saved) in arsys7.x? Thank You, Chris Doble Mobile: 949-533-5346 ___ UNSUBSCRIBE or access ARSlist

Re: orphaned tasks

I've done it for Change Requests on SQL Server 2005. If you're using Oracle, just make whatever necessary modifications to this: select t.task_id , t.rootrequestid, t.assignee_group, t.assignee, t.summary, t.notes from tms_task t left join chg_infrastructure_change c on c.request_id =

SRMS 2.0 install problem

Has anyone successfully loaded SRMS 2.0 on ARS 7.0.1p3 and ITSMp5? Our current system is configured as follows: ARS 7.0.1 patch 003 (including Approval and Assignment) CMDB 2.0.1 patch 003 ITSM Suite 7.0.2 patch 005 (AM, CM, SD) SLM 7.0.2 patch 004 DSL patches 1516 and 004 SRMS 2.0 Compatibility

Re: How to create a view form

I created the view in the ARSystem database. Nall, Roger wrote: Brooks, In which database did you create the view? Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM

Steps to update group list on the User form

Hello everyone, I am trying to update the group list on the user form after I make a change to the Group Name on the Group Form. I wondering if anyone knows the process steps by which the group List gets updated. I have read a few list entries in the Archives, but I haven't nailed down an

Re: Steps to update group list on the User form

Version etc will help get you answers that will work for you. Include whether you're using ITSM etc. On 8/21/07, Broyles Robert K Mr CTR USAF 96 CS/SCCE [EMAIL PROTECTED] wrote: Hello everyone, I am trying to update the group list on the user form after I make a change to the Group Name on

Re: Steps to update group list on the User form

The list of groups in the system is cached by the user tool when a person logs on. Until you log off and back on to the User tool you will see the old name. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Broyles Robert K

Re: Steps to update group list on the User form

The version of Remedy that I am on is 6.3 patch 21 SQL Server 2K sp4 Windows server 2003 sp2 Windows Admin Tool 6.3 patch 20 Windows User Tool 6.3 patch 20 No ITSM ___ UNSUBSCRIBE or access ARSlist Archives at

Re: SRMS 2.0 install problem

Thanks for the feedback David! As it turns out, the same technique got me past the DSL version problem only I'll be setting the name back to what it actually is when done. - Don -Original Message- From: david Haddad [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 21, 2007 2:12 PM To:

Re: WS2003 SP2 (AND Tomcat 5.5.17)

I don't know where the subject got changed, but I am on Tomcat 5.5.23 and Apache/SSL 2.2.4 with mod_jk 1.2.23 -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 patrick zandi [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/21/2007 08:43 AM

Re: RKM issues when requiring Client Certificates

Since I was mentioned, I feel obliged to respond. :-) Nope, can't help ya since we're going the Apache route... *grin* -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Watson, Benjamin A. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList)

Re: Diary field copy

Fred, Unfortunately the 0-length display-only field would always come back blank for me when I tried this approach. This made me think to create a 0-length (optional) character field and I just imported the work log field into it in addition to the diary field. That worked like a charm. Hacks

Re: Steps to update group list on the User form

Although you see the name of the Group in the list what is actually held is the GroupID. -Original Message- From: Broyles Robert K Mr CTR USAF 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tue, 21 Aug 2007 4:13 pm Subject: Steps to update group list on the User form

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Joe, I can't remember the bug number off the top of my head, but there has been a longstanding issue with the use of the $DATE$ keyword in workflow qualifications when used against Date fields. The keyword incorrectly expands to a Date/Time integer value instead of a Date integer value. It

Modify a View Form entry using Java API

Wanted to see if anyone has info for the following case. There are a bunch of Filters defined for a Modify operation on a View form. An external Java program sends in multiple Modify requests to this form. When we use an external Java program to modify records in this View form, once a Modify

Re: Diary field copy

Glad you got it working Usually the DO field works. i.e. Say your form is MyForm, the Diary is WorkLogDiary, and the 0 length DO field is zTmpWorkLog. I do an Active Link on Display of MyForm (In your case it could have been the first AL on button click) Action 1: Set Fields

Re: Modify a View Form entry using Java API

Dear Arthurj (software_architect), To my knowledge there is no way to alter the atomic nature of the ARS API. (vai the Java API or the C API.) The trick is to realize that the ARS server is a multi-threaded server. You can control how your client talks to the ARS server and how many threads are

Re: Modify a View Form entry using Java API

Thanks Carey. The Java program I mentioned earlier is a multithreaded app which sends in 8 threads to a Private server 390682 (min 4 and max 8 threads). Each thread is a Modify request to that View form. From the logs it seems like every thread waits for all the relevant Modify Filters to

Re: Modify a View Form entry using Java API

I would think that each thread would be relieved as soon as the modify of that one record is completed in the View form and not wait for the Modify filters depending on that Modify to complete, since there are no Filters with names ending in `!. Arthur arthurj wrote: Thanks Carey. The Java

Re: Bug with comparing a Date field to the $DATE$ keyword in a table fields qualification???

Now that would explain the cause of the error.. The integer converted by the 'Start Date' would then always be less than the integer converted by the $DATE$ if it expands to the date time integer thus returning all the records.. Joe -Original Message- From: Action Request System

Re: Modify a View Form entry using Java API

Arthur, each thread would be relieved as soon as the modify of that one record is completed in the View form You are completely correct about that. However, where you think completed should be reached is actually not where it actually ends. The transaction (or API call if you prefer) is not

Re: Error in query..URGENT--Resolved

Hi Carey, You are absolutely right. I deleted the pool first without deleting the attachment fields. I followed the steps that you mentioned and now everything seems to be fine. Thanks so much your help but I can't help to wonder that if the base (for eg. attachment pool) is deleted then