ELM 9.2: With Microsoft SQL Server Database, in App Server log files, Deadlock Errors on Tables LM_S4_TRACK_INT, LM_S4_INT_OBJ, and LM_S4_INT_RSPTN
(Doc ID 2667471.1)
Last updated on MAY 06, 2020
Applies to:
PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
With Microsoft SQL Server Database, in App Server log files, DEADLOCKS Errors on Tables LM_S4_TRACK_INT, LM_S4_INT_OBJ, and LM_S4_INT_RSPTN
Example of Error Message in App Server log file:
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL
Server]Transaction (Process ID 61) was deadlocked on lock | communication
buffer resources with another process and has been chosen as the deadlock
victim. Rerun the transaction. (SQLSTATE 40001) 1205
Statement: UPDATE PS_LM_S4_INT_RSPTN SET
LM_S4_SQ_SES_ID=:1,LM_S4_ORG_ID=:2,LM_S4_ACT_ID=:3,LM_S4_ATT_ID=:4,LM_S4_INT_I
D=:5,LM_S4_INT_PAT_ID=:6,LM_S4_INT_PATTERN=:7 WHERE LM_S4_SQ_SES_ID=:8 AND
LM_S4_ORG_ID=:9 AND LM_S4_ACT_ID=:10 AND LM_S4_ATT_ID=:11 AND
LM_S4_INT_ID=:12 AND LM_S4_INT_PAT_ID=:13
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |