My Oracle Support Banner

When Synchronizing P6 to Oracle Primavera Cloud (OPC) the Error "ORA-12899: value too large for column "T_SEED_PRIMEAPP_ADM"."SYS_JOB_SETTING"."JOB_SETTING_VALUE"" Occurs (Doc ID 2748888.1)

Last updated on FEBRUARY 02, 2021

Applies to:

Primavera Gateway - Version 20.9 to 20.12 [Release 20.9 to 20.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 20.9 to 20.12 [Release 20.9 to 20.12]
Oracle Primavera Cloud Service - Version 20.9 to 20.12 [Release 20.9 to 20.12]
Information in this document applies to any platform.

Symptoms

When attempting to use Primavera Gateway to send P6 data to OPC, the following error occurs.

ERROR
-----------------------
Errors from Primavera Cloud
Calendar: 12345 -> 12345 update -> error
Message: Exception []: org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-12899: value too large for column "T_SEED_PRIMEAPP_ADM"."SYS_JOB_SETTING"."JOB_SETTING_VALUE" (actual: 14632, maximum: 4000)
ORA-06512: at line 1

Error Code: 12899
Call: BEGIN INSERT INTO SYS_JOB_SETTING (SYS_JOB_SETTING_ID, CREATE_ON_BEHALF_OF_USER, CREATE_USER, JOB_SETTING_NAME, JOB_SETTING_VALUE, UPDATE_ON_BEHALF_OF_USER, UPDATE_USER, SYS_JOB_ID, BLOB_REFERENCE_ID, CLOB_REFERENCE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING CREATE_TS, UPDATE_TS INTO ?, ?; END;
bind => [12 parameters bound]
Query: InsertObjectQuery(com.oracle.pgbu.model.entity.JobSettingEO)

Cause

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
Symptoms
Cause
Solution
References


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