E-PIH: Theme Builder Error (Doc ID 2291305.1)

Last updated on AUGUST 04, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When using theme builder in Interaction Hub on an MSSQL server database , it gives SQL errors like below.

Return: 0 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'M1'.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.

[Microsoft][SQL Server Native Client 11.0][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.PTMACRONAME)) WHERE M1.PTMACROSETID = 'WLS_FLUID_THEME' AND PTMACRONAME NOT IN(SELECT PTMACRONAME FROM PS_EPPBR_MACROFLD MF2 WHERE EPPBR_INCLUDEFLD ='Y') AND PTMACRONAME IN (SELECT PTMACRONAME FROM PS_EPPBR_MACROFLD MF2 WHERE EPPBR_PTMACRODFLT <>' ')
 

ERROR
-----------------------

eturn: 0 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'M1'.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near Statement:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login to PIH and navigate to Portal administration > theme Builder

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use theme builder.

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