ELM 9.2: Async Data Process (LM_LD_ASYNC) Error in SQL Server Database
(Doc ID 1962755.1)
Last updated on JULY 17, 2019
Applies to:PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
A new person is created in HRMS side, the messages PERSON_BASIC_SYNC and WORKFORCE_SYNC are done in both HRMS and ELM. But when running the process asynchronous data LM_LD_ASYNC process is failing in MSS DB with the following error
[SQL Server]Incorrect syntax near 'A'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not b Statement: UPDATE PS_LM_PRSADR_TMP1 A SET A.LM_PRIMARY = 'Y' WHERE EXISTS ( SELECT 'X' FROM PS_LM _CM_PURP_TYPE B , ( SELECT P.PROCESS_INSTANCE ,P.LM_HR_EMPLID , MIN( Q.LM_ORDER_BY_SEQ) AS LM_ORDER_ BY_SEQ FROM PS_LM_PRSADR_TMP1 P , PS_LM_CM_PURP_TYPE Q WHERE P.PROCESS_INSTANCE= :1 AND P.LM_CM_PURP _TYPE=Q.LM_CM_PURP_TYPE GROUP BY PROCESS_INSTANCE, P.LM_HR_EMPLID ) C WHERE A.PROCESS_INSTANCE= C.PR
Steps to Replicate:
1) Publish from HRMS, PERSON_BASIC_SYNC Incremental Sync From HRMS to ELM
2) Run Process Asynchronous Data ( AE LM_LD_ASYNC)
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