data is not updating correctly using QLIK Replicate

[AL9]

I exported a job from my old qlik server into my new qlik server. The source is DB AS400 and the target is PostGres.  The data record is not showing up correctly. It is showing zero instead of 100. 100 is on the old server. the new server is showing 0. I went through all the configurations for both servers and they are the same. I have enabled verbose on the problem server. 

Error:

0004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]T: get_capture_table_list: fetched table XXXX.XXX (db2i_endpoint_imp.c:1369)
00004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]V: Construct statement execute internal: 'select CARDINALITY from SYSIBM.SQLSTATISTICS where TABLE_SCHEM='XXXX' and TABLE_NAME='XXXX' and TYPE=0' (ar_odbc_stmt.c:4040)
00004876: 2025-01-15T16:43:13:218977 [METADATA_MANAGE ]T: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3976)

0004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: sqlite_step_ex_stmt: (rc == SQLITE_DONE || rc == SQLITE_ROW) failed (at_sqlite.c:525)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: SQLite general error. Code <19>, Message <UNIQUE constraint failed: load_status.seq_num>. [1000505] (at_sqlite.c:525)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]V: sqlite_step_ex_stmt:525: Failed (at_sqlite.c:545)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: sqlite_do_immediate: rc == SQLITE_DONE failed (at_sqlite.c:990)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]T: SQLite general error. Code <1>, Message <cannot start a transaction within a transaction>. [1000505] (at_sqlite.c:990)
00004876: 2025-01-15T16:43:18:673285 [DATA_STRUCTURE ]V: sqlite_do_immediate:990: Failed (at_sqlite.c:994)

00005956: 2025-01-15T16:43:44:157964 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:2784)
00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]T: Retrieved system names 'XXXX '.'XXXX ' for 'XXXX'.'XXXX' (db2i_endpoint_util.c:961)
00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]V: Construct statement execute internal: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:4040)
00005956: 2025-01-15T16:43:44:392500 [SOURCE_CAPTURE ]T: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3976)
00005956: 2025-01-15T16:43:44:649307 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='XXXX' and TABLE_NAME='XXXX'' (ar_odbc_stmt.c:2784)

[john_wang]

Hello @AL9 ,

Welcome to Qlik Community forum and thanks for reaching out here!

All the above errors/warnings are unrelated to your data issue, they can be ignored. Instead, I'd like to suggest you enabling the Verbose log with:

1- if the issue occurs in Full Load stage then enable SOURCE_UNLOAD/TARGET_LOAD to Verbose

2- if the issue occurs in CDC stage then enable SOURCE_CAPTURE/TARGET_APPLY to Verbose

3- Please do not forget to decrypt the verbose task log files

then check the task log files to understand the root cause. If you require assistance, please open a support ticket and attach the diagnostic packages. Our support team will be more than happy to assist you.

Hope this helps.

John.

[AL9]

We have opened a support case. thanks