Troubleshooting – delete task error with Ivanti EPM

Troubleshooting delete task – Step-by-step guide to Troubleshooting – delete task error with Ivanti EPM, including configuration, deployment, troubleshooting and practical administration

Useful external reference: Ivanti resources.

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

Useful external reference: Ivanti resources.

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

Useful external reference: Ivanti resources.

Troubleshooting delete taskUsing SQL Management Suite

Useful external reference: Ivanti resources.

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

Useful external reference: Ivanti resources.

Troubleshooting delete 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

Useful external reference: Ivanti resources.

Troubleshooting delete task – :: 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

Useful external reference: Ivanti resources.

Troubleshooting delete task – :: Delete the task from the LANDESK console.

Useful external reference: Ivanti resources.

Troubleshooting delete task

Useful external reference: Ivanti resources.

Troubleshooting delete task Overview