SOAP calls to SDM is failing after upgrade from 4.3.5 to 4.4 CP03

Products

• CA Process Automation Base

Issue/Introduction

A soap call that worked in ITPAM version 4.3.5 is failing under release 4.4 CP03.  The whereclause contains the following SQL operators: Process.sdm_q_where = "name = '" + "<![CDATA[" + Process.locName_in + "]]>" + "'";  

 

Environment

Release: 4.4 GA -->CP03

Components: ITPAM

 

Cause

Regression issue in CP03. Error message: SoapClientCallServiceOperation failed to execute

Resolution

Workaround:

If the CDATA code removed from the whereclause the SOAP calls to SDM works.

Please change the code from:   Process.sdm_q_where = "name = '" + "<![CDATA[" + Process.locName_in + "]]>" + "'";

To: Process.sdm_q_where = "name = '" + Process.locName_in + "'";

The whereclause could contain special characters that require the CDATA code to be used and for that reason, the fix will be provided with the next CP release.