Database event fails if SQL-VARA variable has output-format "number" and results in "U0011363 Type conversion" error
Error Message :
U00011363 Type conversion between Value 1('Number') and Value 2('Number') is not supported!
A DB-Event that contains an SQL-VARA is executed regularly and compares the result to a static value, see image below. The VARA WH.PNR.VARA.STA.NEW.1 is shown in the top windows and is compared in the Event WH.PNR.DB.STA.NEW.1 to a static value.
<Please see attached file for image>
The "!Process" is never executed, though the SQL-VARA gives the correct values when "Preview" is clicked. Instead, the compare delivers an error message that can only be seen when you display the details in the activities list.
<Please see attached file for image>
Cause type:
Defect
Root Cause: Database event does not work, if used sql-variable variable has output-format "number" and results in error: "U0011363 Type conversion between Value 1('Number') and Value 2('Number') is not supported!"
Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s):
Automation Engine 11.2.2 - Available
Automation Engine 11.1.3 - Available
Automation Engine 10.0.8 - Available
Automation Engine 9.13.0 SP12 - Available
Workaround :
N/A