Microsoft KB Archive/818560

= Management Agent's &quot;Missing-Anchor-Component&quot; Error Message Does Not Provide Row Information =

Article ID: 818560

Article Last Modified on 10/18/2003

-

APPLIES TO


 * Microsoft Identity Integration Server 2003 Enterprise Edition

-





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:

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 ' ' 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  is the name of the table you query, and where   is the column where you set the anchor in your management agent.

Keywords: kbprb KB818560

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.