topic Re: tables_status table in task_tables.sqlite in Qlik Replicate

tables_status table in task_tables.sqlite

Mukhtar — Thu, 15 Aug 2024 10:34:30 GMT

Hi ,

I have a question about what is values in table_status column in tables_status table in replicate task_tables.sqlite DB file . i see for some tables its 3 and some 100 .

what are the meaning for each values (queue , loading , loaded , error) ?
Thank you!

Re: tables_status table in task_tables.sqlite

DesmondWOO — Thu, 15 Aug 2024 10:59:19 GMT

Hi @Mukhtar ,

Thank you for reaching out to the Qlik Community.

I've found following information from our support system:

• If you change the table_status value to 1, the next time you resume the task, the corresponding table will be reloaded.
• If you change the table_status value to 2, the next time you resume the task, the corresponding table will be queued and then reloaded.
• If you leave the table_status value as 3, the next time you resume the task, the corresponding table will not be reloaded, only CDC will be processed.

I believe above information was obtained through testing conducted by the engineer. Could you tell why you need this information?

Regards,
Desmond

Re: tables_status table in task_tables.sqlite

DesmondWOO — Thu, 15 Aug 2024 11:25:09 GMT

Hi @Mukhtar ,

Based on my test results,
- 100 means "table error during full load".
- 101 means "table is suspended".

Note that it is not recommended to update the SQLite file manually. Inappropriate processes may cause the repository to become corrupted.

Regards,
Desmond

Re: tables_status table in task_tables.sqlite

Mukhtar — Thu, 15 Aug 2024 12:54:49 GMT

Hi @DesmondWOO ,

Thank you for explaining it . we are not trying to change the table_status values in SQLite , instead we want to automat a process of knowing which tables are in which state. for example before a analytics query or workflow run on a table ; we check if this table in loading , error or completed state.

Thank You!
Mukhtar