My Oracle Support Banner

Update Baseline Fails with ORA-01400 after Adding or Deleting Activities in Baseline (Doc ID 2655153.1)

Last updated on APRIL 02, 2020

Applies to:

Primavera P6 Professional Project Management - Version 18.8 to 18.8.17.0 [Release 18.8]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.1 to 18.8.17.0 [Release 18.1 to 18.8]
Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to 18.8.17.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

When adding or deleting activities after a baseline was created and there's a UDF with a null value, update baseline fails with the following error:

 

ERROR

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.11.32708, 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.

ORA-01400: cannot insert NULL into ("ADMUSER"."TASKPRED"."TASK_ID") ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-01400: cannot insert NULL into ("ADMUSER"."TASKPRED"."TASK_ID")

at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)

at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, Boolean isFromEF)

at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()

at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)

 

STEPS TO REPRODUCE:

1. Open a project that has a baseline.

2. Go to Project --> Maintain Baseline.

3. Use the 'Update Baseline' function try to copy UDF data in Update to Baseline.

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.