Ghost Qlik Replicate Task: Incorrect notifications for non-existent tasks on the Qlik Replicate server

[SachinB]

Qlik Replicate sends alerts and notifications about a previously deleted task or which otherwise does not exist.

This article guides you in resolving incorrect notifications for non-existent tasks.

Resolution

A sqlite editor and knowledge on how to use it is required for this change, such as the DB Browser for SQLite: https://sqlitebrowser.org/

1. Open the DB Browser as Administrator
2. Click File > Open and navigate to C:\Program Files\Attunity\Replicate\data\tasks\RepoGlobal.repo (this path may change according to your environment)
3. Open RepoGlobal.repo
4. Switch to the Execute SQL tab
5. Run this command:
   
   TaskNameHere is to be replaced with the task name you receive notifications for.
   
    SELECT * FROM tasks WHERE task_name LIKE 'TaskNameHere'
   
   
   
   
6. Press F5 to execute the query or click run
7. If the task exists on this table, you will see one line in the results.
8. To delete the task, run this command:
   
   TaskNameHere is to be replaced with the task name you receive notifications for.
   
   DELETE FROM tasks WHERE task_name LIKE 'TaskNameHere';
   
   
9. Press F5 to execute the query. A message about the successful deletion will appear.

Verify that you do not receive any more messages from the deleted task. 

Environment

Qlik Replicate