none
Unble to connect to on-premise DB2 using Azure Data factory RRS feed

  • Question

  • Hi,

    I am trying to create an azure data factory V2, which will be pulling data from on-premise IBM DB2 database.

    I have created self hosted integration runtime but it is failing to connect.

    Here are event viewer entries that gets created whenever there is an attempt for connection

    Error: TestConnection failed, error message: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to the Db2 server.,Source=Microsoft.DataTransfer.ClientLibrary.Db2Connector,StackTrace=   at Microsoft.DataTransfer.ClientLibrary.Db2Connector.Db2ProviderHandler.OpenConnection()

       at Microsoft.DataTransfer.ClientLibrary.Db2Connector.Db2Validator.Validate(String connectionString)    at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.ConnectorTestConnection(ConnectionSetting connectionSetting, TestConnectionV2Response response)    at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.TestConnection(TestConnectionV2Request request, TestConnectionV2Response response)    at Microsoft.DataTransfer.TransferTask.InteractiveTask`2.Execute(),''Type=Microsoft.HostIntegration.DrdaClient.DrdaException,Message=The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE=HY000 SQLCODE=-360,Source=Microsoft.HostIntegration.Drda.Requester,StackTrace=   at Microsoft.HostIntegration.Drda.Requester.Manager.ProcessReplyInfo(SqlStatement statement, ReplyInfo replyInfo, String errorMessageBase)    at Microsoft.HostIntegration.Drda.Requester.SecurityManager.<SubmitSecchkAsync>d__14.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at Microsoft.HostIntegration.Drda.Requester.Requester.<ConnectAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at System.Runtime.CompilerServices.TaskAwaiter.GetResult()    at Microsoft.HostIntegration.DrdaClient.DrdaConnection.<InternalOpenAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at Microsoft.HostIntegration.DrdaClient.DrdaConnection.Open()    at Microsoft.DataTransfer.ClientLibrary.Db2Connector.Db2ProviderHandler.OpenConnection(),'. Log ID: Error

    Error:DEBUG:

    TraceComponentId: QueryTask TraceMessageId: QueryRuntimeTestConnectionV2Exception @logId: Error FunctionName: TestConnection jobId: 00000000-0000-0000-0000-000000000000 activityId: 301f1ddb-382a-46d8-bfc2-681ac0ebdc98 eventId: QueryRuntimeTestConnectionV2Exception message: TestConnection failed, error message: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to the Db2 server.,Source=Microsoft.DataTransfer.ClientLibrary.Db2Connector,StackTrace=   at Microsoft.DataTransfer.ClientLibrary.Db2Connector.Db2ProviderHandler.OpenConnection()    at Microsoft.DataTransfer.ClientLibrary.Db2Connector.Db2Validator.Validate(String connectionString)    at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.ConnectorTestConnection(ConnectionSetting connectionSetting, TestConnectionV2Response response)    at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.TestConnection(TestConnectionV2Request request, TestConnectionV2Response response)    at Microsoft.DataTransfer.TransferTask.InteractiveTask`2.Execute(),''Type=Microsoft.HostIntegration.DrdaClient.DrdaException,Message=The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE=HY000 SQLCODE=-360,Source=Microsoft.HostIntegration.Drda.Requester,StackTrace=   at Microsoft.HostIntegration.Drda.Requester.Manager.ProcessReplyInfo(SqlStatement statement, ReplyInfo replyInfo, String errorMessageBase)    at Microsoft.HostIntegration.Drda.Requester.SecurityManager.<SubmitSecchkAsync>d__14.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at Microsoft.HostIntegration.Drda.Requester.Requester.<ConnectAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at System.Runtime.CompilerServices.TaskAwaiter.GetResult()    at Microsoft.HostIntegration.DrdaClient.DrdaConnection.<InternalOpenAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at Microsoft.HostIntegration.DrdaClient.DrdaConnection.Open()    at Microsoft.DataTransfer.ClientLibrary.Db2Connector.Db2ProviderHandler.OpenConnection(),'.

    Information: DEBUG:

    TraceComponentId: QueryTask TraceMessageId: QueryRuntimeTestConnectionV2 @logId: Information jobId: 00000000-0000-0000-0000-000000000000 activityId: 301f1ddb-382a-46d8-bfc2-681ac0ebdc98 eventId: QueryRuntimeTestConnectionV2 message: TestConnection finish, duration: 638.2112 ms.

    Can someone please help?

    Thanks!

    Best Regards, Shahzad

    Wednesday, November 6, 2019 12:57 PM

Answers

  • Hi,

    Yes, issue has been resolved by installing the following

    IBM i Access for Windows

    It contains client connectivity tools, drivers, providers basically everything needed to connect to IBM DB2 iSeries

    Best Regards,
    Shahzad Ali

    • Marked as answer by -Shahzad Ali Tuesday, November 19, 2019 10:36 AM
    Tuesday, November 19, 2019 10:36 AM

All replies