How are you issuing the run process? If you use the Run Process action, it forks the work and continues with the workflow processing. If you use a set fields action to run the process the workflow will wait on a return from the script before continuing.
On Wed, Jan 5, 2011 at 3:05 PM, Remedy <rem...@rowshay.com> wrote: > 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"
