Slow Database Performance Due To Siebel Queries - SBL-DAT-00523: The selected record has been modified by another user since it was retrieved. Please continue
(Doc ID 2904256.1)
Last updated on OCTOBER 21, 2022
Applies to:
Siebel CRM - Version 16.19 [IP2016] and laterInformation in this document applies to any platform.
Symptoms
Customer has a custom auditing functionality that records Siebel session information, when the session is initiated a new record is created in a custom table created for that purpose, and when the session is closed the same record is updated.
DBA has observed a degraded database performance related to the update statement executed at the session close.
UPDATE SIEBEL.CX_SESSION SET
DB_LAST_UPD_SRC = :1,
DB_LAST_UPD = current_date,
LAST_UPD = :2,
LAST_UPD_BY = :3,
MODIFICATION_NUM = :4,
SESSION_END = :5
WHERE
ROW_ID = :6 AND MODIFICATION_NUM = :7
DB_LAST_UPD_SRC = :1,
DB_LAST_UPD = current_date,
LAST_UPD = :2,
LAST_UPD_BY = :3,
MODIFICATION_NUM = :4,
SESSION_END = :5
WHERE
ROW_ID = :6 AND MODIFICATION_NUM = :7
In the associated Siebel object manager log file the following error is observed upon the query execution:
ObjMgrBusCompLog Error 1 0000056b63465217:0 2022-10-12 13:13:42 (oracon.cpp (2899)) SBL-DAT-00523: The selected record has been modified by another user since it was retrieved. Please continue.
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 |