Error: U00005118 Program error: Database access via key 'EH_EventId' with value 0 in module 'JPEXEC_R'.
search cancel

Error: U00005118 Program error: Database access via key 'EH_EventId' with value 0 in module 'JPEXEC_R'.

book

Article ID: 450582

calendar_today

Updated On:

Products

Automic SaaS Automic Automation

Issue/Introduction

The PWP generates Forced Traces during a period with network interruptions.

This is what the PWP trace displays:

20260730/031748.754 -  JPEXEC_R              RCV  QUITT    frm AUTOMIC#CP001                            MQ2CP001 MsgID: 0006174035 c-acv: 00AE5EA8
20260730/031748.755 -    STRT UCUMIGR        OPC: 00002
20260730/031748.755 -    EXIT UCUMIGR        RET: 0000000000  TIME: 0000,00000  RETTEXT=' '
20260730/031748.755 - U00009909 TRACE: (BINDPAR:  EH_EventId         0x7fe107eb54e4 00004
                                00000000  00000000                             >....<
20260730/031748.755 -                                         >0<
20260730/031748.755 -  SELECT * FROM EH WHERE EH_AH_Idnr in (SELECT EH_AH_Idnr FROM EH WHERE EH_Eventid = ?) FOR UPDATE
20260730/031748.756 -  UCUDB32 SLCU RET 0000 HSTMT: 0x00000006ddcbc0 VALUE: 0x00000006ddcbc0 ALL:  0.00155 DB:  0.00146 ODBC:  0.00000 UDB:  0.00009
20260730/031748.756 -  UCUDB32 READ RET 0001 HSTMT: 0x00000006ddcbc0 VALUE:            (nil) ALL:  0.00001 DB:  0.00000 ODBC:  0.00000 UDB:  0.00001
20260730/031748.756 -  UCUDB32 CLST RET 0000 HSTMT: 0x00000006ddcbc0 VALUE:            (nil) ALL:  0.00001 DB:  0.00000 ODBC:  0.00000 UDB:  0.00001
20260730/031748.756 -  U00003620 Routine 'JPEXEC_R' forces trace because of error.
20260730/031748.756 -  U00005118 Program error: Database access via key 'EH_EventId' with value 0 in module 'JPEXEC_R'.

MVS Agents show this kind of messages:

20260730/050314.585 - U02000385 FT '&02': Web socket error: 'Connection reset'.
20260730/050314.585 - U00045014 Exception 'java.net.SocketException: "Connection reset"' at 'sun.nio.ch.SocketChannelImpl.throwConnectionReset():402'.
20260730/050314.596 - U02000196 Next attempt to create a CP connection in '10' seconds.

Environment

Automic system with MVS (z/OS) Agents

Cause

DE210010

Resolution

Solution:

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


Fix version:

Component(s): Agent z/OS (MVS)

Automation.Engine 24.4.6 - TBD
Automation.Engine 2.6.2 - TBD

This release date may change. Please sign up for notifications to be updated when these releases are published following this knowledge article
https://knowledge.broadcom.com/external/article?articleNumber=142615