HANA SDI - Remote Subscription on Oracle to clean up

[ssurampally]

Hi, We have created a replication task in HANA Dev system using SDI mechanism, the remote source is Oracle database. I can see that Remote Subscription exist on the oracle table in HANA Admin cockpit, also in REMOTE_SUBSCRIPTIONS table. Actually, I do not want the replication task to exist, I am rying to delete it in HANA WEb IDE is giving me an error message that, Remote subscription is stopped and DROP on subscription failed. How would I delete the replication task and subscription for this task? please let me know,

[former_member240828]

Hello Sreekanth,

for me this behavior sounds like there are unprocessed Remote Subscription Exceptions.

Can you please try to resolve or mark them as ignored through the IM DP Monitoring or through SQL? (See https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS00/en-US/c0220f038f95477e8d346af... )

Kind Regards,

Timo Wagner

[ssurampally]

I tried to use DROP REMOTE SUBSCRPTION <subscription name>, it is stilling giving the error, <remote subscription> in <remote Source> failed which is same one I get when I tried to drop the replication task from HANA Web IDE. I don't have any further options, let me know if you have any thoughts on this.