ELM 9.2: LM_LD_ASYNC Process Takes Too Long To Complete For Large Data Sets, Gets Stuck At Step LM_LD_WKFC.SYNC_DT.UPD (SQL)
(Doc ID 2974174.1)
Last updated on SEPTEMBER 19, 2023
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
The LM_LD_ASYNC processs is experiencing performance issues when running for larger data sets.
The issue can be reproduced at will with the following steps:
1. Run the LM_LD_ASYNC process from navigation: Set Up ELM > Process Asynchronous Data
2. Process will run for a long time without completing, getting stuck at step LM_LD_WKFC.SYNC_DT.UPD (SQL)
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 |
Cause |
Solution |
References |