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 FEBRUARY 04, 2025
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 |