SQL Loader: [ ConnectorException ] [ Error details ] Error occurred during test configuration operation. Please check the logs. Error: Timeout Interrupted Exception: beyond 1000 msecs to open a table of X

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi all,

We are seeing an issue with a SQL Loader connector. We can ping the server from the VA successfully. However, we see the following error on Test Connection and Aggregation:

We have detected an error from the managed system.

Error Received:

[ ConnectorException ] [ Error details ] Error occurred during test configuration operation. Please check the logs. Error: Timeout Interrupted Exception: beyond 1000 msecs to open a table of X.

We have increased the healthCheckTimeout to 300 and added the ‘timeout’ attribute, and set this to 180.

Any suggestions are welcome!

Many thanks,
Jade

2

Hi @jade-townsend,

Find the below troubleshooting document link for this connector.
Troubleshooting (sailpoint.com)

Thank you.

3

Hi @jade-townsend,

in this case I think the timeout depends from DB. The DB is setting that it can’t take more than a second to open the table.
It could depend on the size of table, the resource of DB, locks or query.
Execute the query into a DB manager and check the execution time and if query works.
Also, you can make a network test for check the performance

4

Thank you! It appears to timeout on the netcat command, possibly the the port isn’t accessible.

5

Good, you are on the way to find the solution.
Check the firewall rule, the permission and bandwidth