My Oracle Support Banner

ELM: After Upgrade to ELM Image #23 Using MS SQL Server, Conversion Application Engine EONC_AWE_CON Fails with SQL Error (Doc ID 2978809.1)

Last updated on NOVEMBER 06, 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



When upgrading to PUM #23 using MS SQL Server, conversion application engine EONC_AWE_CON in Step MAIN.STEP01 fails with SQL Error.

ERROR MESSAGE:

 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'A'.

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'AND'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: DELETE FROM PS_EONC_NOTFY_HDR A WHERE A.EONC_NOTIF_NAME IN ( (200,0)
Process XXXXX ABENDED at Step EONC_AWE_CON.MAIN.Step01 (SQL) -- RC = 8601 (108,524)



The issue can be reproduced at will with the following steps:

1. In Change Assistant, apply update package for ELM 9.2 PUM #23
2. Process AE EONC_AWE_CON fails in MAIN.Step01 (SQL), receives SQL error
 


Changes

 

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
Changes
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.