My Oracle Support Banner

Resource Role Spread Publication Fails With Deadlock Error (Doc ID 2363929.1)

Last updated on MARCH 01, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.9.0 and later
Information in this document applies to any platform.

Symptoms

When publishing Resource Role Spread data the following error occurs on a SQL Server database:

Transaction (Process ID XXX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

 This can also occur with an Oracle Database and shows the following variant of the error:

[TASK]:[PxRsrcRoleAssignmentSpread]: [2] PRE(SQL): Errors occurred when executing following statement: Delete RsrcRoleAsgnmentSpread where rolledup_record ='Y'   
[TASK]:[PxRsrcRoleAssignmentSpread]: [2] PRE(SQL): ORA-00060: deadlock detected while waiting for resource

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.