JDBC Account Aggregation error

We are using a JDBC connector to read a table which is in a SAP system. I am seeing the below error at times. The test connection is inconsistent as it shows healthy and at times the account aggregation fails with below error.
Any idea if this has to something with the SAP system or the VA in IdentityNow that the source is being used?

Hi @Prashanth0707,

if this doesn’t always happen, this problem could be caused on some network problem.

If the testaggrergation work one time, it means you have the permission for reading the table. But, if it doesn’t work sometimes the cause could be on network configuration, like firewall configuration, wrong iproute, LB, ecc…

Also, it could possible that some configuration on DB, block you; for example, in some moment you are blocked for max number of connections.

Hi @enistri_devo ,
Thank you for your response. I do think it’s a network firewall issue. Will troubleshoot on that end!

1 Like