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

Last updated on MARCH 09, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms