My Oracle Support Banner

Upgrade data model failed (Doc ID 2534374.1)

Last updated on OCTOBER 20, 2019

Applies to:

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

Symptoms

On : 12.2.7 version, Business Modeler

Issue with Data Model Rebuild

While running EP_LOAD, we are getting below error:
"-24344 ORA-24344: success with compilation error Error in PROCEDURE line 69

dynamic_ddl( 'ALTER PROCEDURE EP_LOAD_ITEMS COMPILE')"

Further, when tried re-building existing Data model and we are getting error :

 

ERROR
-----------------------
DataBase Error

Error - ORA-20001: ORA-24344: success with compilation error
ORA-06512: at "DEMANTRA.DATA_MODEL", line 20
ORA-06512: at "DEMANTRA.DATA_MODEL", line 13375
ORA-06512: at "DEMANTRA.DATA_MODEL", line 14315
ORA-06512: at "DEMANTRA.EP_BUILD_MODEL", line 11
ORA-06512: at line 1
- Problem with procedure EP_BUILD_MODEL !!

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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