Error: "PRMDB-XXXX-X: Cannot Insert The Value NULL Into Column 'wbs_short_name'" When Importing Microsoft Project MPP File Into P6 (Doc ID 907209.1)

Last updated on JULY 05, 2016

Applies to:

Primavera Contractor - Version 4.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 3.5 and later
All Platforms
***Checked for relevance on 02-Jun-2011***


Symptoms

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

*****************************************************
*                EXCEPTION  REPORT                  *
*****************************************************

Executable:    PM.exe
Application:   Primavera Project Management
Event Code:    PRMDB-XXXX-X
Message:      
  PRM DBAccess Error: Database Server Error: The
  statement has been terminated.
  Cannot insert the value NULL into column
  'wbs_short_name', table 'PMDB.dbo.PROJWBS';
  column does not allow nulls. INSERT fails.

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

Detail:
  Type:        EprmDBSQLExecutionFailure
  Object Type: TCUltraButton

Database Error:
   Error Code:     0

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