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 Engine

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>

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.
 

<Please see attached file for image>

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!"

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

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

Attachments

1558704706029000084777_sktwi1f5rjvs16loi.png get_app
1558704703964000084777_sktwi1f5rjvs16loh.png get_app