Error in reporting: 'The changes you requested for the table were not successful because they would (NETIQKB26245)

fact
Directory and Resource Administrator 6.x

fact
Directory and Resource Administrator 7.x

symptom
Error in reporting: 'The changes you requested for the table were not successful because they would create duplicate values in the index, primary key or relationships.....'

cause

The problem occurs if you are importing from two different domains that both have a computer account with the same name. 

For example, if you have a computer named testcomputer in domainA and a computer named testcomputer in domainb, you will receive this error because the MCSNameValue of the computers are the same and you cannot have the same name because this value is used as a unique index. 

The resources reports use the MCSNameValue of the Computers table as an index so if there are two computer in two domains that you are importing have the same SAMAccountName, this error will result.

fix

Please refer to the following workarounds are:

1.  Find the computer names that are dupllicates and see if they are "active computers".  If one is inactive, can the computer account be deleted?

2.  Is one of the duplicate computer objects in a trusted domain?  If yes, do not import information about trusted domains.

3.  Perform an import, limiting the scope of the domains to import, to not include one of the domains with the duplicate computer name.

 

fix

To find the duplicate computer accounts:

1. Open the DRA reporting tool and select File | Enter Design mode.
   
2. Select the table tab and open the table called Accounts.
   
3. The column (field) called MCSClass stipulates the class of the object.
   
4. Select the MCSClass column. 
   
5. From the menu select Record | Sort | Sort Ascending A-Z.
   
6. Look for Duplicate names under the Account Name column. 

 

An Enhancement Request has been opened with Development to include this functionality in a future version of Directory and Resource Administrator.

note

If you open the Directory and Resource Administrator (DRA) reporting tool and enter design mode, there is a table called Computers.   This table holds all the information when you choose to import Resource information.  In the computer table there is a field called MCSNameValue.   This field holds the saMAccountName of the computer object.  If you look at any of the resources reports, for example 'Services', it is based on a query (called qryservices) which uses the information from the computer table.  The MCSNameValue is the index for all these resource reports. 

Formerly known as NETIQKB26245