My Oracle Support Banner

Error: "Event Code PRMDB-1807-9 Cannot insert the value NULL into column 'clndr_name'" When Importing Microsoft Project MPP Or XML File (Doc ID 901435.1)

Last updated on JUNE 07, 2021

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.3.2.0 and later
All Platforms

Symptoms

The following error occurs when importing a Microsoft Project MPP file into P6t:

*****************************************************
*                EXCEPTION  REPORT                  *
*****************************************************
Date:          10-Jul-06 10 AM
Executable:    PM.exe
Application:   Primavera Project Management
Event Code:    PRMDB-1807-9
Message:      

  PRM DBAccess Error: SQL Server Error: The statement
  has been terminated.
  Cannot insert the value NULL into column 'clndr_name',
  table 'PMDB.dbo.CALENDAR'; column does not allow nulls.
  INSERT fails.

Context:
  1: TfrmWizImport.RunImportWizard
  2: TfrmMain.actFileImportExecute
  3: TfrmMain.actFileImportExecute
  4: TfrmMain.actFileImportExecute
  5: TfrmMain.actProjectsExecute
  6: TCFormManager.SetToolbar
  7:
  8:
  9:
  10:

Detail:
  Type:        EprmDBSQLExecutionFailure
  Object Type: TCUltraButton

Database Error:
   Error Code:     0

 

The following error occurs when importing a Microsoft Project XML file:

SEVERE: Field Name on Calendar may not be zero length.
com.primavera.integration.client.xml.xmlimporter.d.c: Field Name on Calendar may not be zero length.

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.