Copy data from Oracle to SQL Server in Azure using ADF - Failure

Question

Hello, I'm loading data from Oracle to Azure SQL Server by ADF it works well with loading tables with the standard structure, but when I want to add a field which is got through function made in Oracle I'm getting this error : "errors": [ { "Code": 9602, "Message": "Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42S22] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00904: "ENG_PART_MAIN_GROUP_API"."GET_DESCRIPTION": invalid identifier\n,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [42S22] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00904: "ENG_PART_MAIN_GROUP_API"."GET_DESCRIPTION": invalid identifier\n,Source=msora28.dll,'", "EventType": 0, "Category": 5, "Data": { "FailureInitiator": "Source" }, "MsgId": null, "ExceptionType": null, "Source": null, "StackTrace": null, "InnerEventInfos": [] } ] The query is : "oracleReaderQuery": "SELECT PART_CATALOG.*, ENG_PART_MAIN_GROUP_API.Get_Description(PART_CATALOG.PART_MAIN_GROUP) AS PART_MAIN_GROUP_DESCRIPTION, objversion as adf_watermark_value FROM IFSAPP.PART_CATALOG

Answer 1

Your issue typically occurs when there is a reference to a column, table, or alias name that the Oracle database cannot resolve. Before using the function in ADF, test it directly in the Oracle environment using the same user credentials as ADF uses. This can help determine if the issue is with the function itself or its invocation from ADF.

SELECT ENG_PART_MAIN_GROUP_API.Get_Description('sample_part_main_group') FROM dual;

https://stackoverflow.com/questions/6027961/ora-00904-invalid-identifier