Share all details related to your problem, including any error messages you may have received.
Hello Experts,
I am working on Oracle DB aggregation and failed with below error. Can you please help me that how to fix this issue.
Exception during aggregation. Reason: java.lang.RuntimeException: sailpoint.connector.ConnectorException: [ ConnectorException ] [ Error details ] [ ConnectorException ] [ Error details ] Failed to aggregate.[LDAP: error code 3 - The maximum time limit of 60 seconds for processing this search operation has expired]
Though the error says LDAP, sometimes it can happen in DB as well, I assume you are using JDBC connector and connecting to oracle db
Reason might be your aggregation query is complex or not properly optimized
Please revisit the query once and try to run directly at target and see how much it takes and see if this can enhanced
Also check in DB side logs if there is blocking transactions causing this ( may not be the case here mostly)
In worst case increase the timeout configuration at DB end and see if that helps.
Again please check with Targeted team , is there any restriction at there side …
Also can you try to single account aggregation through rule or console.
Either of this case your ldap search filters for aggregation needs to be checked and have to check at target side logs and increase the time limit for search operations if necessary
Also try running single account targeted aggregation as well once to check if its not an issue with your connectivity and other configurations.
Have you checked your filter via some LDAP browser? What is the time it is taking from there?
It the timing to get the data is more than the configured time then refer to the below link for changing the configuration as per the result filter time. Let us know if you still face the issue after making changes.
The OOTB Oracle Database connector is a very good connector. We have used it at many clients. The only thing which might be slightly complicated is building the SSB with the correct Oracle JDBC driver (and remove the OOTB provided driver), but that’s it.
Your DBA should be able to provide you with the Oracle JDBC driver and the JDBC connection string (jdbc:oracle:thin:@<HOST>:<PORT>:<SID>)