data is not updating correctly using QLIK Replicate

AL9 — Wed, 15 Jan 2025 09:44:28 GMT

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)

Re: data is not updating correctly using QLIK Replicate

john_wang — Sun, 19 Jan 2025 14:21:55 GMT

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.

Re: data is not updating correctly using QLIK Replicate

AL9 — Tue, 21 Jan 2025 23:38:31 GMT

We have opened a support case. thanks

topic Re: data is not updating correctly using QLIK Replicate in Qlik Replicate

data is not updating correctly using QLIK Replicate

Re: data is not updating correctly using QLIK Replicate

Re: data is not updating correctly using QLIK Replicate