Skip to Content
0

HANA SDI - Remote Subscription on Oracle to clean up

Apr 06, 2017 at 10:06 PM

164

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sreekanth Surampally Apr 06, 2017 at 10:52 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Timo Wagner
Apr 11, 2017 at 12:38 AM
0

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/c0220f038f95477e8d346af5a03d94d7.html )

Kind Regards,

Timo Wagner

Share
10 |10000 characters needed characters left characters exceeded