"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.


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
  PRM DBAccess Error: Database Server Error: ORA-01400:
  cannot insert NULL into

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

  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)


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