In the process of cleaning up the Notification Server database and assets, I cannot delete computers and assets from the Altiris console. The error message in the log viewer says it could not find stored procedure:
Log File Name: D:\Program Files\Altiris\Notification Server\Logs\a.log Priority: 1 Date: 8/1/2007 10:37:29 AM Tick Count: -1098417484 Host Name: AT-VCALTIR-PKG Process: w3wp.exe (6676) Thread ID: 2376 Module: AltirisNativeHelper.dll Source: Item::Delete Description: An unexpected exception has occured (Item:Delete AltirisNativeHelper.dll , Exception: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.sp_Inv_Software_Release_Inventory_resource_delete'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Altiris.NS.ResourceManagement.DataClass.Purge(Guid dataClassGuid, GuidCollection resourceGuids) at Altiris.NS.ResourceManagement.ResourceDataManager.PurgeResourceData(GuidCollection resourceGuids) at Altiris.NS.ResourceManagement.Resource.OnDelete() at Altiris.NS.ItemManagement.Item.Delete())
In one instance, apparently, during a patch upgrade, the stored procedure referenced in the logs was removed, which is causing this problem with deleting certain resources.
You need to re-create that stored procedure to resolve the problem. Run the query below against the database that is experiencing this problem. As always, when modifying databases, make sure you have a backup of your database prior to running the query: