Re: sqr hangs in process sheduler

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

Process def didn't change since the last time it worked.

ac

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Praveen Gopu
Sent: Monday, October 22, 2001 11:49 AM
To: SQR-USERS@list.iex.net
Subject: Re: sqr hangs in process sheduler


Look at the process definition itself.

Praveen




"Allen Cunningham" <allen.cunningham@SONOMA.EDU>@list.iex.net> on
10/22/2001 02:37:46 PM

Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR, Brio Technology's database reporting
      language"     <SQR-USERS@list.iex.net>


To:   SQR-USERS@list.iex.net
cc:

Subject:  Re: sqr hangs in process sheduler


The sqr is not creating a log file or lis file, so I don't know what is
going on. The sqr used to work before we did an 7.60->7.61 tools upgrade.

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Rick_Creel@AONCONS.COM
Sent: Monday, October 22, 2001 11:19 AM
To: SQR-USERS@list.iex.net
Subject: Re: sqr hangs in process sheduler


When the SQR finishes processing does it report back to the process
scheduler,
notifying that it has completed?  It must set "#completion_code" and
"#prcs_run_status" to the appropriate values.

A 'STOP QUIET' will halt processing with out letting the process scheduler
know
its status.






Allen Cunningham <allen.cunningham@SONOMA.EDU> on 10/22/2001 02:07:11 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  sqr hangs in process sheduler



We are using PeopleSoft financials version 7.61 with sqr version 4.3,
db=Oracle
For some reason an sqr submitted thru the process scheduler being run
client-side hangs as 'initiated', and never gets processed. Has anyone seen
this before??

ac