My Oracle Support Banner

E-FTP: HUNDREDS OF DEADLOCKS ON PSPTFILE_PRCS TABLE CAUSING PRODUCTION PERFORMANCE ISSUE. (Doc ID 1679917.1)

Last updated on AUGUST 10, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

 DESCRIPTION
===========
Performance issue on database due to deadlock issue caused due to Purge process.

Error we get is - PSAPPSRV.29229224 (6717) [01/06/14 13:00:06
C448197@172.22.98.10 (IE 8.0; WINXP) ICPanel](3) File:
/view/nbhuvana-16796323_poc-rno208104/vob/peopletools/src/pspcm/pcmeweb.cppSQL
 error. Stmt #: 18955  Error Position: 0  Return: 8601 - [IBM][CLI Driver][DB2] SQL0913N  Unsuccessful execution caused by deadlock or timeout.
Reason code "00C9008E".  SQLSTATE=57033
 (SQLSTATE 57033) -913
Failed SQL stmt:DELETE FROM PSPTFILE_PRCS WHERE (LASTUPDDTTM IS NULL OR  LASTUPDDTTM < :1)

REPLICATION STEPS
=================
Performance issue in production when many users are simultaneously doing file-processing operations, as a result triggering many DELETE SQL statements on the PSPTFILE_PRCS table causings contention and possible deadlocks on this table.

 

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.