Oracle 12C error tracing and debugging issue (merged 2) [message #669215] |
Mon, 09 April 2018 03:03 |
|
ImSandip
Messages: 3 Registered: April 2018
|
Junior Member |
|
|
Hi
We are upgrading to 12c from 10g.
we are using a dB package which enqueues the messages whenever an error is incurred
Data is loading into W_WSFERH_ERROR_QUEUE ,also logs an error details in log file.
Currently, we are getting below error in log file
Exceptionoracle.AQ.AQOracleSQLException: Invalid column type: getCustomDatum not implemented for class oracle.jdbc.driver.T4CNamedTypeAccessor
Notsure, if this issue with Oracle AQ utility.
Could you please help me on this if anybody has incurred similar issue on 12.1.0.2
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PL/SQL Version 11.2.0.3.0 (Production)
Oracle Procedure Builder V12.2.1.2.0 - Production
Oracle Virtual Graphics System Version 12.2.1.2.0 (Production)
Oracle Multimedia Version 12.2.1.2.0 (Production)
Oracle Tools Integration Version 12.2.1.2.0 (Production)
Oracle Tools Common Area Version 12.2.1.2.0
Oracle CORE 11.2.0.3.0 Production
Thanks,
Sandeep
|
|
|
|
|
|
|
Re: Oracle 12C error tracing and debugging issue (merged 2) [message #669237 is a reply to message #669233] |
Mon, 09 April 2018 09:42 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
ImSandip wrote on Mon, 09 April 2018 07:37Currently, we log error details into a file in server and also into DB table W_WSFERH_ERROR_QUEUE, which uses OAQ utilities (SYS.DBMS_AQADM).
Looks like in current version, exception is getting raised in log file. ,
When you observe different results, then you can be 100% certain that something is different.
Since we can't access either or your systems, this means only you can compare & contrast what is same & what is different.
For example, is OS file permission on external log file correct to allow new records to be written to it?
Only YOU determine what is different on the new system.
|
|
|