Error with SAP CDC connector in Azure Data Factory Pipeline

Junior Steve KAMDEM DJOKO 0 Reputation points
2024-04-19T09:48:02.5633333+00:00

I'm trying to use the SAP CDC connector to load incrementally my SAP data on VBAK and VBAP CDS views. It is weird because It works one time over two. And the other time it crashes with this error :

Job failed due to reason: at Source 'SAPSource': 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: 526c7a41-6049-4313-a687-0fda0eba72b2, error code: 2200 and error message: ErrorCode=SapOdpOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Sap Odp operation 'OpenOdpRead' failed. Error Number: '002', error message: 'Exception condition '' raised',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:161)

com.microsoft.dataflow.store.sapodp.S

Can I have an helping hand please ?

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,384 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,582 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. phemanth 5,830 Reputation points Microsoft Vendor
    2024-04-19T11:37:46.6433333+00:00

    @Junior Steve KAMDEM DJOKO

    Thanks for reaching out to Microsoft Q&A

    The issue was due to the additional privileges needed for the user to read data from SAP Operational Data Provisioning (ODP) framework. The full load works as there is not need to track the changes. To solve this issue, we added authorization objects S_DHCDCACT, S_DHCDCCDS, S_DHCDCSTP to the user profile which read data from SAP.

    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.

    0 comments