Management Agent's "Missing-Anchor-Component" Error Message Does Not Provide Row Information (818560)

SYMPTOMS

When you run a management agent to import information from an SQL database, a list of discovery errors that is similar to the following may appear:

Discovery Errors	3 Error(s)
DN is unavailable	missing-anchor-component
DN is unavailable	missing-anchor-component
DN is unavailable	missing-anchor-component

When you click one of the missing-anchor-component links, and then click Error Details, information that is similar to the following appears:This dialog contains additional information about this error provided by the connected data source

Connected data source error code:
Connected data source error: Couldn't construct anchor because the value for column 'AttributeName' is unavailable.

Additional information:Although the message indicates that a value is missing in a particular column in the data source, it does not indicate the row or rows in that data source where this value is missing.

CAUSE

This issue occurs if both of the following conditions exist:

When you created this management agent, you configured the Set Anchor special attribute to a column attribute from the data source.

-and-
Certain rows in that data source do not have a value in that column.

The management agent cannot return the row or rows where this value is missing because it uses the anchor component to determine these rows. In this scenario, this anchor component is missing.

RESOLUTION

To resolve this issue, run an SQL query against the database to determine which rows are missing a value in the column where you set the management agent anchor. Add the missing values to the returned rows, and then, using the same run profile, run the management agent again. For example, create an SQL query that is similar to the following to locate the records with missing anchor values

SELECT *
FROM tableName
WHERE tableName.columnName IS NULL

where tableName is the name of the table you query, and where columnName is the column where you set the anchor in your management agent.