OLM - The Current Row Is Locked (Doc ID 1317328.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Learning Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version,
 
The following error message occurs when closing down courses that have been playing. The issue is that some courses can take 2 hours plus to complete. When the customer hits the home icon button they may get the error message informing them that the row is locked.


ERROR
-----------------------
java.sql.SQLException : ORA-20001:the current row is locked Cause:You are trying to lock a row in the ota_events table which is currently being locked by another user. Action Re-query and attempt to lock the row again.
ORA-06512 at 'APPS.OTA_DELEGATE_BBOOKING_API' line 2507
ORA-06512 at "APPS.OTA_TDB_API_UPD2"....


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. OLM Administration
  2. Learning Administration
  3. Enroll on course
  4. Play course
  5. complete course
  6. hit the home icon button to close the course.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
can have over a million users playing courses during the day and the although the instance of two users playing and completing the same course at the same time is not very high we still have had a handful of calls with this error message.

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