My Oracle Support Banner

Error 'ORA-12899: Value Too Large for Column "STARUSER"."STG_RESOURCERATE"."RESOURCEID"' When Attempting to Run the ETL Process (Doc ID 2351575.1)

Last updated on AUGUST 19, 2019

Applies to:

Primavera Analytics Cloud Service - Version and later
Primavera Analytics - Version 17.7 to 17.7 [Release 17.7]
Information in this document applies to any platform.


When attempting to run ETL, the process fails and the following error occurs in the log:

staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 124
staretl [INFO] (Message) - Exception: Error during extract for table STG_RESOURCERATE: ORA-12899: value too large for
staretl [INFO] (Message) - (100,RESOURCERATE,STG_RESOURCERATE,n/a,n/a)
staretl [INFO] (Message) - DECLARE
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-12899: value too large for column "STARUSER"."STG_RESOURCERATE"."RESOURCEID" (actual: 41, maximum: 40)
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 185
staretl [INFO] (Message) - ORA-06512: at line 4


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

  1. Run ETL
  2. Observe error in log.



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

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