tables_status table in task_tables.sqlite

[Mukhtar]

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!

[DesmondWOO · Accepted solution]

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

[DesmondWOO · Accepted solution]

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

[Mukhtar]

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