My Oracle Support Banner

Update Baseline Results In Error 'The DELETE Statement Conflicted With The REFERENCE Constraint "fk_task_calendar".' (Doc ID 2925595.1)

Last updated on FEBRUARY 06, 2023

Applies to:

Primavera P6 Professional Project Management - Version 20.12.2.0 and later
Information in this document applies to any platform.

Symptoms

DESCRIPTION

When attempting to update baselines, user receives an error.

ERROR

From P6 WebAccess log:
Prism.Modularity.ModuleTypeLoadingException: Failed to load type for module CommandLineModule.
Error was: 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=X.X.X.X, 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.
  . ---> 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=X.X.X.X, 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.
The DELETE statement conflicted with the REFERENCE constraint "fk_task_calendar". The conflict occurred in database "XXXX", table "dbo.TASK", column 'clndr_id'.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "fk_task_calendar". The conflict occurred in database "XXXX", table "dbo.TASK", column 'clndr_id'.
The statement has been terminated.
 
STEPS TO REPRODUCE

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

  1. Login to P6 Pro.
  2. Open a Project.
  3. Go to Project > Maintain Baselines.
  4. Highlight the baseline to be updated.
  5. Click Update.
  6. Click Update.
  7. Receive error.



Changes

 

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
Changes
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.