Skip to Content

HANA SDI - Remote Subscription on Oracle to clean up

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 06, 2017 at 10:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 12:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded