"INSERT statement conflicted with the FOREIGN KEY constraint "fk_projwbs_project". The conflict occurred in database "PMDB", table "dbo.PROJECT", column 'proj_id'." When Importing Primavera Risk Analysis XER File into P6 Running on SQL Server (Doc ID 2186368.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

When attempting to import an XER file created in Primavera Risk Analysis into P6 the following error occurs,

ERROR
-----------------------
Event Code: PRMDB-0219-2
Message:
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621,
Level: 0, Procedure: , Line: 1
The statement has been terminated.
SQL State: 14, SQL Error Code: 8152, Level: 16,
Procedure: , Line: 1
String or binary data would be truncated.

Followed by:
Event Code: PRMDB-2982-C
Message:
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621,
Level: 0, Procedure: , Line: 1
The statement has been terminated.
SQL State: 1, SQL Error Code: 547, Level: 16, Procedure: ,
Line: 1
The INSERT statement conflicted with the FOREIGN KEY
constraint "fk_projwbs_project". The conflict occurred in
database "MikedSQL", table "dbo.PROJECT", column
'proj_id'.

STEPS
-----------------------
1. Open P6 professional > Select the Risk analysis File > Import.
2. Upon import of file > File results in Error.
3. An application event has been intercepted please not the event code for reference
  Event code PRDMB-0219-2.

Changes

 

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