SQLLoader connector intermittent timeout issue

[PriyankaRaoraneAD (Priyanka Raorane)]

Hi All,

We have many SQL Loader connections integrated in IdentityNow. We are observing test connection and aggregation failures for these connections, with timeout or authentication errors. Has anyone faced a similar issue, and if so, has a fix been received for this?Below are the errors we are receiving at our end -

1. [ ConnectionFailedException ]
   [ Possible suggestions ] Verify that Connection User and Password are correct.
   [ Error details ] Error occurred while establishing the connection with Data File during iterate operation. Auth fail
   2.[ ConnectionFailedException ]
   [ Possible suggestions ] Verify that Connection User and Password are correct.
   [ Error details ] Error occurred while establishing the connection with Data File during iterate operation. Failed to load table

The username and password are correct because when we run a manual test connection or aggregation, they work fine.

[mpotti (Mark Potter)]

you might need to increase the timeout threshold on the connector. This would really depend on how large your data set is that you are trying to pull in.

[PriyankaRaoraneAD (Priyanka Raorane)]

I tried to add the timeout,lockour period in the connection.Then it is giving the error
" Error!

[ ConnectorException ]
[ Error details ] Error occurred during iterate operation. Please check the logs. Error: Timeout Interrupted Exception: beyond 5000 msecs to open a table".

Any other way to fix this issue.

[suresh4iam (Suresh Kumar Palanisamy)]

You need to increase the timeout on connector level by using the Source partial update API

For Aggregation, you can set aggregateTimeout, for Test Connection you can set healthCheckTimeout. There are few more options that you can check in SailPoint integration document. Sample Source PATCH API body for your reference

[
  {
    "op": "add",
    "path": "/connectorAttributes/healthCheckTimeout",
    "value":"30"
  }
]