Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException

Question

I was trying to load data from on-prem data lake to azure gen2 using copy activity through SHIR.

Facing this issue.

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,
Message=ERROR [HY000] [Microsoft][Hardy] (40) Error occurred while fetching result set.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,'
'Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][Hardy] (40) Error occurred while fetching result set.,Source=Microsoft Hive ODBC Driver,'

Answer 1

Hi @venkat ,

Thank you for posting query in Microsoft Q&A Platform.

As per my understanding here, You are trying to Copy data from HIVE on-prem to Azure data lake storage gen2 using SHIR and ending up with above issue. Kindly correct me if my understanding is incorrect and help me with type of connector you are using for source dataset.

From the error message it looks has ODBC driver issue. Could you please check is Microsoft Hive ODBC driver installed and has DSN setup in system where SHIR is installed? If not, kindly do the same and see if that helps.

Link to download Microsoft ODBC driver is: https://www.microsoft.com/en-in/download/details.aspx?id=40886
Once the installation or Upgrade completes consider restarting system.

Hope this helps. Please let us know how it goes. Thank you.