SQL Loader test Connection Issue

Identity Security Cloud (ISC) ISC Discussion and Questions
1

HI all,

Facing attached issue in SQL Loader Test Connection. We have 3-4 SQL Loader sources but facing issue only for some of them.

Can anyone please guide what could be the reason behind this.

image

2

Without knowing more details, I’d suspect this is likely a timeout failure related to “HealthCheckTimeout” or “Timeout” as described in the following troubleshooting documentation
https://documentation.sailpoint.com/connectors/sql_loader/help/common/identitynow_topics/timeout_errors.html

One way to confirm is to confirm what these timeout values are set to in your configuration and then time the connection test from start to failure message and see if it aligns with these values. If so, increase these values to determine if there is any difference.

3

Hi @edmarks,

I have configured aggregateTimeout → 450 (as file has huge data in it), healthCheckTimeout → 180 & timeout->90.

This is very intermittent issue.

1 Like
4

I noticed other places in the documentation referencing the “intermittent timeouts” and unfortunately I don’t have any good advice for handling these.

5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.