Delta functionality using 'ABAP ODP Reader' operator with out delta init for each run?

[SandhyaN]

version - Data intelligence 3.0

Connectiopn type - ABAP

I am using DI operator 'ABAP ODP reader' to extract data from ODP enabled data source in ECC in Delta mode. When I run the graph in DI, it adds new subscription in ECC (ODQMON) and initiated delta monitoring (delta init). As long as this graph is active all records are flowing through ok. However, if I stop the graph and start again, a new subscription is added with a new delta init. I want the second run to pick up data from the same subscription as the first one.

I tried to add a subscription id in 'Abap ODP Operator' but it is not helping.

Please advise how to achieve single delta init for all runs in DI.

-Thanks

Sandhya

[SandhyaN]

After debug, I was able to figure out that root cause of the issue is because of the cofig name mismatch.

ABAP code of ODP reader operator is looking for config name 'subscriptionID' while config name in DI is set to 'Subscription ID'. ABAP code was not able to read the value passed in DI and so couldn't connect to existing subscription. It used to see this value as blank and create new delta initialization everytime DI graph starts.

Once I reported the incident SAP released a new note 2979473 to handle the issue. If you are facing similar issue try this note.

https://launchpad.support.sap.com/#/notes/2979473

-Thanks

Sandhya

[former_member419354]

Hi Sandhya,

How to initialize the extractor from sap Di?

Could you please let us know the operators used in your graph.

[SandhyaN]

Hi Srinu

I used 'ABAP ODP Reader' in my graph. If extraction mode is Delta, when graph is run for the first time delta is initiated in ECC. You should see a new subsription created in ODQMON. If you add a subscription ID in 'ABAP ODP Reader' config, then a subscription is created with this name. Every time graph is run, it picks up records from same subscription. Hope this helps

[former_member419354]

Thank you so much for the reply.it helps

If we want reintialize the extractor due to delta pointer issue how we need to do?

For any selective pulls request ..date range input can be given right in the extractor?

[SandhyaN]

You are welcome Srinu.

I have not tested my graph for reinit or selective data requests. I would try below. let me know if it works, I could use the info.

Re init - I would assume for reinit we might have to delete the existing subscription and start over.

Selective data - in this scenario we apply filters in infopackage (in BW world). 'Adapted dataset' config in DI ODP operator can be used to apply filters.

-Thanks

Sandhya

[former_member742226]

Hi Sandhya,

Any idea on how to filter the data from SAP ECC --> SAP DI using ODP Operator?

Thank You!

Kumar

[SandhyaN]

Kumar

Use the 'Adapted Dataset' property and add text in below format. Operator expects filter information in Json format. For now passing filter is very cumbersome but possible.

example: {"filter":{"selectOptions":[{"name":"EBELN","elements":[{"sign":"I","option":"EQ","low":"<POnumber>","high":""}]}]}}

-Thanks

Sandhya

[former_member742226]

Thanks a lot, Sandhya for the quick response. Appreciate your help!

Can we also do a delta init without data - just to set the delta pointer from SAP ECC --> SAP DI using ODP Operator?

[abhimanyu_sharma]

Thanks @Sandhya for the solution. I came across the same issue and after implement the SAP Note it has fixed the issue.

thanks a ton.