Skip to Content
avatar image
Former Member

[HANA SDI]privilege error when activating replication task

Dear all

I have encountered an authorization error when setting SDI replication task.

I logged in web-based workbench as system user.

I created a new replication task (*.hdbreptask).

When I activate the task, an error occurred.

I attached screen shot.

Please kindly help me to resolve the issue.

Best regards, Yusuke Sugihara

sdi-20170410.png (5.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 10, 2017 at 11:33 PM

    Hello Yusuke,

    for the activation of any Repository objects it will use the internal Repo User _SYS_REPO.

    In this case this user is missing some privileges that you need to grant to _SYS_REPO first.
    For Reptasks this should be the CREATE VIRTUAL TABLE on top of the Remote Source as well as some permissions on the target schema (see https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS00/en-US/b37ba74df07145b9bcc52bedcb8c900d.html )

    Kind Regards,

    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded