Deleting and Merging computer records fails - Unable to delete computer from the console - Object reference not set to an instance of an object
Last Updated June 15, 2016
Unable to delete a computer from the console.
Unable to delete computer: NullReferenceException: Object reference not set to an instance of an object.
Virtual dataclass entry listed for the computer in ResouceUpdateSummary.
Use this SQL SELECT Statement to see if this problem does exist in your database:
SELECT a.Name, c.Name, rs.* FROM ResourceUpdateSummary rs join ( SELECT guid, Name FROM DataClass WHERE IsVirtual = 1 )a on a.Guid = rs.InventoryClassGuid join vRM_Computer_Item c on c.Guid = rs.ResourceGuid
If it does then please follow the solution listed below.
NOTE: Before running queries directly against your database, make sure to have a current database backup. ResourceUpdateSummary is a very important table in the SMP and incorrectly editing it or removing records can cause serious problems.
To remove the incorrect references from ResourceUpdateSummary use the SQL DELETE statement below.
DELETE FROM ResourceUpdateSummary WHERE InventoryClassGuid in (SELECT guid FROM DataClass WHERE IsVirtual = 1)
ITMS 7.1 SP2 MP1
Imported Document ID: TECH217269
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe