Issue with deleting a EPM task

The issue may arise from a package associated with a task that no longer exists.

WARNING: A database backup is MANDATORY before proceeding with these steps. Contact LANDESK support before making any changes.

Using SQL Management Suite

:: Identifying task IDs => Identify the ID of the problematic task
SELECT * FROM [LDMS].[dbo].[LD_TASK]

:: Validating the WHERE clause to retrieve only one row => There should only be one row returned. Here, my problematic task is 123
SELECT * FROM [LDMS].[dbo].[LD_TASK] WHERE LD_TASK_IDN = 123

:: Modifying the database => Replace the non-existing package with an existing one (here 456)
UPDATE [LDMS].[dbo].[LD_TASK] SET PACKAGE_IDN = 456 WHERE LD_TASK_IDN = 123

:: Delete the task from the LANDESK console.