Facing below error while copying from azuredb to oracle

Singh Amardeep (SEIT) 26 Reputation points
2022-11-07T08:47:25.843+00:00

I am facing the below issue while copying azure db table to oracle. Can someone please help

Operation on target CopyWholetabledata failed: Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to add value to the parameter array. ParameterName=ROWID, ValueType=WCHAR, ParameterType=VARCHAR, ColumnSize=-1, ElementBufferSize=-1, Precision=0, Scale=0, Length=0, Value=7be898e4-c152-4c84-9efc-2ec0b56b2231, ValueLogicalType=System.Guid,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcBulkCopyException,Message=Failed to add value to the parameter array. ParameterName=ROWID, ValueType=WCHAR, ParameterType=VARCHAR, ColumnSize=-1, ElementBufferSize=-1, Precision=0, Scale=0, Length=0, Value=7be898e4-c152-4c84-9efc-2ec0b56b2231, ValueLogicalType=System.Guid,Source=Microsoft.DataTransfer.ClientLibrary.OdbcBulkCopy,''Type=System.InvalidCastException,Message=Object must implement IConvertible.,Source=mscorlib,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,487 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Singh Amardeep (SEIT) 26 Reputation points
    2022-11-09T12:30:56.15+00:00

    Thanks for the reply. I resolved it by importing a schema before copy.

    1 person found this answer helpful.