Re: SQR error

[Peter Clark <PGCLARK@VAC-ACC.GC.CA>]

Maria,

We recently experienced a vaguely similar problem (works fine in Prod, gets 
fetch error in Test) when our SQR.INI files got out of synch (prod environment 
version had date handling directive that test environment version didn't have).

This is only a shot in the dark, but I would suggest that you make sure that 
your SQR.INI (or PSSQR.INI if in PeopleSoft environment) files are the same.

Peter

>>> "Cadenas, Maria (MT)" <MCadenas@DOW.COM> 2001/01/23 9:46:27 am >>>
Guys,

We get the error below when running the report in a real environment, but
not in our testing environment. My gut instinct tells me that the issue is
technical (amount of data in the real environment vs.. testing environment),
but the Tech team thinks it's a problem with the SQR. We don't have any
logic that causes the program to be cancelled within the program, and it's
running on the server so the user cannot hit ctrl C and kill it. any ideas?
suggestions?


BEGIN-REPORT
Report Began At: 08:49:27  01/18/01
Loading Arrays Started...
Arrays Loaded.
(SQR 5528) ORACLE OFEN error 1013 in cursor 18:
   ORA-01013: user requested cancel of current operation

Error on line 2008:
   (SQR 3725) Bad return fetching row from database.

SQR: Program Aborting.