System Error when trying to save a process script on Oracle database.

Products

• Clarity PPM On Premise

Issue/Introduction

You are getting a system error immediately when trying to save a custom script in the process.

Steps to Reproduce:
Pre-requisites: Make sure your environment is on Oracle database.

1. Login to Classic as Administrator.
2. Navigate to Administration->Process and create new process.
3. Under Start step attempt to create Custom Script action.
4. Paste below sample script:
<gel:script xmlns:bpm="jelly:com.niku.bpm.gel.BPMTagLibrary" xmlns:core="jelly:core" xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"
  xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
  xmlns:soapEnv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sql="jelly:sql" xmlns:xog="http://www.niku.com/xog"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <sql:query dataSource="${clarityDB}" escapeText="0"
      var="InstanceQuery"><![CDATA[
SELECT 
INV.ID INV_ID,
INV.CODE INV_CODE,
INV.NAME INV_NAME ,
TO_CLOB(CASE WHEN INV.NAME IS NULL THEN 'Some title here.' ELSE INV.NAME  END) 
VALIDATION_MESSAGE
FROM INV_INVESTMENTS INV 
INNER JOIN ODF_CA_IDEA IDEA ON INV.ID = IDEA.ID
WHERE INV.ODF_OBJECT_CODE='idea'
AND INV.ID = ?
]]><sql:param value="${gel_objectInstanceId}"/>
  </sql:query>
</gel:script>
5. Click Validate or Save you get an error "Unable to communicate to the PPM server. Please try again and if problem persists contact your system administrator." and script will not save.
 
Expected Results: It should allow to save the script.

Actual Results: It does not allow to save the script.

Environment

Clarity 16.3.3

Cause

DE176667

Resolution

Will not Fix.

Engineering team suggested to re-write the query and the string to avoid is (CASE WHEN