Getting error "The specified GUID does not refer to a item (GUID: Computer)" when trying to modify an AD Import Rule
search cancel

Getting error "The specified GUID does not refer to a item (GUID: Computer)" when trying to modify an AD Import Rule

book

Article ID: 176819

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

When trying to change the Resource Type for one of the AD Import Rules or just modify something on it, you get an error referencing that it is an invalid Resource Type. Looking on the Notification Server logs, you can find references of the following errors:

Priority: 1
Date: 10/13/2008 9:55:35 AM
Tick Count: 1181538640
Host Name: NS Server
Process: w3wp.exe (1440)
Thread ID: 7984
Module: AltirisNativeHelper.dll
Source: Altiris.NS.ItemManagement.Item.GetName
Description: The specified GUID does not refer to a item (GUID: 493435f7-3b17-4c4c-b07f-c23e7ab7781f)

Priority: 1
Date: 10/13/2008 9:55:35 AM
Tick Count: 1181538671
Host Name: NS Server
Process: w3wp.exe (1440)
Thread ID: 7984
Module: AltirisNativeHelper.dll
Source: global.asax
Description: Unhandled exception.  Type=Altiris.NS.Exceptions.AeXException Msg=The specified GUID does not refer to a item
StackTrace=
   at Altiris.NS.ItemManagement.Item.GetName(Guid itemGuid)
   at Altiris.DirectoryServices.UI.ResourceSelectDlg.GetResourceTypeName(Guid resourceTypeGuid)
   at ASP.ResourceSelectDlg_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in E:\Altiris\DirectoryConnector\ResourceSelectDlg.aspx:line 573
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.Control.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Page.ProcessRequestMain()

Note: in this case GUID '493435f7-3b17-4c4c-b07f-c23e7ab7781f ' refers to 'Computer' Resource Type.

Other common Resource Types are

ECADDEC9-3178-4FFB-BEB4-D29E0767A79E > Network Resource
493435F7-3B17-4C4C-B07F-C23E7AB7781F     > Computer
597AB6B8-1057-4A7D-B6F1-2665F07987CC    > Subnet
28C3406A-8476-407D-8F99-81656E8890F8       > Site
FD864F19-4437-4A4F-8709-58EB5E3AE0A4     > User
DD2CF9C3-00C8-4123-A64F-D351703745EE    > Package
D2CFA253-5266-4E77-ADF4-026D997EF7A2    > Company
857B18CD-2603-4AC5-B8CC-B116BAE5BBBE > Department
8E4F62F4-948C-4071-87A0-F39EDFFA9795     > Network Printer
2C3CB3BB-FEE9-48DF-804F-90856198B600    > Virtual Machine

As well, if run a repair on the Notification Server, you may see the following error:

Host Name: NS Server
Process: AeXConfig.exe (6292)
Thread ID: 5076
Module: AltirisNativeHelper.dll
Source: Altiris.NS.ItemManagement.ItemHelper
Description: An unexpected exception has occured (Exception: Altiris.NS.Exceptions.AeXItemImportException: Item Import exception : 597ab6b8-1057-4a7d-b6f1-2665f07987cc = Altiris.Resource.ResourceTypeItem(61863e29-baa0-4317-977c-56cc4577243a) ---> Altiris.NS.Exceptions.AeXException: Unable to update the specified item from the Altiris NS database ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.ResourceType' with unique index 'IX_ResourceType_Guid'.
The statement has been terminated.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Altiris.Resource.ResourceTypeItem.OnSave(Boolean bExistingItem)
   at Altiris.NS.ItemManagement.Item.Save()
   --- End of inner exception stack trace ---
   at Altiris.NS.ItemManagement.Item.Save()
   at Altiris.NS.ItemManagement.Item.Import(XmlNode itemNode)
   at Altiris.NS.ItemManagement.Item.ImportItem(XmlNode itemNode)
   --- End of inner exception stack trace ---
   at Altiris.NS.ItemManagement.Item.ImportItem(XmlNode itemNode)
   at Altiris.NS.ItemManagement.ItemHelper.ImportItemNodesEx(XmlNodeList childItemNodes))

Cause

Multiple ResourceTypes used for AD Import Rules (Computer, User, Subnets, etc.) already exists in the ResourceType table, but not in the Item table.

The AD Import Rule fails to open because of the entry in the ResourceType table exists but not in the Item table, thus creating the problem.
Incomplete installations may cause this as well deleting entries directly from the Item table, where one reference is created/entered in the ResourceType table but not in the Item table. When we run repairs on the Notification Server, if there is a reference already in the ResourceType table, an error referencing to "Cannot insert duplicate key row in object 'dbo.ResourceType" will appear, causing to skip adding the missing resource types into the Item table. 

Resolution

To resolve this issue for the Computer resource type, you would do the following:

  1. Back up the Altiris database.
  2. Execute the following script against the Altiris database:

    DELETE FROM ResourceType
    WHERE Guid = '493435f7-3b17-4c4c-b07f-c23e7ab7781f' --resourcetype guid

  3. Once complete, run a repair on Resource Management.
    1. Go to \Program Files\Altiris\Setup Files\NS\.
    2. Right-click on the Altiris_ResourceMgmt.msi file and select Repair.

Applies To
Notification Server 6.0.6074 SP3
Active Directory Import 6.1.842

Powered by Wolken Software