Update Baseline is Failing With "Prism.Modularity.ModuleInitializeException:...Cannot insert the value NULL into column 'seq_num', table 'PMDB.dbo.TASKPROC';" (Doc ID 2851104.1)

Last updated on FEBRUARY 23, 2022

Applies to:

Symptoms

When attempting to update an existing baseline, the following error is received in the log:

ERROR
-----------------------
Cannot insert the value NULL into column 'seq_num', table 'PMDB.dbo.TASKPROC'; column does not allow nulls. INSERT fails.

Prism.Modularity.ModuleInitializeException: An exception occurred while
initializing module 'CommandLineModule'.
    - The exception message was: One or more errors occurred.
    - The Assembly that the module was trying to be loaded from
was:Primavera.Mercury.CommandLineModule, Version=18.8.19.35820,
Culture=neutral, PublicKeyToken=null
    Check the InnerException property of the exception for more information.
If the exception occurred while creating an object in a DI container, you can
exception.GetRootException() to help locate the root cause of the problem.
   ---> System.AggregateException: One or more errors occurred. --->
System.Exception: Exception while commiting the changes to the database.
Cannot insert the value NULL into column 'seq_num', table
'PMDB.dbo.TASKPROC'; column does not allow nulls. INSERT fails.
The statement has been terminated. ---> System.Data.SqlClient.SqlException:
Cannot insert the value NULL into column 'seq_num', table
'PMDB.dbo.TASKPROC'; column does not allow nulls. INSERT fails.
The statement has been terminated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Attempt to update an existing baseline.
2. Observe the update fails with the reported error in the log.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update an existing baseline.

Changes

Cause

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