E-WF/SQL:Deadlocks on PSWORKLIST When Doing Voucher Approval (Doc ID 2043767.1)

Last updated on MAY 09, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

There are tens of users approving vouchers at the same time. They got the following error.

PSAPPSRV.11052 (6) [2015-05-08T10:22:31.898 JLAI@172.16.8.179 (IE 8.0; WIN7) ICPanel](3) File: E:\pt85313c-retail\peopletools\src\pspcm\pcmobuf.cppSQL error. Stmt #: 4757  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
Failed SQL stmt: SELECT BUSPROCNAME,ACTIVITYNAME,EVENTNAME,WORKLISTNAME,INSTANCEID,TRANSACTIONID,ACTIONDTTM,OPRID,ORIGINATORTYPE,ORIGINATORID,INSTSTATUS,INSTAVAILABLEDTTM,INSTSELECTEDDTTM,INSTWORKEDDTTM,INSTTIMEOUTDTTM,TIMEDOUT,PREVOPRID,COMMENTSHORT,WLDAYSTOSELECT,WLDAYSTOWORK,URL,DO_REPLICATE_FLAG,SYNCID,LASTUPDDTTM,WL_PRIORITY,DESCR254_MIXED FROM PSWORKLIST WHERE BUSPROCNAME=:1 AND ACTIVITYNAME=:2 AND EVENTNAME=:3 AND WORKLISTNAME=:4 AND INSTANCEID=:5
PSAPPSRV.11052 (6) [2015-05-08T10:22:32.991 JLAI@172.16.8.179 (IE 8.0; WIN7) ICPanel](0) An error occurred while taking action on the voucher.   The following error occurred when calling DoApprove():   Fatal SQL error occurred. (2,125) PT_WF_WORKLIST.WorklistEntry.OnExecute  Name:SelectByKey  PCPC:651  Statement:12

Called from:EOAW_CORE.WorklistManager.OnExecute  Name:GetWLEntry  Statement:151

Called from:EOAW_CORE.NotificationEventHandler.OnExecute  Name:ManageWorklist  Statement:1631

Called from:EOAW_CORE.NotificationEventHandler.OnExecute  Name:ProcessNotifications  Statement:1488

 

Replication:

1. Tens of users approve vouchers at the same time.

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