Variable in the process tab of a Workflow with ":PSET &param# = ' '" will be saved as an empty string when using Oracle

book

Article ID: 87792

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
N/A

Setting a variable in the process tab of a Workflow when using an Oracle database with the following string: 
 
:PSET &param# = ' '

results in the following outcome.

Actual
The variable will be saved as an empty string '' in the task of the Workflow.

Expected
The variable result should be a blank and not an emtpy string.

 

Cause

Cause type:
Defect
Root Cause: A value of a variable consisting of several blanks will be saved as an empty string when using an Oracle database.

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution

Update to a fix version listed below.

Fix Status: Released

Fix Version(s):
Automation Engine 12.0 - Available
Automation Engine 11.2.3 - Available
Automation Engine 11.1.5 - Available

Additional Information

Workaround :
N/A