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: <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <P>Log File Name: D:\Program Files\Altiris\Notification Server\Logs\a.log<BR>Priority: 1<BR>Date: 8/1/2007 10:37:29 AM<BR>Tick Count: -1098417484<BR>Host Name: AT-VCALTIR-PKG<BR>Process: w3wp.exe (6676)<BR>Thread ID: 2376<BR>Module: AltirisNativeHelper.dll<BR>Source: Item::Delete<BR>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'.<BR> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()<BR> at Altiris.NS.ResourceManagement.DataClass.Purge(Guid dataClassGuid, GuidCollection resourceGuids)<BR> at Altiris.NS.ResourceManagement.ResourceDataManager.PurgeResourceData(GuidCollection resourceGuids)<BR> at Altiris.NS.ResourceManagement.Resource.OnDelete()<BR> at Altiris.NS.ItemManagement.Item.Delete())</P></BLOCKQUOTE>
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.
<P dir=ltr>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:</P> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <P>create proc dbo.[sp_Inv_Software_Release_Inventory_resource_delete] <BR><BR> @ResourceGuid uniqueidentifier<BR><BR>as <BR><BR>set nocount on <P><BR>delete from dbo.[Inv_Software_Release_Inventory] where _ResourceGuid =<BR>@ResourceGuid<BR><BR>GO</P></BLOCKQUOTE><br/><p><b>Applies To</b><br/>Notification Server 6.0