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

Products

• CA Automic Workload Automation - Automation Engine

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.
 

Environment

OS Version: N/A

Cause

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

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.