Question Re: Multiple ODQ-subscriptions for unique subscriber in Technology Q&A

Multiple ODQ-subscriptions for unique subscriber

IvBa — Mon, 22 Jul 2024 15:32:20 GMT

Hi guys,

I am currently working on a project to extract Data from S4 to Azure Datalake Storage using Azure Data Factory. I have set everything up as I think it should be using the SAP CDC linked service, including a unique subscriber name. Further I have selected the option for initial full load and afterwards incremental.

If I process the Dataflow it works as intended. Also when I create some test-data in our SAP-System, I can load the deltas just fine. After a few hours however, when I run the Dataflow again SAP provided me with a initial full load again. I checked the ODQMON transaction and noticed that I have two active subscriptions for my subscriber name. So it seems, that the ODP Framework adds a separate subscription from time to time, that forces me to load all the data again. Has someone had a similar issue and can give me some advise on how to get the system to use the existing subscription rather than creating new ones?

Thanks a lot

Ivo

Re: Multiple ODQ-subscriptions for unique subscriber

peterolsson33 — Wed, 31 Jul 2024 08:13:23 GMT

We had similar issue and I recall you have to give a guid/identifier on the Microsoft side for the adater towards SAP, else a new subscription is started everytime and delta will not work.

Re: Multiple ODQ-subscriptions for unique subscriber

roland_szajko — Mon, 05 Aug 2024 09:29:15 GMT

Hi Ivo

Check:

3406581 Error when extracting from Azure by calling ODP interface
3334148 RfcBaseException on RODPS_REPL_CONTEXT_GET_LIST occurs while using "SAP CDC" in Azure
3255746 - Unpermitted usage of ODP Data Replication APIs

Roland