Thursday 14 April 2022

Error while Copying data from Oracle 12c to Oracle 19c db using ADF V2 copy data activity

In ADF pipeline, while I use copy data for connecting to Oracle 19c Database, i get following error:

Components Used :

Copy data source / sink uses Oracle 19c and connectivity is established through Oracle linked service with SHIR run time

While copying data from azure sql to oracle I am getting following error.

{
    "errorCode": "2200",
    "message": "Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Data type for parameter 3 has changed since first SQLExecute call.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Data type for parameter 3 has changed since first SQLExecute call.,Source=msora28.dll,'",
    "failureType": "UserError",
    "target": "Copy_26n"
}

Resolution:

While creating linked service for Oracle 19c DB, add additional connection properties:

Property name: workarounds 

Value: 536870912




No comments:

Post a Comment