返回
-
标题
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. -
解决办法
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.