Re: SQR not generating a list file

[Robert Stojkovic <robert.stojkovic@IO-CONSULTING.COM>]

It is a standard PeopleSoft message that states that the XXXXX.LIS file (
XXXXX is the SQR name) was not created. The routine does not take into
account that the SQR ran successfully.
One Work Around is to add a procedure after the Do Stdapi-Term Call to print
End Of Report on the report. This will mean a LIS will be created every time
and your users will see that no details were completed. By the way if no
details are printed the Headings will not print.

Robert Stojkovic
robert.stojkovic@io-consulting .com
visit our website www.io-consulting.com <http://www.io-consulting.com>
661 803 3178


> -----Original Message-----
> From: Discussion of SQR, Brio Technology's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Ackerson, Glenn
> Sent: Friday, January 05, 2001 12:37 PM
> To: SQR-USERS@list.iex.net
> Subject: SQR not generating a list file
>
>
> Hi group,
>   I was wondering if any of you had any ideas as to what conditions could
> cause the following log file error message would come out of the process
> scheduler SQR (prcs_sqr) in Peoplesoft when we run this
> particular SQR that
> we wrote in-house, and execute from the Process Scheduler:
>
> SQR: End of Run.
> prcs_sqr: ------------------- Error -------------------
> prcs_sqr: SQR did not generate a list file.
> prcs_sqr: ------------------- Error -------------------
>
> In this instance, I know the report won't have any detail lines - only
> headings, but that's what we want. Our payroll office would like to see a
> blank report indicating that there were no errors on this
> particular report.
>
> When the SQR DOES generate detail lines in addition to the
> headings, the log
> file entries appear like the following:
>
> SQR: End of Run.
> Job number is: 939
> PeopleSoft prcs_sqr Terminating normally
>
> Any ideas on what we might be missing on this? Thanks in advance for your
> response. Since I get messages in digest mode, would you mind cc'ing your
> response directly to me as well as to the listserve. Thanks!
>
> Cheers,
> Glenn Ackerson
>
> **************************************************
> Glenn Ackerson                               Phone: (970) 351-1460
> Information Technology Professional III Fax:   (970) 351-1650
> Internet Address: Glenn.Ackerson@Unco.edu
> University of Northern Colorado
> Information Technology
> Carter Hall                  Greeley, CO  80639
>