Share all details about your problem, including any error messages you may have received.
Hi, I am working on integrating one JDBC application. We are connecting this application through cloud gateway. We are able to connect to the application and can aggregate the accounts and groups.
But sailpoint is unable to aggregate all the accounts. In target there are more than 10k users accounts present, where as sailpoint could aggregate only around 5000 users and it does not show any error and shows successfully completed. This number varies sometimes, so sometimes it goes till 4500 or 4800 and completes there.
Have anyone face this issue for JDBC connectors? I guess some data issue during aggregation might be causing this. In this case how can I debug which account creates trouble?
@sahoos9 , in Database application, single user has single row entry or multiple entries? would you be able to share aggregation taskDefination and taskResult screenshot? Ideally for JDBC if you have if you are not merging the records and filtring the data using build-map or customisation rule all records should be aggregated. Could it be possible that you have “Only create links if they can be correlated to an existing identity.” option checked in the aggregation task which is only correlation identities and not creating identities if correlation condition is matched?
Hi @sahoos9 , Looking at you task result and taskDefination it looks like the SQL Statement used for your application is returning only 5000 Unique userId. Could you please try aggregation by removing Build Map rule once?
Found out the issue was with Cloud gateway F5 load balancer. We are connecting to the application through cloud gateway where we use F5 load balancer. When we pointed the cloud gateway to only one server, we were able to aggregate all the accounts.
