Adding Cockpit with VARA.SQL as data source to dashboard in ECC fails with U0005118 and U0011801 errors.

Products

• CA Automic Workload Automation - Automation Engine
• AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
U0005118 Program error: Database access via key 'EH_AH_Idnr' with value 0 in module 'UCDVAR_R'.
U0011801 Error in Server routine 'UCDVAR_R', Server: 'WS10#W04' AE system: 'WS10'.

Two cockpit objects are created and added to a dash board in the Enterprise Control Center (ECC). Both contain a bar element. One of them has a VARA.SQL as a data source, and the other a VARA.SQLI.

<Please see attached file for image>

Adding them to an ECC dash board, only the cockpit with the VARA.SQLI works. When trying to add the cockpit object with the VARA.SQL, the following errors are displayed: 
 

U0005118 Program error: Database access via key 'EH_AH_Idnr' with value 0 in module 'UCDVAR_R'.
U0011801 Error in Server routine 'UCDVAR_R', Server: 'WS10#WP004' AE system: 'WS10'.

Cause

Cause type:
Defect
Root Cause: The Cockpit Monitor is not able to load when using VARA.SQL as the data source but is added to a widget on the AWI Dashboard. In this case, there was also an error shown in the Message Window.

Environment

OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.1.0 - Available
Automation Engine 12.0.1 - Available
Automation Engine 11.2.4 - Available
Automation Engine 11.1.4 - Available

Additional Information

Workaround :
Use a VARA.STATIC and fill it in a script with the values from the VAR.SQL:
 

:SET &HND# = PREP_PROCESS_VAR(VARA.SQL)
:SET &COUNT# = 0

:PROCESS &HND#
: SET &LINE#=GET_PROCESS_LINE(&HND#, 1)
: SET &LINE2#=GET_PROCESS_LINE(&HND#, 2)
: SET &COUNT# = &COUNT# + 1
: PUT_VAR "VARA.STATIC", &COUNT#, &LINE#, &LINE2#
:ENDPROCESS