My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2019

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.



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.