3661509 - AIF - Runtime issues when using the program /AIF/SERIAL_GET_ROOT_MSGS

• The program /AIF/SERIAL_GET_ROOT_MSGS encounters runtime errors / dumps when processing more than 1000 GUIDs.
• The following error messages are observed for the majority of cases:
  • DBSQL_STMNT_TOO_LARGE -  "The Open SQL command is too big."
  • TIME_OUT - "Time limit exceeded"
  • CX_SY_OPEN_SQL_DB
• The issue occurs when the report is started for interface with large amount of single index table entries, and corresponding serialization table entries.
• Large amounts of warning logs for in-process AIF Messages observed: "A predecessor exists (with MSGGUID <...>); message cannot be processed", and the report is executed for these AIF interface messages to find the root predecessors.

DISCLAIMER: Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• Application Interface Framework for NetWeaver
• SAP BTP, ABAP Environment
• SAP S/4HANA

runtime issue, /AIF/SERIAL_GET_ROOT_MSGS, DBSQL_STMNT_TOO_LARGE, TIME_OUT, ABAP dump, SAP S/4HANA, AIF, GUID processing, CFIN_AIF_IDX_TBL, error messages, SQL size restriction, message archiving, SAP HANA, rdisp/scheduler/prio_high/max_runtime, dbs/hdb/input_parameters., root predecessors, message in process, in process status,  , KBA , BC-SRV-AIF , Application Interface Framework , CA-GTF-AIF , Application Interface Framework , Problem