ELM 9.2: Async Data Process (LM_LD_ASYNC) Error in SQL Server Database (Doc ID 1962755.1)

Last updated on OCTOBER 03, 2016

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

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

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)

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