E-SEC: PSLOCK Table Is Getting DeadLocked In SQL Server Database During Signin When There Is Heavy Load
(Doc ID 2777336.1)
Last updated on MAY 18, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
On SQL Server Database when there is heavy load, PSLOCK table is getting deadlocked. Due to this there are performance issues reported during login.
Below is the sample message being recorded in the APPSRV.log file during that time.
Return: 8602 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Transaction (Process ID 216) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
Statement: UPDATE PSLOCK SET VERSION = :1 WHERE OBJECTTYPENAME = 'UPM'
Original Statement: update pslock set version = :1 where objecttypename = 'UPM'
PeopleTools Version: 8.57.14
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