search cancel

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


Article ID: 87321


Updated On:


CA Automic Workload Automation - Automation Engine


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”


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 type:
By design
Root Cause: Spaces not allowed as part of numeric values in script variables.


OS Version: N/A


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.