Project Arbiter Fails With ORA-01400: Cannot Insert NULL Into ("ADMUSER"."PLPROJREF"."PROJ_ID") (Doc ID 2212437.1)

Last updated on DECEMBER 20, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.0.0 to 16.1.2.0 [Release 16.1]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.1.0.0 to 16.1.2.0 [Release 16.1]
Information in this document applies to any platform.

Symptoms

The Project Arbiter fails with the following error, which can be found in the jt_projectarbiter failure log.

==========
TIMESTAMP:TASK:PxProjectArbiterServiceTaskImpl: [1] CORE(SQL): Executing:
px_arbiter_demand...
SEVERE: TIMESTAMP:TASK:PxProjectArbiterServiceTaskImpl: [1] CORE(SQL):
ORA-01400: cannot insert NULL into ("ADMUSER"."PLPROJREF"."PROJ_ID")
ORA-06512: at "ADMUSER.PX_ARBITER_DEMAND", line 185
ORA-06512: at line 1

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert
NULL into ("ADMUSER"."PLPROJREF"."PROJ_ID")
ORA-06512: at "ADMUSER.PX_ARBITER_DEMAND", line 185
ORA-06512: at line 1

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