Symantec Management Platform (Notification Server)

I'm trying to delete a retired computer out of our system since it's been retired over a year now. 31 others deleted fine but this one seems to be stuck in something. I've done some looking around and the only references to something like this were about SQL deadlocks but I'm not seeing anything referring to that in the logs.

Here is what's showing up in the log:

Log File Name: D:\Altiris\Notification Server\Logs\a.log

Priority: 1

Date: 11/15/2011 11:02:27 AM

Tick Count: -1978495203

Host Name: ALTNOTIFY

Process: w3wp.exe (3544)

Thread ID: 312

Module: AltirisNativeHelper.dll

Source: Item::Delete

Description: An unexpected exception has occured (Item: 8b98fe94-580a-4f13-82bf-6fe08d5b8d41, Exception: System.Data.SqlClient.SqlException: Invalid object name 'dbo.Inv__MHC_CustomRegistryKeys'.

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

I do see this Item GUID listed under a column in dbo.Inv_MHC_CustomRegistryKeys table but most of the data is NULL. It's the only thing in this table, this must have been something my predecessor set up so I'm not even sure that this table is needed since this is the only asset in there.

I would do a statement like DELETE FROM Inv_MHC_CustomRegistryKeys WHERE Guid='blah' where blah is the GUID you see in the table.  Then I'd try deleting it again.  Is this successful for you?

I had a bunch of projects come up and just now got a chance to try this. I delete it from that table, there is now nothing in that table (it was the only thing in there) and attempted to delete it again but got the same message. I'm wondering if it's possibly referenced somewhere else. I got the same message from the log:

Log File Name: D:\Altiris\Notification Server\Logs\a.log
Priority: 1
Date: 1/16/2012 12:13:22 PM
Tick Count: 1136128500
Host Name: ALTNOTIFY
Process: w3wp.exe (7096)
Thread ID: 768
Module: AltirisNativeHelper.dll
Source: Item::Delete
Description: An unexpected exception has occured (Item: 8b98fe94-580a-4f13-82bf-6fe08d5b8d41, Exception: System.Data.SqlClient.SqlException: Invalid object name 'dbo.Inv__MHC_CustomRegistryKeys'.
   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())