ERROR: Cannot Insert The Value NULL Into Column 'Clndr_Name' Table When Importing XER File Into P6 Client
Last updated on JUNE 09, 2017
Applies to:Primavera P6 Professional Project Management - Version 184.108.40.206 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 220.127.116.11 and later
Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
When attempting to import an XER file into P6 Client the following error occurs:
Event Code: PRMDB-2021-5
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0,
The statement has been terminated.
SQL State: 2, SQL Error Code: 515, Level: 16, Procedure: ,Line:1
Cannot insert the value NULL into column 'clndr_name', table
'PMDB.dbo.CALENDAR'; column does not allow nulls. INSERT fails.
Can also generate the following message:
PRM DBAccess Error: ORA-01400: cannot insert NULL into
The issue can be reproduced at will with the following steps:
- Log into P6 Client.
- Import XER file.
- Notice the import does not complete and the error pops up.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms