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 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Using 12c OMS with repository in a 11.2.0.3 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:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms