Re: Inserting pause in workflow SOLVED
Hi Stephen/Dwayne I was trying the SQL statement, but the problem I have is; I do a Set Fields in a field, something like Please Wait... and then call the WAITFOR DELAY command, but instead of the field being set with the message frst and THEN the delay happening, the delay happens first and the message gets displayed afterwards!! completeley backwards! I tried doing with 2 seperate Active Links, no luck, it goes into the delay immediately, and displays the message afterwards. Any ideas? thanks a lot shafqat Dwayne Martin [EMAIL PROTECTED] wrote: The set fields option worked! In the active link I set a display field to equal $PROCESS$ @@:/opt/remedy/HelpDesk/pause 3. (Anything over 3 seconds and the action would time out.) The filter was the same but without the @@:. In both cases the hour glass displayed for three seconds then I got the message. I tried Stephen's WAITFOR DELAY '00:00:10' option, but I got invalid SQL statement. Is that an Oracle statement? I looked in my Oracle book but can't find any wait command. Anyway, Thank you Stephen and Fred. You've solved my problem. Dwayne Martin Original message Date: Thu, 9 Aug 2007 16:46:02 -0400 From: Heider, Stephen Subject: Re: Inserting pause in workflow To: arslist@ARSLIST.ORG Another option is to use your RDBMS. For SQL Server, Set Fields SQL WAITFOR DELAY '00:00:10' Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, August 09, 2007 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow Do the PROCESS inside of a Set Fields Action A Run Process action does not wait. A PROCESS inside of a Set Fields action waits for the external program to complete. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, August 09, 2007 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow I could be mistaken about this, but I believe the way it works is, when Remedy runs an external process, it does NOT wait for the external process to finish executing before it continues workflow processing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, August 09, 2007 3:05 PM To: arslist@ARSLIST.ORG Subject: Inserting pause in workflow Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: Process: /opt/remedy/HelpDesk/pause 10 Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Shafqat Ayaz Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.. - Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Inserting pause in workflow SOLVED
The set fields option worked! In the active link I set a display field to equal $PROCESS$ @@:/opt/remedy/HelpDesk/pause 3. (Anything over 3 seconds and the action would time out.) The filter was the same but without the @@:. In both cases the hour glass displayed for three seconds then I got the message. I tried Stephen's WAITFOR DELAY '00:00:10' option, but I got invalid SQL statement. Is that an Oracle statement? I looked in my Oracle book but can't find any wait command. Anyway, Thank you Stephen and Fred. You've solved my problem. Dwayne Martin Original message Date: Thu, 9 Aug 2007 16:46:02 -0400 From: Heider, Stephen [EMAIL PROTECTED] Subject: Re: Inserting pause in workflow To: arslist@ARSLIST.ORG Another option is to use your RDBMS. For SQL Server, Set Fields SQL WAITFOR DELAY '00:00:10' Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, August 09, 2007 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow Do the PROCESS inside of a Set Fields Action A Run Process action does not wait. A PROCESS inside of a Set Fields action waits for the external program to complete. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, August 09, 2007 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow I could be mistaken about this, but I believe the way it works is, when Remedy runs an external process, it does NOT wait for the external process to finish executing before it continues workflow processing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, August 09, 2007 3:05 PM To: arslist@ARSLIST.ORG Subject: Inserting pause in workflow Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: ACTL Process: /opt/remedy/HelpDesk/pause 10 ACTL Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Inserting pause in workflow
I could be mistaken about this, but I believe the way it works is, when Remedy runs an external process, it does NOT wait for the external process to finish executing before it continues workflow processing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, August 09, 2007 3:05 PM To: arslist@ARSLIST.ORG Subject: Inserting pause in workflow Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: ACTL Process: /opt/remedy/HelpDesk/pause 10 ACTL Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Inserting pause in workflow
Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: ACTL Process: /opt/remedy/HelpDesk/pause 10 ACTL Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Inserting pause in workflow
Do the PROCESS inside of a Set Fields Action A Run Process action does not wait. A PROCESS inside of a Set Fields action waits for the external program to complete. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, August 09, 2007 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow I could be mistaken about this, but I believe the way it works is, when Remedy runs an external process, it does NOT wait for the external process to finish executing before it continues workflow processing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, August 09, 2007 3:05 PM To: arslist@ARSLIST.ORG Subject: Inserting pause in workflow Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: ACTL Process: /opt/remedy/HelpDesk/pause 10 ACTL Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Inserting pause in workflow
Another option is to use your RDBMS. For SQL Server, Set Fields SQL WAITFOR DELAY '00:00:10' Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, August 09, 2007 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow Do the PROCESS inside of a Set Fields Action A Run Process action does not wait. A PROCESS inside of a Set Fields action waits for the external program to complete. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, August 09, 2007 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow I could be mistaken about this, but I believe the way it works is, when Remedy runs an external process, it does NOT wait for the external process to finish executing before it continues workflow processing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, August 09, 2007 3:05 PM To: arslist@ARSLIST.ORG Subject: Inserting pause in workflow Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: ACTL Process: /opt/remedy/HelpDesk/pause 10 ACTL Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are