Re: sqr hangs in process sheduler

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

You've given me some things to look at, thanks for the input, I'll check
them out.

ac

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


There could be a lot of causes why this SQR pgm is in Initiate state.

1. Did you check if somebody has also submitted this same job
   which can also be in error or initiate status.
2. Is the database accessible by anyone else. Other cause is when
   operators did a backup of your database while you submitted the
   job.
3. Are you sure nobody changed the SQR? Does other SQR runs OK?

4. If location is CLIENT did you check the config manager for the
   correct path of the SQR (PSSQR1, PSSQR2 etc)
5. Can you run the same SQR using SQRW.exe? and successful?

>From: Allen Cunningham <allen.cunningham@SONOMA.EDU>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: sqr hangs in process sheduler
>Date: Mon, 22 Oct 2001 13:11:35 -0700
>
>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


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp