ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Database event fails if SQL-VARA variable has output-format "number" and results in "U0011363 Type conversion" error
Article ID: 84777
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.
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.
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!"
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:
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
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
N/A
Attachments
Feedback
Yes
No
Powered by
