Database event fails if SQL-VARA variable has output-format "number" and results in "U0011363 Type conversion" error

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

0EMb0000001UNB5.png

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.
 
0EMb0000001UNBA.png
Cause:
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!"
Resolution:
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
Additional Information:
Workaround :
N/A