Resource Role Spread Publication Fails With Deadlock Error
(Doc ID 2363929.1)
Last updated on MARCH 16, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 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]:  PRE(SQL): Errors occurred when executing following statement: Delete RsrcRoleAsgnmentSpread where rolledup_record ='Y'
[TASK]:[PxRsrcRoleAssignmentSpread]:  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