locked
Communication link failure RRS feed

  • Question

  • Hi all,

    i am looking for solution for "Communication link failure"  since many months in google but no luck, am running an SSIS package to load data. job failing many times with error 'Communication link failure', searched every where but found nothing. Below is the complete error description when job failed, can any one let me know how to resolve / suggestions or any ideas about issue.

    OS - Windows server 2008 R2 Enterprise Edition

    RAM - 198GB

     SQL server 2008 R2 Enterprise Edition and error description is below,

    Started:  6:22:40 AM  Error: 2015-08-19 18:50:32.70     Code: 0xC0202009     

    Source: Data Flow Task Lookup [193]     
    Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. 
    Error code: 0x80004005.  An OLE DB record is available.  

    Source: "Microsoft SQL Server Native Client 10.0"  
    Hresult: 0x80004005  Description: "Communication link failure".  An OLE DB record is available.  

    Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  
    Description: "Communication link failure".  An OLE DB record is available.  

    Source: "Microsoft SQL Server Native Client 10.0"  
    Hresult: 0x80004005  Description: "TCP Provider: An existing connection was forcibly closed by the remote host.  ".  End Error  Error: 2015-08-19 18:50:32.80  Code: 0xC020824C     

    Source: Data Flow Task Lookup [193]     
    Description: OLE DB error occurred while loading column metadata. Check SQLCommand 
    and SqlCommandParam properties.  End Error  Error: 2015-08-19 18:50:32.80     
    Code: 0xC0208235     

    Source: Data Flow Task Lookup [193]     
    Description: Unable to locate reference column "lkey".  

    End Error  Error: 2015-08-19 18:50:32.81     Code: 0xC004701A     Source: Data Flow Task SSIS.Pipeline     
    Description: component "Lookup" (193) failed the pre-execute phase and returned 
    error code 0xC0208235.  End Error  DTExec: The package execution returned 
    DTSER_FAILURE (1).  Started:  6:22:40 AM  Finished: 6:50:38 PM  Elapsed:  44877.7 
    seconds.  The package execution failed.  The step failed.

    Regards,

    Syed Jakeer

    Thursday, August 20, 2015 7:45 PM

Answers

All replies

  • Hi all,

    i am looking for solution for "Communication link failure"  since many months in google but no luck, am running an SSIS package to load data. job failing many times with error 'Communication link failure', searched every where but found nothing. Below is the complete error description when job failed, can any one let me know how to resolve / suggestions or any ideas about issue.

    OS - Windows server 2008 R2 Enterprise Edition

    RAM - 198GB

     SQL server 2008 R2 Enterprise Edition and error description is below,

    Started:  6:22:40 AM  Error: 2015-08-19 18:50:32.70     Code: 0xC0202009     

    Source: Data Flow Task Lookup [193]     
    Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. 
    Error code: 0x80004005.  An OLE DB record is available.  

    Source: "Microsoft SQL Server Native Client 10.0"  
    Hresult: 0x80004005  Description: "Communication link failure".  An OLE DB record is available.  

    Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  
    Description: "Communication link failure".  An OLE DB record is available.  

    Source: "Microsoft SQL Server Native Client 10.0"  
    Hresult: 0x80004005  Description: "TCP Provider: An existing connection was forcibly closed by the remote host.  ".  End Error  Error: 2015-08-19 18:50:32.80  Code: 0xC020824C     

    Source: Data Flow Task Lookup [193]     
    Description: OLE DB error occurred while loading column metadata. Check SQLCommand 
    and SqlCommandParam properties.  End Error  Error: 2015-08-19 18:50:32.80     
    Code: 0xC0208235     

    Source: Data Flow Task Lookup [193]     
    Description: Unable to locate reference column "lkey".  

    End Error  Error: 2015-08-19 18:50:32.81     Code: 0xC004701A     Source: Data Flow Task SSIS.Pipeline     
    Description: component "Lookup" (193) failed the pre-execute phase and returned 
    error code 0xC0208235.  End Error  DTExec: The package execution returned 
    DTSER_FAILURE (1).  Started:  6:22:40 AM  Finished: 6:50:38 PM  Elapsed:  44877.7 
    seconds.  The package execution failed.  The step failed.

    Regards,

    Syed Jakeer

    Thursday, August 20, 2015 7:40 PM
  • You need to look at the last error.  Your true error is:

    Source: Data Flow Task Lookup [193]     
    Description: OLE DB error occurred while loading column metadata. Check SQLCommand 
    and SqlCommandParam properties.  End Error  Error: 2015-08-19 18:50:32.80     
    Code: 0xC0208235     

    Source: Data Flow Task Lookup [193]     
    Description: Unable to locate reference column "lkey".  

    You have an invalid column reference in your query.

    Thursday, August 20, 2015 8:03 PM
  • Hi, thanks for reply, same package running since 18 months and no code changes at all. job failed after 12 hrs and reported above error, I've verified everything and seems good. generally job take 07 hrs to complete. 

    Regards,

    Syed Jakeer


    Syed Jakeer

    Thursday, August 20, 2015 8:13 PM
  • Hi Syed,

    Since you say that the issue is suddenly, it looks like it is a network issue or connection issue. Please check your firewall setting or network load, and if you have the same problem with correct version provider or other providers.

    Another possible reason for this issue is SNP features (TCP Offload, RSS) is enabled on the server. To disable the TCP Offload and RSS features, please see the following KB articles:
    http://support.microsoft.com/kb/951037
    http://support.microsoft.com/kb/948496

    References:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fab0e3bf-4adf-4f17-b9f6-7b7f9db6523c/communication-link-failure-when-connecting-to-remote-database
    https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Friday, August 21, 2015 6:08 AM
  • Hi Katherine , thanks for the reply. seems posts / reply's from below links worked by by replace / change in connection manager. ( https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fab0e3bf-4adf-4f17-b9f6-7b7f9db6523c/communication-link-failure-when-connecting-to-remote-database ). i'll check in this weekend.

    Regards,

    Syed Jakeer



    Syed Jakeer

    Monday, August 24, 2015 4:25 PM