ERROR: Cannot Insert The Value NULL Into Column 'Clndr_Name' Table When Importing XER File Into P6 Client

(Doc ID 2260544.1)

Last updated on JUNE 09, 2017

Applies to:

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


When attempting to import an XER file into P6 Client the following error occurs:

Type: EprmDBSQLExecutionFailure
Event Code: PRMDB-2021-5
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 '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:

  1. Log into P6 Client.
  2. Import XER file.
  3. 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms