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

Question

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 ?

Answer 1

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

Answer 2

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.