Re: sqr hangs in process sheduler

[Rachael Beatty <Rachael_Beatty@HILTON.COM>]

Also compare the process types.  This is what drives the sqr run and sets
the flags.  Someone may have customized the delivered process type for your
old database.

Also check you sqr flags in your configuration manager and also check the
flags set up on the process definition.

Rachael

> -----Original Message-----
> From:   "Allen Cunningham" <allen.cunningham@SONOMA.EDU>@INTERNET
> Sent:   Monday, October 22, 2001 2:55 PM
> To:     SQR-USERS@list.iex.net
> Subject:     Re: sqr hangs in process sheduler
>
>
> Custom sqr, attached to 'SQR Report' standard process type. Thanks for the
> input, I'll check out the process defs for both tools release and see if
> there are any differences.
>
>
> ac
>
> -----Original Message-----
> From: Discussion of SQR, Brio Technology's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Rachael Beatty
> Sent: Monday, October 22, 2001 1:30 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: sqr hangs in process sheduler
>
>
>
>
>
> Is this a delivered sqr or a custom sqr?  Is it attached to a delivered
> proces type or a custom process type?
>
> Validate theat the process difnition and the process type are set up the
> same in both tools releases.
>
> HTH,
> Rachael
>
> > -----Original Message-----
> > From:   "Sanjeevani Bhide" <san_bhide@HOTMAIL.COM>@INTERNET
> > Sent:   Monday, October 22, 2001 12:11 PM
> > To:     SQR-USERS@list.iex.net
> > Subject:     Re: sqr hangs in process sheduler
> >
> >
> > Does your SQR need any input values?
> >
> > >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 11:37:46 -0700
> > >
> > >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
> >
>
> (See attached file: C.DTF)
>

(See attached file: C.DTF)

C.DTF