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.
0 Comments