Datasets and Special Characters

Products

• CA Process Automation Base

Issue/Introduction

The passwords stored in a IT Process Automation (ITPAM) dataset include special characters.

When passing them as parameters to the Run Script operator, an error occurs.

Outside of ITPAM (using PowerShell script), the special characters are accepted and the execution is successful

Environment

IT Process Automation 4.4

All Supported Operating Systems

Cause

When a ITPAM process passes the special characters as parameters (which are enclosed in double quotes) to the script, ITPAM removes the enclosed quotes and passes the actual value.

Because the special characters are coming directly, the script is failing. 

ITPAM is using a proprietary exe (c2ojagtw.exe) to handle all kinds of script operations. 

Resolution

Solution is to enclose the special character password in single quotes first followed by double quotes. 

For example

From 

Process.x="{(P&ssw0rd!";

To:

Process.x="'{(P&ssw0rd!'";