Error:"CVRJC-1032-3 - Cannot Insert the Value NULL Into Column 'Actv_code_id'" When Importing an XER File
(Doc ID 2119553.1)
Last updated on JUNE 21, 2023
Applies to:
Primavera P6 Professional Project Management - Version 15.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to import an XER file, the following error occurs.
EprmDBSQLExecutionFailurePRMDB-3656-A
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 1
The statement has been terminated.
SQL State: 2, SQL Error Code: 515, Level: 16, Procedure: , Line: 1
Cannot insert the value NULL into column 'actv_code_id',
table '<database name>.dbo.TASKACTV'; column does not allow nulls. INSERT fails.
The issue can be reproduced at will with the following steps:
- Launch P6 and login
- Click File > Import...
- Import the XER file
- Error message displays
Due to this issue, users cannot import the XER file.
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 |