My Oracle Support Banner

P6 Professional Crashes When Dragging and Dropping a Project Between EPS Nodes (Doc ID 2220166.1)

Last updated on MARCH 22, 2022

Applies to:

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

Symptoms

In P6 Professional, when moving a project from one EPS node to another via drag and drop, the following error is returned:

The issue may only occur with 1 project or 1 particular EPS.

ERROR


*****************************************************
* EXCEPTION REPORT *
*****************************************************
Executable: PM.exe
Application: Primavera P6 Professional R15.2
Event Code: PRMDB-1547-3
Message:
  PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: ,
  Line: 1
  The statement has been terminated.
  SQL State: 2, SQL Error Code: 515, Level: 16, Procedure: TR_PROJWBS_OBSPROJ,
  Line: 136
  Cannot insert the value NULL into column 'wbs_id', table 'PMDB.dbo.OBSPROJ';
  column does not allow nulls. INSERT fails.

Context:
  1: TCFormManager.SetToolbar
  2: TDevxMainForm.BeforeFormShow
  3: TfrmLogin.FormCreate
 
Detail:
  Type: EprmDBSQLExecutionFailure
  Object Type: TCVirtualQueryGrid

Steps to re-produce:

1.  Log into P6 Professional
2.  Enterprise - Projects
3.  Drag a project from one EPS node to a different EPS node.

4.  Observe the reported error.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.