[sqr-users] RE: [sqr-users] Re: [sqr-users] RE: [sqr-users] Réf. : [ sqr-users] ORA-0 1013 and SQR 3725 errors

["Knapp, Richard" <KnappR@umsystem.edu>]

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] Réf. : [ 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] Réf. : [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 répondre à 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
>
>_______________________________________________
>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

************************************************************
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