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 DECEMBER 04, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
When attempting to reassign Responsible Manager (OBS) to Project, the following error occurs:
Event Code: PRMDB-1442-F
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.
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.
The issue has the following business impact:
Due to this issue, users cannot reassign the Responsible Manager to Project.
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