Database event fails if SQL-VARA variable has output-format "number" and results in "U0011363 Type conversion" error
book
Article ID: 84777
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation EngineAUTOMIC WORKLOAD AUTOMATION
Issue/Introduction
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
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!"