Error: "ORA-12899: Value Too Large for Column "STARUSER"."W_RESOURCE_HIERARCHY_D"."RESOURCE_ID"" When Executing a P6 EPPM ETL

(Doc ID 2420652.1)

Last updated on JULY 09, 2018

Applies to:

Primavera Analytics - Version 17.11.0.0 and later
Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute a P6 EPPM scheduled ETL (LOAD_PLAN_DAILY) the following error occurs causing the ETL to fail:

ERROR
-----------------------
[ERROR] After Loading Package Global, duration = 22 seconds
[ERROR] PROC_AFTER_LOADING_PKG_GLOBAL
[ERROR] 0 \-\ Load EPS Resource Role Hierarchies
[ERROR] 1 /-/ Procedure - Load EPS Resource Role Hierarchies - LoadEpsResRoleHierarchies
 ODI-1228: Task Procedure-Load EPS Resource Role Hierarchies-LoadEpsResRoleHierarchies fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS. Caused By: java.sql.SQLException: ORA-12899: value too large for column "STARUSER"."W_RESOURCE_HIERARCHY_D"."RESOURCE_ID" (actual: 48, maximum: 40) ORA-06512: at "STARUSER.HIER_PKG", line 709 ORA-06512: at line 3 ...


ADDITIONAL INFORMATION
-----------------------
The LOAD_PLAN_REALTIME_GLOBAL ETL is also showing failure status relative to the above issue.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to the Analytics Administration Application
  2. Click the associated datasource for P6 EPPM
  3. Run an ETL
  4. Note the failure which occurs

 

Changes

 

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