Informatica loads fail with connection errors in SQL Server Parallel Data Warehouse

Gilt für: SQL Server 2008 R2 Parallel Data WarehouseSQL Server 2012 Parallel Data Warehouse

Symptoms


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:

 

Note This connection error also affects other connections to PDW. For example, non-Informatica loads and other client connections may be affected.

Cause


This issue occurs due to name resolution failure.

Resolution


To fix this issue, follow these steps:

 
  • Replace SQLCTL01 connections with FQDN.
  • This specific client connects their load server to Microsoft Analytics Platform System (APS) by using InfiniBand.
     
    • Specify the appliance domain as the DNS suffix for the InfiniBand connection.

      Dialogue box of Advanced TCP/IP Settings
    • The external server only has one network adapter. Use both AD01 and AD02 for DNS servers.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.