ADF: Error while using SAP CDC: Full on the first run, then incremental

Question

I want to extract data from a Datasource in SAP using the CDC Connector in Data Factory. However, I encounter the following error when executing the dataflow:

Job failed due to reason: Job failed due to reason: at Source 'source1': Error Message: DF-SAPODP-012 - SapOdp copy activity failure with run id: 9f1c94ab-e1aa-40d5-a347-a92097cdbdef, error code: 2200 and error message: ErrorCode=SapOdpOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Sap Odp operation 'Execute function module RODPS_REPL_ODP_PREFETCH with pointer 20240304044112.000030000' failed. Error Number: '010', error message: 'Task ODQR_20240304_044112_000007_C has failed',Source=Microsoft.DataTransfer.Runtime.SapRfcHelper,'

I have ensured that the SAP server is running, and the CDC connector has been configured correctly, the datasource has already configured generic delta. Because when i choose Fullload or Incremental only the taskflow run successfully.

Answer 1

Hi @Nguyen Quoc Hung (VN.EDM) Welcome to Microsoft Q&A forum and thanks for reaching out here.

Based on the error message you provided, it seems that there is an issue with the SAP ODP operation 'Execute function module RODPS_REPL_ODP_PREFETCH with pointer 20240304044112.000030000'. This error message indicates that the task ODQR_20240304_044112_000007_C has failed.

To troubleshoot this issue, you can follow the below steps:

• Check if the SAP system has provided the correct number of records for your scenario. You can use the SAP ODQMON tool to analyse the data provided by the SAP system. If the number of records provided on the SAP side matches the number of rows transferred by Data Factory, the issue is probably related to an incorrect or missing configuration on the SAP side.
• Check if you have the required authorization profile to execute the related function module. If not, you can follow the SAP notes to add the required authorization profile to your SAP account.
• Check if the ODP context/ODP name you specified supports delta. If not, you can enable delta mode for your SAP source or select Full on every run as the run mode in the data flow.
• If you are extracting big tables, you may encounter an out of memory (OOM) issue. In this case, you can use the SAP CDC connector to do a full load directly from your source system, then move delta to SAP Landscape Transformation Replication Server (SLT) after init without delta is released.

Similar forum thread on the SAP community that may provide some hints on the SAP side - RODPS_REPL_ODP_FETCH error when loading from SLT to Azure via SAP CDC Connector

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.