SAP CDC to Azure Data Lake pipeline created in ADF but job is failing with below error. How to fix it? There are no logs in SAP system ST22 for this job run.

Question

Job failed due to reason: at Source 'XXXX': Error Message: DF-SAPODP-012 - SapOdp copy activity failure with run id: d904fd07-0a9b-4a4e-bc97-04d0a141451e, 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 20230601050314.001386000' failed. Error Number: '520', error message: 'Maximum waiting time of 7.200 seconds exceeded',Source=Microsoft.DataTransfer.Runtime.SapRfcHelper

Answer 1

@Arvind Ramalingam Welcome to Microsoft Q&A forum and thanks for reaching out here.

By looking at the error message it is being thrown by SAP function module. And looks like it is timing out for some reason. I'm not familiar with SAP but as per my research, this is more of SAP side issue and needs to be analyzed by SAP folks. Hence, I recommend reaching out in SAP community forum for assistance with regards to this issue. And if SAP folks point out anything specific to Azure Data factory, kindly let us know and we will deep dive into it.

Here is forum thread from SAP community which is similar to this, please have a look at it as reference and see if that provide any hints on SAP side: RODPS_REPL_ODP_FETCH error when loading from SLT to Azure via SAP CDC Connector

Hope this helps. Let us know how it goes.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.