Demantra Upgrade From 12.2.3 To 12.2.5- Engine fails-NOTIFICATION.INITIALIZE FAILURE: -24000 ORA-24000: invalid value. Editioned Schema (Doc ID 2138804.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

Upgraded Demantra from 12.2.3 to 12.2.5.1 and engine fails- Failed to
initialize notification queue for Engine Starter

customer following this Note:12.2.5.1 Engine Deployment Guide (Doc ID
2069139.1)
Applied mandatory patches for 12.2.5.1

Notification patch has been applied as per version_details_history
12.2.5 1 12250157 04/17/2016 21:48:57

Manually create:
create or replace TYPE notification_type
AS OBJECT
( msg_id VARCHAR2(32),
timeout INTEGER,
content VARCHAR2(4000)
);

Still has this issue.
[demuat@demqaapp01 bin]$ ./EngineStarter.sh &
[1] 13712
[demuat@demqaapp01 bin]$ source
/APSQA/demantra/product/AE/Engine/bin/setenv.sh; ./EngineStarter DEM_CONN
starter1 5
2016-04-19.05:31:04 WARNING: Old aapp01.cosintl.com was removed from
ENGINE_STARTER_LIST
2016-04-19.05:31:04 ERROR: Failed to initialize notification queue for Engine
Starter ID: aapp01.cosintl.com, Status: FAILURE: -24000 ORA-24000: invalid
value COSIDP.AAPP01.COSINTL.COM_OUT, QUEUE_TABLE should be of the form
[SCHEMA.]NAME, Exiting...

[1]+ Done ./EngineStarter.sh

db_exception_log :
NOTIFICATION.INITIALIZE Error failed to create queue
table : AAPP01.COSINTL.COM_OUT
NOTIFICATION.INITIALIZE ERROR - Failed to create queue
table : AAPP01.COSINTL.COM_IN
NOTIFICATION.INITIALIZE FAILURE: -24000 ORA-24000:
invalid value COSIDP.AAPP01.COSINTL.COM_IN, QUEUE_TABLE should be of the form
[SCHEMA.]NAME
NOTIFICATION.INITIALIZE Error failed to create queue
table : AAPP01.COSINTL.COM_IN

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