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

Document ID : KB000085028
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

0EMb0000001QxBW.png

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'.
Environment:
OS Version: N/A
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.
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