Forced Traces with Error " Database access via key 'AH_Idnr' with value 0 in module 'UCGENX_R'".
search cancel

Forced Traces with Error " Database access via key 'AH_Idnr' with value 0 in module 'UCGENX_R'".

book

Article ID: 420135

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Forced Traces with Error" Database access via key 'AH_Idnr' with value 0 in module 'UCGENX_R'. 

20250901/160820.351 -  UCGENX_R              RCV  QUITT2   frm UC4PRD#WP011                              MQWP     MsgID: 1912460693 c-acv: 264A9B31
<...>
20250901/160820.352 -  INSERT INTO MELD (MELD_Idnr, MELD_USR_Idnr, MELD_Seen, MELD_TimeStamp, MELD_MsgNr, MELD_DeleteFlag, MELD_Client, MELD_Source, MELD_Category, MELD_Type, MELD_ArchiveFlag) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
20250901/160820.353 -  tabelle cachen: MELD       PUT
20250901/160820.353 -  UCUDB32 INSR RET 0000 HSTMT: 0x00000005c5a280 VALUE: 0x00000000000001 ALL:  0.00074 DB:  0.00054 ODBC:  0.00000 UDB:  0.00020
20250901/160820.353 -  U00000008 Unexpected response to message type ''.
20250901/160820.353 -    EXIT UCUMELD        RET: 0000000000 TIME: 0000,00084 RETTEXT='' 
20250901/160820.353 -  UC_AKTX_SEARCH: GENX/
20250901/160820.353 -  UC_AKTX_FOUND: 0000001700/0000000000/QUITT2
20250901/160820.353 - U00009909 TRACE: (BINDPAR:  AH_Idnr            0x7ffba10f57e0 00004
                                00000000  00000000                             >....<
20250901/160820.353 -                                         >0<
20250901/160820.353 -  SELECT AH.*,ROWID FROM AH WHERE AH_Idnr = ? FOR UPDATE
20250901/160820.354 -  UCUDB32 SLCU RET 0000 HSTMT: 0x00000005c5a280 VALUE: 0x00000005c5a280 ALL:  0.00101 DB:  0.00068 ODBC:  0.00014 UDB:  0.00019
20250901/160820.354 -  UCUDB32 READ RET 0001 HSTMT: 0x00000005c5a280 VALUE:            (nil) ALL:  0.00005 DB:  0.00004 ODBC:  0.00000 UDB:  0.00001
20250901/160820.354 -  UCUDB32 CLST RET 0000 HSTMT: 0x00000005c5a280 VALUE:            (nil) ALL:  0.00008 DB:  0.00000 ODBC:  0.00005 UDB:  0.00003
20250901/160820.354 -  U00003620 Routine 'UCGENX_R' forces trace because of error.
20250901/160820.354 -  U00005118 Program error: Database access via key 'AH_Idnr' with value 0 in module 'UCGENX_R'

Environment

AE 24.4.0

Resolution

This is a known issue and fixed in 24.4.3 ( Should be available towards the end of 2025 tentatively ).