Data Extraction from SAP to Azure Datalake with Datafactory using SAP CDC

1.3k Views Asked by At

I am extracting ABAP CDS views from the SAP with Data Factory using SAP CDC. The ABAP CDS views are delta enabled but anytime I try to extract full load, I get the following error:

Message=Sap Odp operation 'Execute function module RODPS_REPL_ODP_PREFETCH with pointer 20220810084136.000021000' failed. Error Number: '666', error message: 'An exception with the type CX_SY_DYNAMIC_OSQL_SEMANTICS occurred, but was neither handled locally, nor declared in a RAISING clause',Source=Microsoft.DataTransfer.Runtime.SapRfcHelper

And when I try delta extraction, I get this error:

Message=Sap Odp operation 'OpenOdpRead' failed. Error Number: '500', error message: 'Source ZB4H_AUPH_2 Does not support deltas',Source=Microsoft.DataTransfer.Runtime.SapRfcHelper,'

How do I solve this issue?

1

There are 1 best solutions below

1
Mr_Unchained On

The solution was to implement sap note 3070258