My Oracle Support Banner

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.

Symptoms

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

 

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
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.