none
Exporting newly provisioned items to SQL RRS feed

  • Question

  • Hello All!

    I have a SQL MA that I am using to hold mail enable AD objects. When I provision new items imported from AD in the SQL connector space they are exported cleanly to SQL. However, upon the next import on the SQL MA the newly exported items shows as Adds. The Anchor value is the same as originally created during provisioning. Once I perform a sync then they will show up as unchanged on subsequent imports.

    Is this part of the process or is something odd going on? Here is my provisioning code (ID is anchor). I do believe I can remove the DN code but I get the same response.

    CSEntry newCSEntry = this.Connectors.StartNewConnector(MVEntry.ObjectType);
    ReferenceValue dn = this.CreateDN("{" + this.MVEntry.ObjectID.ToString().ToUpper() + "}");
    newCSEntry.DN = dn;
    newCSEntry["ID"].StringValue = "{" + this.MVEntry.ObjectID.ToString().ToUpper() + "}";
    newCSEntry.CommitNewConnector();

    UPDATE:
    This also happens when I flow an update to an object already connected to both AD and SQL. I make a change in AD, it flows across and successfully updates SQL. Upon the next import from SQL it shows an update for same object and the same attributes are being modified. There is no duplicate objects so I am not understanding this process.

    Thank you!
    Karl


    • Edited by karlmanlab Friday, March 14, 2014 5:44 PM
    Friday, March 14, 2014 4:04 PM

All replies

  • Hello,

    For me this line is not needed

    newCSEntry["ID"].StringValue = "{" + this.MVEntry.ObjectID.ToString().ToUpper() + "}";

    because it's already set with

    newCSEntry.DN = dn;

    DN is also your anchor.

    Regards,


    Sylvain

    Friday, March 14, 2014 5:02 PM
  • Hello Sylvain, thanks for the reply.

    That is what I had read but if I remove the code to set the anchor ("ID") then I get a missing-anchor-component error. However, if I remove the code to set the DN and only set the anchor, it works fine for exporting. Of course, I still have the issue with them being added again on import.

    Just trying to find out if the "re-adding" is just how it works or I have something configured incorrectly. Nothing gets duplicated so it seems okay, just odd.

    Thank you
    Karl

    Friday, March 14, 2014 5:17 PM
  • The Add is expected on the import.

    Thanks, Brian

    Saturday, March 15, 2014 12:36 AM
    Moderator