I can't take responsibility for this....about 2 years ago I had a similar 'I
need the client to wait for a server process' issue and someone on the list
kindly suggested something similar to it....I have it in about 5 places in
my app at this point....extremely nice :)

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Remedy
Sent: Thursday, January 06, 2011 1:37 PM
To: [email protected]
Subject: Re: Delayed Table refresh

I went with the guide and interval timer option. Mostly because we are not
sure on the time to complete the running of the script factor. Production
has a lot more rows to sort through. 

At an interval of 3 seconds, the script had completed before the first
refresh occurred for the batch of test runs we did. We had close to the same
response times when running via mid-tier as the UserTool.

We figure we will increase the interval timer to 15-30 seconds so that users
don't get accustom the the fast response times. As we increase the
complexity of the script, the time to complete will go up, leaving user
complaining that it's taking longer than usual (as experience shows).

The one disadvantage of using the interval, the log files are constantly
being added to every-time the interval triggers. That is a given. The window
this runs under is short lived, so not to much of a problem.

Thanks for the information on the two variations. Would never thought of
using this new feature. See lots of new possibilities now.
 
We thought we would add in a counter for each interval that would abort
after a certain point. This is in case there was a point of failure between
the run process and starting the interval.

Brent...

Sent from my iPhone

On Jan 5, 2011, at 1:36 PM, LJ LongWing <[email protected]> wrote:

> Brent,
> You can either use a setfield run process, which will make additional
> actions wait till the process is done, but if your script takes more than
60
> seconds (the maximum value of the set fields run process), then this
> solution won't work.  If that's the case, here is my recommendation
> 
> Create an AL Guide
> Inside that guide create an AL that checks for the 'process done' record
> If it exists, have a second active link set a flag on the form saying
'don't
> check anymore', and refresh the table
> 
> Then....create an interval based AL that checks your flag field, if it's
not
> set, then call the guide
> 
> With this process you will still have an AL that fires every 'x' seconds,
> but it won't do anything once the process is done
> 
> It works well.  Let me know if this does anything for you.
> 
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Remedy
> Sent: Wednesday, January 05, 2011 2:06 PM
> To: [email protected]
> Subject: Delayed Table refresh
> 
> Hey everyone. 
> 
> Got a problem that I can't think of how to get around.
> 
> We have a Display-Only form that when it is opened, it triggers an active
> link that in turn executes a Run Process that runs a PL/SQL script on the
> server.
> 
> This script basically runs through our CMDB and populates a table in the
> database with some data.
> 
> On the Display Only form that was opened, we have a table that shows data
> from a View-Form that is based off the table that was populated by the
> script/Run-Process.
> 
> The only way to display the results is by manually doing a refresh on the
> table.
> 
> I have tried issuing a table refresh after the Run-Process, but it seems
> this occurs before any data has been populated by the script.
> 
> How do I put in a delay before the table refresh happens, or keep
refreshing
> the table till the data shows up. 
> 
> I could use an active link guide that keeps doing a SQL call looking for
the
> results and when found, exit the guide and then do the refresh, but that
> would be a performance issue I would think.
> 
> The script does populate a row at the end, which is used as a signal that
> the script is done.
> 
> Any thoughts or suggestions would be a big help. The script is doing the
> equivalent of an impact analysis for a specified CI. Our structures are
> complex and have a lot of rules as what will impact something else.
> 
> We are running 7.1ARS and CMDB 2.1 on a Solaris OS with an Oracle 11
> database.
> 
> Thanks,
> 
> Brent...
> 
> Sent from my iPhone
> 
>
____________________________________________________________________________
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
> 
>
____________________________________________________________________________
___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

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

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Reply via email to