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

Question

Job failed due to reason: at Source 'SAPCDC': Please check error message, if it contains SAP server related error stacktrace, please contact SAP admin for assistance. Otherwise, please contact Microsoft support for further assistance. Error Message: DF-SAPODP-012 - SapOdp copy activity failure with run id: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx, error code: 2200 and error message: ErrorCode=SapOdpOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Sap Odp operation 'OpenOdpRead' failed. Error Number: '505', error message: 'Pointer does not contain source xxxxxxxxxxxxxx or is no longer available',Source=Microsoft.DataTransfer.Runtime.SapRfcHelper,', Exception: com.microsoft.dataflow.Utils$.failure(Utils.scala:76)

com.microsoft.dataflow.store.sapodp.SapOdpAdmsRequestConstructor$.executeAndMonitorCopyActivity(SapOdpAdmsRequestConstructor.scala:327)

com.microsoft.dataflow.store.sapodp.SapOdpAdmsRequestConstructor$.executeSapCDCCopyInternal(SapOdpAdmsRequestConstructor.scala:

Answer 1

@Francis Apel Welcome to Microsoft Q&A forum and thanks for reaching out here.

Could you please check ODQMON and see whether the initial loads were recorded?

 

If the initial load has successfully worked, then please try updating the checkpointer key and redo the initial load.

In the past we have seen customers running into an OOM issue from the SAP server side and may require them to check with the SAP team to retrieve the server issues first and use a test program to retrieve data from the SAP GUI, especially if it is failing on the ADF side.

 

To run a quick test, please start with checking the ODQMON records as to whether the initial load records are still present and then update the checkpoint key values and re-execute the initial loads through use of a small table for verification purposes.

I would also recommend you to please reach out in SAP community forum as well as open a support ticket with SAP to further investigate on this as it seems more of SAP side problem.

Hope this helps. Let us know how it goes.

Thank you

---

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.

Answer 2

There was no indication from the SAP side that this request was received, so no information in ODQMON. I ended up changing the checkpoint key as noted by KranthiPakala . The load then worked.