topic Re: data_error_counter in task_tables.sqlite and Replicate UI in Qlik Replicate

data_error_counter in task_tables.sqlite and Replicate UI

Mukhtar — Wed, 21 Aug 2024 13:46:21 GMT

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.

Re: data_error_counter in task_tables.sqlite and Replicate UI

OritA — Thu, 22 Aug 2024 07:44:34 GMT

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

Re: data_error_counter in task_tables.sqlite and Replicate UI

SushilKumar — Thu, 22 Aug 2024 07:49:02 GMT

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

Re: data_error_counter in task_tables.sqlite and Replicate UI

Mukhtar — Thu, 22 Aug 2024 08:19:12 GMT

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.

Re: data_error_counter in task_tables.sqlite and Replicate UI

SushilKumar — Thu, 22 Aug 2024 08:31:29 GMT

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.htm

Regards,

Sushil Kumar