Soap call error java.lang.NumberFormatException: For input string: "sid__"

Products

• CA Process Automation Base
• Process Automation Manager

Issue/Introduction

The following error occurs when running a SOAP operator:

<faultstring>java.lang.NumberFormatException: For input string: "sid__"</faultstring>

sid__ parameter is passed from a previous step with an integer value but for some reason, it seems PAM is passing this as string.

The result shows:
<soapenv:Fault xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>java.lang.NumberFormatException: For input string: "sid__"</faultstring>
<detail>
<ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">example_hostname</ns1:hostname>
</detail>
</soapenv:Fault>

STEPS to replicate:

1. Open SOAP UI and get loginID for Catalog:

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://services.soap.usm.ca.com">
  <soapenv:Header/>
  <soapenv:Body>
     <ser:logIn soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
        <userID xsi:type="xsd:string">example_userid</userID>
        <password xsi:type="xsd:string">example_password</password>
        <businessunit xsi:type="xsd:string">example_business_unit</businessunit>
     </ser:logIn>
  </soapenv:Body>
</soapenv:Envelope>

Copy the output (ie: <session id>)

2. Login to ITPAM and go to Library > CA SDM/GI Services/Processes > Double Click on Add Catalog attachments to SDM 

3. Click on the first process checkSLCMSession_ID and go to properties > Run Javascript > Click on Source code > Replace the Process.SLCM_SessionID__ value with the one from step 1 > Save changes

4. Run the process.  The issue occurs in the last operator named "Add_Attachment_"

 

Environment

Process Automation v4.4 and up
(The reported problem was not seen with previous versions of ITPAM)

Resolution

Follow these steps to resolve the problem

1. Select the SOAP operator "Add_Attachment_" which is failing and go to the Dynamic Parameters" pallet. It has an attribute called "Parameter style".

2. Change the Parameter style to "Macro Expansion." This change will allow PAM to replace the dynamic values as expected and address the reported issue. 

SID-Problem does no longer occur since changing to Macro Expansion