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

[sqr-users] Odd SQR Behavior - Return code 256

We are running SQRs on a Windows server via Perl scripts against an
Oracle 10g RAC database on Linux.
 
I am coming across a very odd situation with various SQR programs.  Here
is what happens.
 
A program will run that has run successfully many times an it will fail
with the following error
 
(SQR 5528) ORACLE OCIStmtExecute error 1861 in cursor 7:
   ORA-01861: literal does not match format string 
 
In this case Cursor 7 is
 Cursor #7:
   SQL = Insert INTO PS_A_EARN_TOT_TBL      (ERNCD, A_EARNS_TOTAL,
         A_HRS_TOTAL, DESCR) Select AA.ERNCD, 0, 0, AA.DESCR From
         PS_EARNINGS_TBL AA Where AA.EFFDT    = (select MAX(AA1.EFFDT)
From
         PS_EARNINGS_TBL AA1 Where AA.ERNCD   = AA1.ERNCD And
AA1.EFFDT <=
         :1) 
 
where :1 is a string variable containing the current date
 
Then without making any changes to the program or data, the program is
restarted and runs successfully.
 
This seems to happen maybe 1 percent of the time and we have only seen
it happen in our production environment.
 
Does anyone have any ideas what could be causing this?

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