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 and later
Primavera Analytics Cloud Service - Version and later
Information in this document applies to any platform.


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

[ERROR] After Loading Package Global, duration = 22 seconds
[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 ...

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

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





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