Error when using Project Architect to update an existing project: "Cannot insert the value NULL into column 'task_id', table <DB NAME>.DBO.TSKPRED; column does not allow nulls. INSERT fails (Doc ID 912004.1)

Last updated on MAY 28, 2014

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.1 and later
All Platforms
***Checked for relevance on 12-DEC-2012***


Symptoms

SQL Server 2005 Database Error when using Project Architect to update an existing project: "Cannot insert the value NULL into column 'task_id', table <DB NAME>.DBO.TSKPRED; column does not allow nulls. INSERT fails

When running Project Architect to update an existing project with a base methodology, and the methodology has activities linked together with ACTV Relationships, the import fails with the following message:

Cannot insert the value NULL into column 'task_id', table <DB NAME>.DBO.TASKPRED; column does not allow nulls. INSERT fails.

*****************************************************
*                EXCEPTION  REPORT                  *
*****************************************************
Date:          23-Feb-09 12:06 PM

 

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

Context:
  1: TfrmEPS.mnuOpenProjectClick
  2: TfrmMain.actProjectsExecute
  3: TCProjectArchitectVDBEngine.LoadParentRows
  4: TCProjectArchitectVDBEngine.LoadParentRows
  5: TCProjectArchitectVDBEngine.LoadParentRows
  6: TCProjectArchitectVDBEngine.LoadParentRows
  7: TCProjectArchitectVDBEngine.LoadParentRows
  8:
  9:
  10:

Detail:
  Type:        EprmDBSQLExecutionFailure
  Object Type: TPopupList

Database Error:
   Error Code:     0

Components
==========
ORI: ORI Win32 #
ORI/DB: PMDB,0602.0005.0001.0001
IMG: IMG Win32 #1000

System Info
===========
Username:    Hostname:

OS Version: Windows NT ver 5.1, build 2600, Service Pack 3 (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