My Oracle Support Banner

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

Last updated on MARCH 22, 2022

Applies to:

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


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




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

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