Tridion Error – Stored Procedure Deadlock
[alert]I use the Error Series to track the solution to common issues that are easy to forget. They are as much for my memory as public consumption.[/alert] Error: A database error occurred while executing Stored Procedure “EDA_PUB_TRAN_UPDATE _PUBLISH_TRANSACTION”. Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Cause: The number of deployer/publisher processes specified in the Tridion Snap-in exceeds the number of CPU cores. Solution: Update Publisher Settings, deployer and rendering threads to be less than or equal to the number of processors available.



