Inventory Solution Tasks Not Running Correctly

What a frustration. You click on your Inventory task and all of the sudden you see the following error: "Error when node clicked: An unexpected exception has occured during CreateInstance."

Read on for the remedy.

Click to view.

Well, the solution to this issue is not a simple as you might think. KB Article 36366, found at https://kb.altiris.com/article.asp?article=36366&p=1 gives the best solution to making sure that you database is ready to handle to load that inventory solution can apply.

The bulk of the resolution to this issue comes from understanding the incorrect customizations that were previously made to the database.