SQL Server Deadlock When Submitting Concurrent Training Enrollment Request
(Doc ID 2106315.1)
Last updated on SEPTEMBER 04, 2020
Applies to:PeopleSoft Enterprise HCM eDevelopment - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Two Employees are Enrolling in the same Training Course and Session, both users select Submit at the same Time, and one Users' Request is Submitted and the Other User Receives an Error
Steps to Replicate
1. Sign in using SQL Database and PS/PS
2. Navigate Self Service > Learning & Development > Training Enrollment
3. Two Users select the same Training course and Training Session
4. Submit the request at the same time
SQL error Exec. (2,280) FUNCLIB_HR_SS.HR_SS_CONFIG_FUNC Field Formula
Name: BatchRequestPerFolk PCPC 168335 Statement 1
Called from FUNCLIB_HR_SS.HR_SS_CONFIG_FUNC.FieldFormula Name RunSSWorkflow
Called from HR_SS_ACTIVATE.HR_SS_ACTIVATE.Workflow Statement 6
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
See App Server Log file: Shows deadlock error
Error Position: 0
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction (Process ID 66) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
Statement: UPDATE PSWORKLIST SET TRANSACTIONID = :1 WHERE BUSPROCNAME = :2 AND ACTIVITYNAME = :3 AND EVENTNAME = :4 AND WORKLISTNAME = :5 AND TRANSACTIONID >= :6 AND TRANSACTIONID <= :7
Original Statement: UPDATE PSWORKLIST SET TRANSACTIONID = :1 WHERE BUSPROCNAME = :2 AND ACTIVITYNAME = :3 AND EVENTNAME = :4 AND WORKLISTNAME = :5 AND TRANSACTIONID >= :6 AND TRANSACTIONID <= :7
PSAPPSRV.2884 (49) [2016-01-27T07:58:08.452 KELLWALT@kelleherwalter1.fsba.loc (IE 10.0; WIN7) ICPanel](0) SQL error in Exec. (2,280) FUNCLIB_HR_SS.HR_SS_CONFIG_FUNC.FieldFormula Name:BatchRequestsPerFolk PCPC:168335 Statement:2451
Expected Behavior: both users should be able to submit their training requests without error
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