My Oracle Support Banner

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 later
Information 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:

  1. Launch P6 and login
  2. Click File > Import...
  3. Import the XER file
  4. 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


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