Poor Reconciliation Performance

This topic has 0 replies, 1 voice, and was last updated 6 years, 2 months ago by tfreeman1.

  • Author
    Posts
  • #11298
     tfreeman1
    Participant

    I’m experiencing poor reconciliation performance on OpenIDM.

    Here are the details.
    ————————————————————-
    Source=SQL Server
    Target=Manged User Object (stored in postgres db)

    Right now it’s taking a considerable about an hour to reconcile approximately 1300 records.

    I have tried several things with no improvement.
    * Reconciliation Query Filters for Source and Target…
    `
    …””target” : “managed/user”,
    “source” : “system/TRNetDatabase/__ACCOUNT__”,
    “name” : “sourceTrnetdatabase__ACCOUNT___managedUser”,
    “sourceQueryFullEntry” : true,
    “sourceQuery” : {
    “_queryFilter” : “UserName sw \”\””
    },
    “targetQuery” : {
    “_queryFilter” : “userNamesw \”\””
    }…”
    `
    * Using the Default Behavior Policy
    * Startup options -Xmx1024m -Xms1024m (I have increased these as well w/ no improvement)

    I’m at a bit of a loss as to how to proceed improving performance. When monitoring the source system, it seems like the reconciliation is processed in batches of 30 but I have no idea why. I do not have paging turned on.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

©2022 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?