After Fresh Install Of Demantra 12.2.6, Rebuild Model Fails. (Doc ID 2277947.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

On : 12.2.6 version, Technical

After fresh install of Demantra 12.2.6, Rebuild Model Fails.

Newly installed Oracle 12.2 DB on Windows 2012R2
New install of Demantra 12.2.6 (patch 25168361)
Installed patch 25403411 - success
Installed patch 25420760 - success
Installed patch 25513274 - reports not allowed due to being for 12.2.5.1

SYS_GRANTS.sql run as SYS; successful.

Invalid Objects at the end of install and patching are:

CTO_CURSOR_POOL
PARALLEL_MANAGER_TYPE
PARALLEL_MANAGER_SPLIT

These are recreated and there are now no INVALID objects in the schema

Open Business Modeler as DM, use menu "Data Model" >> "Open Model". Select the existing seeded model and select "ok". Click through wizard making no changes. Last screen select "Save" then "Rebuild Model". New window appears, select "Upgrade Existing Model" and do not check the time bucket option.

Process fails with error:
[
ERROR - ORA-20001: Error in Procedure DEFINE_GLOBAL_VARIABLE
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "DEM.DATA_MODEL", line 18
ORA-06512: at "DEM.DATA_MODEL", line 13210
ORA-06512: at "DEM.DATA_MODEL", line 13783
ORA-06512: at "DEM.EP_BUILD_MODEL", line 11
ORA-06512: at line 1
- Problem with procedure EP_BUILD_MODEL !!
]

Very similar error found in post_install.log at <Demantra root folder>\Demand Planner\Database Objects\Oracle Server\

[
EXEC CALL_DM_BUILD_PROCEDURES
BEGIN CALL_DM_BUILD_PROCEDURES; END;

*
ERROR at line 1:
ORA-20001: Error in Procedure DEFINE_GLOBAL_VARIABLE ORA-06502: PL/SQL: numeric
or value error: character string buffer too small
ORA-06512: at "DEM.DATA_MODEL", line 18
ORA-06512: at "DEM.DATA_MODEL", line 12899
ORA-06512: at "DEM.DATA_MODEL", line 13471
ORA-06512: at "DEM.CALL_DM_BUILD_PROCEDURES", line 72
ORA-06512: at line 1
]

Cannot build model. Need this process to run successfully.
 
ERROR
-----------------------
ORA-20001, ORA-06512, ORA-06502

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. fresh install of Demantra 12.2.6
2. Installed patch 25403411 - success
Installed patch 25420760 - success
Installed patch 25513274 - reports not allowed due to being for 12.2.5.1

3. SYS_GRANTS.sql run as SYS; successful.
4. Existing Model" and do not check the time bucket option.
Process fails with error

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.