Skip to Content

SDI: Can't activate the hdbreptask in an HANA to Trial HCP Realtime Replication Scenario

I'm trying to Setup a SDI Realtime Replication Scenario using the HANA Adapter. Following the Blog and the HANA Academy Video I got stuck during activation of

hdbreptask

[12:46:55] File /HANA2HCP/BALDAT.hdbreptask saved successfully. [12:46:55] Error while activating /HANA2HCP/BALDAT.hdbreptask:
[HANA2HCP:BALDAT.hdbreptask] User _SYS_REPO is missing privilege: CREATE VIRTUAL TABLE for REMOTE SOURCE HANA_YHX

The owner of the Remote Source is user SDI_USER and I gave every kind of privileges to _SYS_REPO. Still it's complaining about missing privileges.

Following the Blog of Ben Hofmans the Virtual Table approach is working fine. I'm just struggling in this Realtime Replication Scenario. Was anyone able to complete the Scenario for realtime table replication from HANA to HCP? Below the Settings for _SYS_REPO which should be sufficent to activate the hdbreptask:

sys-repo.jpg (131.3 kB)
sys-repo2.jpg (105.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 23, 2016 at 11:32 AM

    The solution was to add the missing privileges via SQL Statements i.e. via GRANT. Despite they claim it's available in the WEB Based Workbench this seems to be not true.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2017 at 02:21 PM

    If you rename the raplication task and put all in upper case it works properly.

    For example

    REPLICATIONTASK.HDBREPTASK

    Add comment
    10|10000 characters needed characters exceeded

    • Granting the missing authorization was definitively the solution. In my case, renaming the task only hide the error message but don't generate the procedure, table and virtual table. that should be created upon activation.