Missing Journal Receiver in iSeries Replication Task

[EY_]

Hi Support,

We are encountering an error in the AS400 DB2 replication task, where the process fails to retrieve the DB2 Journal's last write position. During this process, an SQL statement is executed with the Journal Receiver QSQJRN5385 specified, but it results in an error indicating that the receiver does not exist in the JRN_LIB. This prevents the system from reading the corresponding Journal information properly.

2025-04-20T13:32:02 [SOURCE_CAPTURE  ]E:  Failed (retcode -1) to execute statement: 'SELECT journal_code,journal_entry_type,sequence_number,commit_cycle,entry_timestamp,object,cast(null_value_indicators as VARBINARY(8000)) null_value_indicators,count_or_rrn,receiver_library,receiver_name,"CURRENT_USER",job_name,program_name, minimized_entry_data,cast(entry_data as VARBINARY(32740)) entry_data FROM TABLE(QSYS2.Display_Journal('JRN_LIB','QSQJRN', OBJECT_OBJTYPE=>'*FILE', STARTING_SEQUENCE=>'91091418', JOURNAL_CODES=>'CDFRJ', JOURNAL_ENTRY_TYPES=>'PT,PX,UB,UP,DL,DR,BR,UR,CG,DF,CT,SC,CM,CR,RB,FN,PR', STARTING_RECEIVER_LIBRARY=>'JRN_LIB', STARTING_RECEIVER_NAME=>'QSQJRN5385')) AS J WHERE (journal_entry_type in('SC','CM','CT','RB','PR') OR (substr(object,1,20) in ('JRN_NAME JRN_LIB')))' [1022502]  (ar_odbc_stmt.c:2865)

2025-04-20T13:32:02 [SOURCE_CAPTURE  ]E:  RetCode: SQL_ERROR  SqlState: 58004 NativeError: -443 Message: [IBM][System i Access ODBC Driver]SQL0443 - Object QSQJRN5385 in library JRN_LIB not found. [1022502]  (ar_odbc_stmt.c:2871)

2025-04-20T13:32:02 [SOURCE_CAPTURE  ]E:  [IBM][System i Access ODBC Driver]SQL0443 - Object QSQJRN5385 in library JRN_LIB not found. [1020111]  (db2i_endpoint_capture.c:1594)

2025-04-20T13:32:02 [TASK_MANAGER    ]I:  Task error notification received from subtask 0, thread 0, status 1020111  (replicationtask.c:3628)

2025-04-20T13:32:02 [TASK_MANAGER    ]W:  Task 'AS400 to MSSQL' encountered a recoverable error  (repository.c:6344)

2025-04-20T13:32:02 [SORTER          ]I:  Final saved task state. Stream position JRN_LIB:QSQJRN5385:91091418, Source id 1187810, next Target id 7908945, confirmed Target id 7908941, last source timestamp 1744712431205030  (sorter.c:782)

2025-04-20T13:32:02 [SOURCE_CAPTURE  ]E:  Error executing source loop [1020111]  (streamcomponent.c:1945)

2025-04-20T13:32:02 [TASK_MANAGER    ]E:  Stream component failed at subtask 0, component st_0_AS400  [1020111]  (subtask.c:1465)

2025-04-20T13:32:02 [SOURCE_CAPTURE  ]E:  Stream component 'st_0_AS400' terminated [1020111]  (subtask.c:1634)

Is there a way in Qlik Replicate to directly switch to a new QSQJRN receiver or to reset the task and start the replication process from scratch?

Thank you for your help.

[john_wang · Accepted solution]

Hello @EY_ ,

The error: SQL0443 – Object QSQJRN5385 in library JRN_LIB not found typically indicates that the journal receiver is missing or unavailable.

Qlik Replicate will automatically switch to the latest available receiver, so no manual intervention is usually required.

If the error persists, please verify whether the journal receiver exists by running the following query:

SELECT * FROM TABLE(QSYS2.OBJECT_STATISTICS('JRN_LIB', 'JRN JRNRCV')) AS X ORDER BY OBJCREATED

where JRN_LIB is the journal receiver library name. Take note the library name should be in UPPER CASE.

Be mind that, If this DB2 for i (DB400) system is a standby instance replicated via MIMIX, it's possible that the newest receiver was temporarily locked or held by MIMIX, which could explain the issue but it should be finish in short time.

Regards,

John.