Unable to delete assets from the console

Products

• IT Management Suite

Issue/Introduction

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())

Cause

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.

Resolution

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:

create proc dbo.[sp_Inv_Software_Release_Inventory_resource_delete]

        @ResourceGuid uniqueidentifier

as

set nocount on

delete from dbo.[Inv_Software_Release_Inventory] where _ResourceGuid =
@ResourceGuid

GO

Applies To
Notification Server 6.0