data_error_counter in task_tables.sqlite and Replicate UI

[Mukhtar]

Hello , 

from my understanding of the column data_error_counter in replicate task_tables.sqlite  shows the data errors for a table. however when i check for table that has data errors shown in Replicate UI its still 0. if its not related to the UI then which file/table I can query that has the value of each table data errors. 

[OritA]

Hi Mukhtar, 

We usually do not provide detailed information about the structure of the internal table used by Replicate as this is for the internal use of R&D only. Could you please explain what are you trying to achieve and based on your need we can help and instruct you how you can meet your request using the official supported product functionality. 

Regards,

Orit

[SushilKumar]

Hello @Mukhtar 

It as Advised not to access SQLite Files until asked or Suggested by Qlik R&d team, any Acess may impact the Qlik replicate Functionality. 

If you have some requirement as per use case get in touch with PS . 

Regards,

Sushil Kumar 

[Mukhtar]

Hello , 

we want to get information about all tables and the status of each table in Replicate task, like table name , table_status (loading, completed etc.) , and data errors. I was able to see table_status ( 3 , 2, 100 ) and so on , but for the data errors i can not find it.

I want to store these information on a status_table on our DB , so whenever someone want to use a  table can quickly/automatically check if this table in reload or has any data errors. 

[SushilKumar]

Hello @Mukhtar 

You can refer below link for more info to get the info .

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Control%20Tables/control_tables...

Regards,

Sushil Kumar