E-FTP: HUNDREDS OF DEADLOCKS ON PSPTFILE_PRCS TABLE CAUSING PRODUCTION PERFORMANCE ISSUE.
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.
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:
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)
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.
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