Share via

Error while copying data from SAP table to ADF using Table Connectore's RFC table option

Prabhat Rawat 1 Reputation point
2022-06-13T05:20:31.1+00:00

Hello,

I'm facing an issue while copying data from SAP source using ADF SAP table connector. As per the Official Documentation that I'm referring shows the approach to join 2 SAP tables and pull their output result set. But when I tried to implement that(as described in docs) for my use case I'm repeatedly getting the error shown below :

210686-error.png

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,473 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,755 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,201 Reputation points Microsoft Employee
    2022-06-14T10:56:45.42+00:00

    Hi @Prabhat Rawat ,

    Thanks for posting query in Microsoft Q&A Platform.

    This kind of error will come when SAP tried to execute an SQL statement that containing a dynamic entry.

    Kindly recheck your JOIN query and see if all good there?

    Please let us know how it goes. Thank you.