When using :SET in a script statement spaces included in numeric values will cause a Non numeric error

book

Article ID: 87321

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
U00020440 Runtime error in object 'SCRI.FORMAT.TDA', line '00002': Non numeric input '0000000050' not allowed.

As of Automation Engine V11.2 and above, spaces are not allowed in numeric strings.  

Example Script:  
 
:SET &TEST#=’  0000000050’
:IF FORMAT(&TEST#, “0”)= 50
:P “valid”
:ENDIF

 
Results

In v10 this script will result in the output “valid” within the report.

In v11.2 and above you will receive the non-numeric input error message.
 

Cause

Cause type:
By design
Root Cause: Spaces not allowed as part of numeric values in script variables.

Environment

OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available where a new table has been added to the installation description - incompatibilities.

Fix Status: Released

Fix Version(s):
Automation Engine 11.2.3 – Available

Additional Information

Workaround :
Prior to upgrading to V11.2 and above, it is recommended that you review any :SET script statements and remove any spaces in numeric strings to avoid the error.   This information has been documented in the list of incompatibilities for AE v11.2 in the fix version referenced in the resolution section.