Error Subscriptions in Hana Cloud

[chrisesco]

Hi experts,

I currently upload information from the S/4HANA source system to the Hana Cloud target system with Operational Delta Queues.

Since more than a month ago I have had problems with this and I have updated the agent and other things, the fact is that now I have tried to re-run the reptask, the subscription is created, it seems that it will start replicating data, but there comes a time that the subscription shows the following error: "Recovery of old requests not possible. Close delta {2022-12-30 15:48:48 000004 UTC-5} and try again".

This happens to me with all the reptask that I have, I have checked the agent, but it does not show me any relevant error, in S/4HANA I do not see errors for the requests that are created, also from that side everything works normally, the ODQDATA table has the data and is available to deliver them.

In the replication task configuration I have also run all replication modes, all load modes, changed extractor names, extractor times, tried partitioning, and nothing works.

The documents I am trying to replicate are 2LIS.

Has this ever happened to you or something similar?

I would be grateful for your comments. Thank you.

[chrisesco]

Yes, they are the same 'extractionname'.

I have now the replication task running in Replication Behavior : 'Initial+realtime' in Extraction Mode: 'Full Extraction' and Extraction Method : 'Extraction through ODP Queue' is it advisable to leave this configuration like this?

Thanks Hellen.

[xiaoming_wu]

Hi Christian,

When you choose "realtime only", it will only run delta extraction, so initial load won't happen.
Did you set the same "extractionname" for both initial load and delta extraction?

Best regards
Helen

[chrisesco]

Hi Hellen,

I notice that the error only occurs when the 'Replication Behavior' in the replication task is set to "initial + realtime".

When I set the 'Replication Behavior' to "realtime only" the subscription does not show error, but it shows a data difference between the Subscription Monitor Statistics (column Applied Count) and the count(*) query, it is as if it could not replicate all the data.

[xiaoming_wu]

Hi Christian,
You can try the following.
1. Reset the subscriptions.
2. Go to ODQMON, confirm all the requests manually if they are not in confirmed status.
3. Go to the replication task, change the parameter for extractor name to something else.
4. Deploy the replication task and run again, monitor it for sometime, will it fail again?

Best regards
Helen