Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 12C error tracing and debugging issue (merged 2)
Oracle 12C error tracing and debugging issue (merged 2) [message #669215] Mon, 09 April 2018 03:03 Go to next message
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 #669223 is a reply to message #669215] Mon, 09 April 2018 08:35 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Why the mish-mash of V11 & V12 shown above?
From where does V11 originate when you state the upgrade is from V10:
Re: Oracle 12C error tracing and debugging issue (merged 2) [message #669225 is a reply to message #669223] Mon, 09 April 2018 08:42 Go to previous messageGo to next message
ImSandip
Messages: 3
Registered: April 2018
Junior Member
Could you pls help me with exception

Exceptionoracle.AQ.AQOracleSQLException: Invalid column type: getCustomDatum not implemented for class oracle.jdbc.driver.T4CNamedTypeAccessor
Re: Oracle 12C error tracing and debugging issue (merged 2) [message #669228 is a reply to message #669225] Mon, 09 April 2018 09:06 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
It is NOT possible to say what is wrong when we have no idea what exactly is being done that results in posted error.

BTW, the error is NOT really an Oracle error, like ORA-0001; but it is a Java error.
Re: Oracle 12C error tracing and debugging issue (merged 2) [message #669233 is a reply to message #669228] Mon, 09 April 2018 09:37 Go to previous messageGo to next message
ImSandip
Messages: 3
Registered: April 2018
Junior Member
Currently, 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.
Re: Oracle 12C error tracing and debugging issue (merged 2) [message #669237 is a reply to message #669233] Mon, 09 April 2018 09:42 Go to previous message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
ImSandip wrote on Mon, 09 April 2018 07:37
Currently, 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.
Previous Topic: Spell out numbers to words
Next Topic: ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
Goto Forum:
  


Current Time: Sun Jan 19 22:41:56 CST 2020