Missing Journal Receiver in iSeries Replication Task

EE_ — Mon, 21 Apr 2025 09:35:00 GMT

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.

Re: Missing Journal Receiver in iSeries Replication Task

john_wang — Wed, 23 Apr 2025 14:17:35 GMT

Hello @EE_ ,

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:

topic Re: Missing Journal Receiver in iSeries Replication Task in Qlik Replicate

Missing Journal Receiver in iSeries Replication Task

Re: Missing Journal Receiver in iSeries Replication Task