E-EOPC:Fatal PeopleCode SQL error occurred in SQL Server; Incorrect syntax near 'S With Drag and Drop Functionality
Last updated on NOVEMBER 08, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Microsoft Windows x64 (64-bit) - Version: 2008 R2
On : 8.55 version, Page Composer
Page Composer - Fatal PeopleCode SQL error occurred in sql server as SQL Server does not support aliases on Delete statements.
The replication steps are not clear. However upon checking the peoplecode of EOPC_MAIN.mainData.dataCleanUp, I can see the following.
SQLExec("DELETE FROM PS_EOPCFIELD_STYLE S WHERE NOT EXISTS (SELECT 'X' FROM PS_EOPC_FIELD F WHERE F.EOPCMAIN_ID = S.EOPCMAIN_ID AND F.EOPCFORMAT_ID = S.EOPCFORMAT_ID AND F.EOPCFIELD_ID = S.EOPCFIELD_ID)");
This statement is not allowed in SQL server.
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