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

SachinB — Wed, 08 Nov 2023 13:53:11 GMT

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.

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/

Open the DB Browser as Administrator
Click File > Open and navigate to C:\Program Files\Attunity\Replicate\data\tasks\RepoGlobal.repo (this path may change according to your environment)
Open RepoGlobal.repo
Switch to the Execute SQL tab
Run this command:

TaskNameHere is to be replaced with the task name you receive notifications for.

SELECT * FROM tasks WHERE task_name LIKE 'TaskNameHere'
Press F5 to execute the query or click run
If the task exists on this table, you will see one line in the results.
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';
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.

article Ghost Qlik Replicate Task: Incorrect notifications for non-existent tasks on the Qlik Replicate server in Official Support Articles