Publish Audit Data Service Fails with Error ORA-12899 (Doc ID 2123716.1)

Last updated on APRIL 11, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

The Global Scheduled Service, 'Publish Audit Data' fails with an error similar to the following.

016-03-20 23:00:58:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): Executing: px_audit_demand...
2016-03-20 23:00:58:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): ORA-12899: value too large for column "ADMUSER"."PRMAUDITX"."OLD_VALUE" (actual: 256, maximum: 255) ORA-06512: at "ADMUSER.PX_AUDIT_DEMAND", line 148 ORA-06512: at line 1
2016-03-20 23:00:58:[SERVICE]:[PxService]: Job End Time: 2016-03-20 23:00:58
2016-03-20 23:00:58:[SERVICE]:[PxService]: Job Elapsed Time: 00:00:00.178
2016-03-20 23:00:58:[SERVICE]:[PxService]: Job Status: Failed
2016-03-20 23:00:58:[SERVICE]:[PxService]: END: Px Service Job

 

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