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.
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.
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!"
Update to a fix version listed below or a newer version if available.
Fix Status: Released
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