Unable to extract data from Oracle Table to Parquet File which has a column of ANYDATA Data Type .

Singh, Akhilesh K 21 Reputation points
2022-01-28T12:58:33.867+00:00

Dear Sir/Madam

We want to extract data from an Oracle Table to Parquet File using ADF Pipeline but its failing because ADF is unable to export data from one column which has Data Type as "ANYDATA"

Could you please provide me the solution to extract data ?

169452-anydata.jpg

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

2 answers

Sort by: Most helpful
  1. Singh, Akhilesh K 21 Reputation points
    2022-02-01T17:13:10.82+00:00

    Hi @ShaikMaheer-MSFT

    Sorry for delay.

    Please find below error details which I am getting at COPY Activity.

    Error code : 2200

    Failure type: User configuration issue

    Details: Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Driver does not support some XMLType columns. You must cast the column to a CLOB by using the cast function.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Driver does not support some XMLType columns. You must cast the column to a CLOB by using the cast function.,Source=msora28.dll,'

    Source Pipeline: PL_Oracle_ADLS_NEW_csy_BottomLevel

    170228-errordetails.jpg

    0 comments No comments

  2. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-02-15T16:21:14.363+00:00

    Hi @Singh, Akhilesh K ,

    Thanks for sharing error message details.

    As per documentation CLOB data type can be mapped as string for Oracle connector. Click here to know about Data type mappings for Oracle.

    kindly try to see if loading as string type will help. Also, as requested before it would have been great if you can share mappings information and source and sink dataset details too for better idea on issue.

    0 comments No comments