12c Cloud Control: Error 1405 Reported for Queue Table SYSMAN.EM_EVENT_BUS_TABLE in EM Repository (Doc ID 1585306.1)

Last updated on AUGUST 20, 2021

Applies to:

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 /<RDBMS_HOME>/<SID>/<SID>/trace/<SID>_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:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.