Restituisci
-
Titolo
A complicated SQL query on a connection fails during Mapping with "Connection timed out" -
Descrizione
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 -
Causa
Building a connection from a complicated SQL or MySQL query make take longer than the default connection timeout specifies. -
Risoluzione
WORKAROUND
- 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.