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

Document ID : KB000087321
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.