[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] ORA-01013 and SQR 3725 errors


I know this is probably not funny to you but the bit about 'only seems to run 
successfully on Wednesdays' was a laugh out loud chuckler for me and I needed 
one.  Hope you get yours.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Christine Sessler [mailto:cms41@cornell.edu]
Sent: Wednesday, December 04, 2002 12:48 PM
To: sqr-users@sqrug.org
Cc: sn94@cornell.edu
Subject: Re: [sqr-users] ORA-01013 and SQR 3725 errors


All -

Thank you for all of the suggestions.  My friendly DBA and I have spent the 
majority of the last 2 days banging our heads together and trying different 
things.  We were able to finally get 4 (count them 4!) successful runs of 
the program this afternoon AFTER doing the following:

* Changed the order by of a procedure that builds a pay calendar array - in 
essence, to run the smallest paygroup first
* Increased the pay calendar array size from 100 to 1000
* Added On-Error statements to a few PS delivered SELECTS to get better (?) 
error statements
* Changed a PS delivered SELECT to NOT use LOOPS=1 and modified the Order By
* Added an Alter Session SQL to set the date format (although our setup 
sets this up somewhere)
* Upped the Processing Limits in the PSSQR.INI file

After we made these changes, it ran once and then the next timed, died again.

We brought our development instance down and my job was the only one 
running in there when we had our 4 successful runs.

Oh, might I also mention that it seems to also only want to run 
successfully on Wednesdays.

I'll see what tomorrow brings.

Thanks again and if there are any more suggestions, I'd love to hear them.
Chris


At 09:25 AM 12/4/2002 -0500, you wrote:
>Hi,
>
>I have also seen the error "Bad return fetching row from database." occur when
>there is data contention (user was updating data while SQR was trying to 
>access
>it).  If that is the problem, that would explain why it happens at different
>times within the program; it is due to something external, and not to an error
>in the code.  This is really a kind of catch-all error, and it is difficult to
>resolve. "Program stopped by user request." frequently does not seem to have
>anything to do with the user; I think it might be the Process Scheduler 
>that it
>thinks is the user.
>
>Denise White
>Sr. Software Engineer
>Vicor
>
>--__--__--
>
>Message: 7
>Date: Tue, 3 Dec 2002 14:10:32 -0600
>From: "Knapp, Richard" <KnappR@umsystem.edu>
>To: <sqr-users@sqrug.org>
>Subject: [sqr-users]
>=?iso-8859-1?Q?RE=3A_=5Bsqr-users=5D_Re=3A_=5Bsqr-users=5D_RE=3A_=5Bsqr?=
>  =?iso-8859-1?Q?-users=5D_R=E9f=2E_=3A_=5B_sqr-users=5D_ORA-0_1013_and?=
>  =?iso-8859-1?Q?_SQR_3725_errors?=
>Reply-To: sqr-users@sqrug.org
>
>
>Well, I'm thinking that, since the errors all refer to a user request, 
>that this
>is where the request is coming from.  You'll have to trace the code to see why
>that stop is issued.
>
>Richard Knapp
>Database Programmer/Analyst
>Institutional Research and Planning
>University of Missouri System
>573-882-8856
>knappr@umsystem.edu
>
>
>-----Original Message-----
>From: Christine Sessler [mailto:cms41@cornell.edu]
>Sent: Tuesday, December 03, 2002 1:56 PM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] Re: [sqr-users] RE: [sqr-users] Rf. : [ sqr-users]
>ORA-0 1013 and SQR 3725 errors
>
>
>Yes, as PS delivered, 'STOP' is in the program.
>
>
>At 01:45 PM 12/3/2002 -0600, you wrote:
>
> >Does the command 'STOP' appear anywhere in the text of the program?
> >
> >Richard Knapp
> >Database Programmer/Analyst
> >Institutional Research and Planning
> >University of Missouri System
> >573-882-8856
> >knappr@umsystem.edu
> >
> >
> >-----Original Message-----
> >From: Tha Le Tat [mailto:thai.le-tat@creditlyonnais.fr]
> >Sent: Tuesday, December 03, 2002 10:23 AM
> >To: sqr-users@sqrug.org
> >Subject: [sqr-users] Rf. : [sqr-users] ORA-01013 and SQR 3725 errors
> >
> >
> >
> >
> >Timeouts (whether explicitly or implicitly specified or reported) are a
> >frequent cause of ORA-01013.
> >=> Check your Oracle timeout.
> >
> >Are you performing update in your database ?
> >Do you manage commit manually ?
> >
> >Regards
> >Thai LE TAT
> >
> >
> >
> >
> >
> >Christine Sessler <cms41@cornell.edu>@sqrug.org le 03/12/2002 17:02:44
> >
> >Veuillez rpondre  sqr-users@sqrug.org
> >
> >Envoy par :      sqr-users-admin@sqrug.org
> >
> >
> >Pour : sqr-users@sqrug.org
> >cc :    (ccc : Tha Le Tat/DED/DSTI/CLY)
> >
> >Objet :     [sqr-users] ORA-01013 and SQR 3725 errors
> >
> >
> >All -
> >
> >I'm running into a problem that is causing me some grief.
> >
> >I receive the following error(s) when running a SQR.  The problem is that I
> >can not pinpoint where in the SQR the program is failing.  It moves.  I've
> >had the SQR fail quickly with this error, I run it again and it runs 3/4 of
> >the way through before failing.  I've also successfully run the SQR and
> >then run it again and it fails.  I feel like I'm looking for a needle in a
> >haystack.
> >
> >As a side note, this is a cloned and modified version of PS PAYGL02.
> >
> >Can anyone shed any light on where I might try to find out what is causing
> >this problem?
> >
> >I'm on:  Oracle, PeopleSoft 8.1.6
> >
> >
> >(SQR 5528) ORACLE OCIStmtFetch error 1013 in cursor 14:
> >     ORA-01013: user requested cancel of current operation
> >
> >Error on line 1644:   <-- various line numbers are returned
> >     (SQR 3725) Bad return fetching row from database.
> >
> >SQR for PeopleSoft: Program Aborting.
> >
> >Sometimes I get this:
> >SQL-STATEMENT-ERROR
> >PAYGL02, Select Error - TAX-LIABILITIES    <--- various procedures are
> >returned  and the bind variables below return valid data when running just
> >the SQL
> >Bind Variables: Company END, Paygroup EB1, Pay End_Date 09-JAN-2002, Off
> >Cycle N, PAGE_NUM 9.000000, LINE_NUM 5.000000, Separate Check 0.000000, Tax
> >Class is not W, and State is not Blank
> >   Error : ORA-01013: user requested cancel of current operation
> >   SQL Status : -1.000000
> >
> >Error on line 7233:
> >     (SQR 3301) Program stopped by user request.
> >
> >SQR for PeopleSoft: Program Aborting.
> >
> >
> >Thanks,
> >Chris
> >
>************************************************************
>Christine Sessler
>Cornell University
>CIT/Business Information Systems
>120 Maple Avenue
>Ithaca, NY  14850
>
>607.255.8149  - Office
>607.255.6982  - Fax
>cms41@cornell.edu
>************************************************************
>"Genius may have its limitations, but stupidity is not thus handicapped." -
>Elbert Hubbard
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users