"PRMDB-1341-E: ORA-01400: cannot insert NULL into ("ADMPRM$PM"."PROJCOST"."TASK_ID")" When Importing A XER File (Doc ID 1640306.1)

Last updated on APRIL 22, 2014

Applies to:

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

Symptoms

When a user tries to import an XER file to P6 professional, the following error occurs:

*****************************************************
*                EXCEPTION  REPORT                  *
*****************************************************
Date:          19-Mar-14

Executable:    PM.exe
Application:   Primavera P6 Project Management
Event Code:    PRMDB-1341-E
Message:       
  PRM DBAccess Error: Database Server Error: ORA-01400:
  cannot insert NULL into
  ("ADMPRM$PM"."PROJCOST"."TASK_ID")


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

Detail:
  Type:        EprmDBSQLExecutionFailure
  Object Type: TCUltraButton

Database Error:
   Error Code:     0


System Info
===========
Username: Administrator   Hostname: (unknown)
OS Version: Windows NT ver 5.2, build 3790, Service Pack 2 (Intel Pentium)

Cause

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