Qlik Replicate: Connection failure to the SQLite database 'task_tables.sqlite'.

[avidary_qlik]

A Qlik Replicate task connecting to SQLite fails. Reviewing the log files (see How to read Qlik Replicate logs) shows the following entry:

[TABLES_MANAGER  ]T:  Connection to SQLite database 'task_tables.sqlite' failed

The immediate consequence is that the task fails to run.

Resolution

The file task_tables.sqlite has been corrupted on disk, possibly during an upgrade or a read/write interaction. The file can be removed. Qlik Replicate will create a new one on start.

To resolve the issue:

1. Open the Windows services console
2. Stop the Qlik Replicate Server service
3. In a Windows File Explorer, navigate to: C:\Program Files\Attunity\Replicate\data\tasks
4. Locate and rename task_tables.sqlite
5. Start up the Qlik Replicate Server service
6. Open the Qlik Replicate Web Console and start the task
   
   The renamed file can be deleted after you have confirmed Qlik Replicate to function as expected.

Cause:

The file can get corrupted during the upgrade process, and prevent the task from running. Qlik Replicate will create a new  'task_tables.sqlite'  if this file doesn't exist.

Environment

Qlik Replicate