Adding Cockpit with VARA.SQL as data source to dashboard in ECC fails with U0005118 and U0011801 errors.
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:
U0011801 Error in Server routine 'UCDVAR_R', Server: 'WS10#WP004' AE system: 'WS10'.
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.
OS Version: N/A
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
Workaround :
Use a VARA.STATIC and fill it in a script with the values from the VAR.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