12c Cloud Control: Error 1405 Reported for Queue Table SYSMAN.EM_EVENT_BUS_TABLE in EM Repository
(Doc ID 1585306.1)
Last updated on OCTOBER 01, 2013
Applies to:Enterprise Manager Base Platform - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Using 12c OMS with repository in a 188.8.131.52 version database.
The database alert.log shows the below errors repeated multiple times:
Wed Jul 31 01:05:27 2013
Errors in file /u00/app/oracle/diag/rdbms/prdemre3/PRDEMRE3/trace/PRDEMRE3_q000_10000.trc:
ORA-01405: Fetched Column Value Is Null For An Advanced Queue
The corresponding trace file shows:
kwqitmmit during kwqitmmit:deq log proc: Error 1405 in Queue Table SYSMAN.EM_EVENT_BUS_TABLE
kwqicaclcur: Error 1405
Cursor Session Number : 498
Cursor Session Serial : 29115
Cursor Pin Number : 24585
kwqitmmit during kwqitmmit:end proc: Error 1405 in Queue Table SYSMAN.EM_EVENT_BUS_TABLE
kwqitptm: error 1405 encountered during serving 59478
KSV 1405 error in slave process
- Running the below query in the repository database returns a value > 0, indicating that there are corrupt entries in the EM_EVENT_BUS_TABLE:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!