My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.