SQL Server Deadlock When Submitting Concurrent Training Enrollment Request (Doc ID 2106315.1)

Last updated on FEBRUARY 12, 2016

Applies to:

PeopleSoft Enterprise HCM eDevelopment - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

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

Error:

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
Statement2569
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

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