[sqr-users] Réf. : [sqr-users] ORA-01013 and SQR 3725 errors

["Thaî Le Tat" <thai.le-tat@creditlyonnais.fr>]

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





Ce message contient des informations confidentielles ou appartenant au
Crédit Lyonnais et est établi à l'intention exclusive de ses
destinataires. Toute divulgation, utilisation, diffusion ou reproduction
(totale ou partielle) de ce message, ou des informations qu'il contient,
doit être préalablement autorisée. Tout message électronique est
susceptible d'altération et son intégrité ne peut être assurée.
Le Crédit Lyonnais décline toute responsabilité au titre de ce
message s'il a été modifié ou falsifié. Si vous n'êtes pas
destinataire de ce message, merci de le détruire immédiatement et
d'avertir l'expéditeur de l'erreur de distribution et de la destruction
du message.
Crédit Lyonnais, SA au capital de Euros 1.807.874.827 - RCS Lyon B 954 509 741
Siège Central : 19, boulevard des Italiens. 75002 Paris. France

This e-mail contains confidential information or information belonging
to Crédit Lyonnais and is intended solely for the addressees.
The unauthorised disclosure, use, dissemination or copying (either whole
or partial) of this e-mail, or any information it contains, is prohibited.
E-mails are susceptible to alteration and their integrity cannot be guaranteed.
Crédit Lyonnais shall not be liable for this e-mail if modified or falsified.
If you are not the intended recipient of this e-mail, please delete it
immediately from your system and notify the sender of the wrong delivery
and the mail deletion.
Crédit Lyonnais SA.
Share Capital of Euros 1.807.874.827.
Registered Office : Lyon (B 954 509 741)
Central and administrative Office : 19, boulevard des Italiens. 75002 Paris. 
France