Share via

Intermittent ODBC Socket Closed Error with Linked Service

Kelly Mathison 25 Reputation points
2023-01-19T14:56:06.8866667+00:00

Hello!

In the last 3 weeks there have been 3 instances of the below failure. It has happened intermittently before this but these last 3 have been the closest together. This happens when our ADF pipelines kick off overnight, I log in in the morning and see them, and then have previously always been able to just re-run from failed activity but this morning that is not the case. I have been researching all morning and am struggling to find any reason for this? The other times this has happened they have always resolved itself but I'm concerned this time might not be the case. I am very new to all of this and very much learning as I go so any guidance or help on what may be causing this, if there is anything I can do would be much appreciated!

Operation on target CopyDBATables failed: Failure happened on 'Source' side. ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination,Source=,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kelly Mathison 25 Reputation points
    2023-01-25T18:38:40.9233333+00:00

    Hi @Bhargava-MSFT , sorry for my delay reply!! I shared this information with your team and then our connection resumed around 10:40 am yesterday and so far it's still connected successfully. I double checked the SHIR version and that hasn't been changed at all so at this time I don't have any further insight as to why this just started working again or why it stopped in the first place so we are just keeping an eye on it going forward you. Thank you for following up with me and helping with this!!

  2. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2023-01-25T23:50:03.4266667+00:00

    Hello @Kelly Mathison ,

    Welcome to the MS Q&A platform.

    Can you please confirm if you are using the on-prem data source?

    If yes, I guess it could be related to your SHIR version. Can you please check if there are any recent updates on the SHIR version?

    And please let us know your SHIR version.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.