Error: "Cannot insert the value NULL into column '{COLUMN}', table '{DATABASE}.{SCHEMA}.OBSPROJ'; column does not allow nulls. INSERT fails" And "Primavera P6 has stopped working and needs to close" (Doc ID 910761.1)

Last updated on DECEMBER 02, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.1 and later
Primavera P6 Professional Project Management - Version 8.2 1.0 and later
All Platforms

Symptoms

When attempting to login to the P6 Client application, the following error occurs:

ERROR
-------------------

Primavera has stopped working and needs to close - Faulting application name: PM.exe
Error signature App name: pm.exe offset: 0043bfbf'
Exception EAccessViolation in module PM.exe at 0043BFBF. Access violation at address 0083BFBF in module 'PM.exe'. Read of address 00000381.
OR
Primavera P6 has stopped working. APPCRASH PM.exe Fault Module Version: 8.2.1.3763.
Followed by the following, when we press "Close program:"
'Exception EAccessViolation in module PM.exe at 0043C557. Access violation at address 0083C557 in module 'PM.exe'. Read of address 00000381.

            OR

            Primavera P6 Professional has stopped working. Windows will now close the Program.

   OR

   Primavera P6 Professional R8.2 has encountered a problem and needs to close. We are sorry for the inconvenience.
   If you were in the middle of something, the information you were working on might be lost.

   OR

   Primavera P6 Professional has stopped working.  A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available. (close program)".

 

When attempting to resolve this error by running the background job manually, the following secondary error is reported:

ERROR
-------------------

Cannot insert the value NULL into column 'wbs_id', table '<DATABASE>.<SCHEMA>.OBSPROJ'; column does not allow nulls. INSERT fails.

OR

Cannot insert the value NULL into column 'obs_id', table '<DATABASE>.<SCHEMA>.OBSPROJ'; column does not allow nulls. INSERT fails.

 

This error with the background jobs can also occur independently of the login crash.

Changes

 

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