Unable To Create Queue Table - ORA-25207: enqueue failed ; ORA-03135: connection lost contact

(Doc ID 2137397.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Unable to use queue table and multiple errors in db_exception_log table. Trying to create queues to run parallel jobs by multithreading.

Unable to run jobs that include queue tables or able to queue jobs Processes which using advanced queuing.

Attempting to run the Engine, which crashes with an unknown error.

In DB_EXCEPTION_LOG, see the following error messages show up from the
same time:

NOTIFICATION.INITIALIZE ERROR - Failed to create queue
table : ENG_MANAGER_OUT_Q
NOTIFICATION.INITIALIZE Error failed to create queue
table : ENG_MANAGER_IN
NOTIFICATION.INITIALIZE FAILURE: -24032 ORA-24032: object
AQ$_ENG_MANAGER_IN_S exists, index could not be created for queue table
ENG_MANAGER_IN
NOTIFICATION.INITIALIZE ERROR - Failed to create queue
table : ENG_MANAGER_IN
NOTIFICATION.INITIALIZE Error failed to create queue
table : ENG_MANAGER_OUT
NOTIFICATION.INITIALIZE FAILURE: -24032 ORA-24032: object
AQ$_ENG_MANAGER_OUT_S exists, index could not be created for queue table
ENG_MANAGER_OUT

ERROR EngineHeartBeatMonitor detected frozen PollEngineManager thread.


NOTIFICATION.LISTEN FAILURE: -3135 ORA-03135: connection lost contact
NOTIFICATION.NOTIFY FAILURE: ENQUEUE dem_appserv
NOTIFICATION.NOTIFY FAILURE: -25207 ORA-25207: enqueue failed, queue TPM.DEM_APPSERV_IN_Q is disabled from enqueueing
NOTIFICATION.NOTIFY TIMEOUT Notify notification ENG_MANAGER timeout 10

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