ELM 9.2:LM_LD_ASYNC Process Fails Frequently with the Error Messages: "ORA-00001: unique constraint (SYSADM.PS_LM_STG_PRS_NM) violated" or "ORA-00001: unique constraint Failed SQL stmt"
(Doc ID 2975984.1)
Last updated on SEPTEMBER 26, 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.
When attempting to run LM_LD_ASYNC process it fails with one of the following error messages:
Steps to reproduce the issue:
1. Navigate to Set Up ELM > Process Asynchronous Data > Process Asynchronous Data.
2. Run the process.
3. Check the status of the process by clicking the Process Monitor hyperlink.
4. Notice that the process fails and in the log files one of the error message is seen.
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