E-PORTAL: Theme Builder Page Throwing Error On SQL Server Database (Doc ID 2243090.1)

Last updated on MAY 10, 2017

Applies to:

PeopleSoft Enterprise PRTL Interaction Hub - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When using Theme Builder on Portal Interaction Hub on SQL Server database, getting below error

SQL error. Function: SQLExec
 Error Position: 0
 Return: 0 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'M1'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near
 Statement:
 Original Statement: UPDATE PS_EPPBR_AGMACRSTG M1 SET PTMACROCONTENT = (SELECT PTMACROCONTENT FROM PS_EPPBR_AGMACRSTG M2 WHERE M1.PTMACROSETID = M2.PTMACROSETID AND M2.PTMACRONAME = (SELECT EPPBR_PTMACRODFLT FROM PS_EPPBR_MACROFLD MF1 WHERE MF1.PTMACRONAME = M1.PTMA

Environment:
------------------
PT: 8.55.11

Application : Portal 9.1

 

Replication Steps:

------------------

Navigate to Main Menu -> Portal Administration -> Theme Builder -> Theme
Builder.

Create a new theme.

Upload a new image and click on Save.



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