My Oracle Support Banner

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 23, 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





To view full details, 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 a vibrant support community of peers and Oracle experts.