E-EOPC:Fatal PeopleCode SQL error occurred in SQL Server; Incorrect syntax near 'S With Drag and Drop Functionality

(Doc ID 2224055.1)

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

Symptoms

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.




STEPS
-----------------------

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.


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