My Oracle Support Banner

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:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


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




To view full details, sign in with your My Oracle Support account.

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

In this Document

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