My Oracle Support Banner

Reassigning Resonsible Manager (OBS) Brings Up Error: "PRMDB-1442-F. Cannot insert the value NULL into column 'wbs_id', table 'dbo.OBSPROJ'; column does not allow nulls. INSERT fails." (Doc ID 2523681.1)

Last updated on JULY 30, 2019

Applies to:

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

Symptoms

When attempting to reassign Responsible Manager (OBS) to Project, the following error occurs:

ERROR:

Event Code: PRMDB-1442-F
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: 151
 Cannot insert the value NULL into column 'wbs_id', table
 'N3B_5YR_FCPB.dbo.OBSPROJ'; column does not allow
 nulls. INSERT fails.


STEPS:

The issue can be reproduced at will with the following steps:
1. Log on Professional.
2. Reassign the responsible manager to a project. Above error pops up.

BUSINESS IMPACT:

The issue has the following business impact:
Due to this issue, users cannot reassign the Responsible Manager to Project.

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.