Informatica loads fail intermittently in Microsoft SQL Server 2008 R2 Parallel Data Warehouse (PDW), Microsoft SQL Server 2012 Parallel Data Warehouse, or Microsoft SQL Server 2016 Parallel Data Warehouse. Additionally, you may receive connection error messages that resemble the following:
- Connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
...
WRITER_1_*_1> SQL_SERVER_PDW_1037 [ERROR] SQL error: The TCP/IO connection to the host <PDW control node>, port 17001 has failed: Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port" - Could not connect to net.tcp://<non-existent IP>/Microsoft.SQLServer.DataWarehouse.Loader... A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond <non-existent IP>
- READER_1_1_1> rr_4036 Error connecting to database
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in opening server connection...
Database Error: Failed to connect to database using user <user name> and connection string <PDW ODBC>
Note This load also reads from PDW. Therefore, the reader is also susceptible to the connection error.
Note This connection error also affects other connections to PDW. For example, non-Informatica loads and other client connections may be affected.