RE: [sqr-users] (SQR 6806) String2Em: String to Decimal Object Conversion Error.

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

I am having a problem that may be related to the Oracle version/PS version.  
When I try to link from a Oracle 9i db (in an SQR) to an Oracle 8 db, I get the 
following error:

Enter report start date (DD-MON-YYYY): 01-JUL-2003
Enter report end date (DD-MON-YYYY): 31-JUL-2003
 
Start time: 17-OCT-2003 10:10:13
 
(SQR 5528) ORACLE OCIStmtExecute error 3113 in cursor 1:
   ORA-03113: end-of-file on communication channel

Error on line 199:
   (SQR 3723) Problem executing cursor.

SQR for PeopleSoft: Program Aborting.
(SQR 5528) ORACLE OCITransRollback error 3114 in cursor 0:
   ORA-03114: not connected to ORACLE
(SQR 5528) ORACLE OCITransCommit error 3114 in cursor 0:
   ORA-03114: not connected to ORACLE

If I run the same select from SQLPlus, there is no problem or if I use a 
private link - no problem.  This error has now appeared on a PS v8 db running 
on Ora 8.  I think it may have to do with the encryption that is now required 
for 9i and all the databases that talk to 9i dbs.  SQLPlus is handling the 
encryption but SQR is not (just a guess).  Notice in the above error message 
that the SQR has made and passed its initial syntax, connection and access 
checks.

Here is some further info on this from Richard Woodville:

Richard, 

I have found the solution to the problem below. 

The solution that worked for me was to re-install Oracle 8.16 on my desktop. 

As soon as Oracle 9i was installed on my desktop, I started to experience the 
problem below when running SQRs with a database link with SQRW. 

Another developer here who has Oracle 8.16 installed on his desktop had no 
problem.  As soon as the LAN Admin de-installed Oracle 9i and reinstalled 
Oracle 8.16, my Oracle error messages below cleared up and my SQR with database 
links ran successfully using SQRW. 

If you have any questions, I am happy to try to answer them. 

Regards, 

Richard 

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


-----Original Message-----
From: Alexander, Steve [mailto:Steven.Alexander@sanjoseca.gov]
Sent: Friday, October 17, 2003 10:34 AM
To: SQR User Group (E-mail)
Subject: [sqr-users] (SQR 6806) String2Em: String to Decimal Object
Conversion Error.


When I got this error message a few weeks ago, I dealt with it by rewritting
the program.  Now I've got it again, on a Peoplesoft-delivered program,
BEN040.  Both programs used to work, and I've just realized that they
stopped working on our STAGE database when we upgraded from Oracle 8.1.7.4
to 9.2.0.3.  BEN040 still works in PROD, which is still at Oracle 8.1.7.4.
Does anyone know of a bad SQR 6/Oracle 9 interaction?

_______________________________________________
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