search cancel

Deleting and Merging computer records fails - Unable to delete computer from the console - Object reference not set to an instance of an object


Article ID: 159243


Updated On:


IT Management Suite


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


Applies To


 ITMS 7.1 SP2 MP1