Adding WorkAround =536870912 in the connection string in Key Vault

Question

All,

I am creating a copy activity to load data from SQL Server to Oracle table. Getting below 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 8 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 8 has changed since first SQLExecute call.,Source=msora28.dll,'", "failureType": "UserError", "target": "Copy data1", "details": [] }

When i searched in google, the workaround is to add WorkAround =536870912 in the "Additional Connection Properties" of linked service. This works if the connection values are hard coded like specifying the server name, user id, password etc. But i am connecting through Key Vault and would like to know how this can be added as part of Key Vault connection

My current Key Vault Secret value is below

"secretValue": "Host=<<server name>>;Port=100;Sid=OracleDB;User Id=<<userid>>;Password=<<password>>;"

Answer 1

Hi @Kumar, Arun , it's hard for me to test this on my end, but have you tried just adding it to the string?

"secretValue": "Host=<<server name>>;Port=100;Sid=OracleDB;User Id=<<userid>>;Password=<<password>>;WorkAround=536870912"