none
Reference DN option is unhighlighted RRS feed

  • General discussion

  • Hi,

     

    When I create a SQL Server management agent as HRMA then under the option configure columns I have set Anchor as "EmployeeId" attribute and I want to also give a Reference (DN)  as "RMEmployeeId" attribute but under the columns when I select  "RMEmployeeId" and click "Edit" then the Reference (DN) is not highlighted. I am not able to check this option. Under the object type "Person" is selected.

    Snapshot is attached.

    Regards,

    Sonal

    Wednesday, July 18, 2012 7:35 AM

All replies

  • I'd seen that grayed out before but never paid attention.  I checked a couple of my few SQL MAs and found that some had the checkbox available and others did not.

    While I've not been able to find it documented explicitly, the pattern I've found is that the string attributes that can be marked as a reference are not being exported from, or imported to, string attributes in the metaverse.  This makes sense because you cannot flow a string value to a reference value, or vice-versa.

    If this is a reference value, make sure you don't have any flow rules defined for that attribute.  If there are and you remove them, go back to the properties and see if the checkbox is available.  If you change it though, you'll have to change the metaverse attribute you export to, or import from, to a reference-type attribute.

    Chris

    Thursday, July 19, 2012 6:06 PM