A complicated SQL query on a connection fails during Mapping with "Connection timed out" (229603)
A complicated SQL query on a connection fails during Mapping with "Connection timed out"
When attempting a Full Map on a SQL or MySQL connection which leverages a complicated query, mapping may fail with the error Connection timed out
Building a connection from a complicated SQL or MySQL query make take longer than the default connection timeout specifies.
- In the Quick Connect or Active Roles Synchronization Service Console, choose Connections and click on the SQL or MysSQL connection name.
- Choose Connection Settings | Advanced
- Specify a large timeout value in seconds. Increase the value until the mapping completes successfully.
© 2021 One Identity LLC. ALL RIGHTS RESERVED.