Skip to Content
avatar image
Former Member

CREATE REMOTE SUBSCRIPTION is not permitted on remote source

Hi,

We are trying to bring real time data from Oracle db into HANA using SDI. For this, first we have created a remote source and able to connect with Oracle and created virtual tables on top of it and able to see data preview for virtual tables.

After this we created a flowgraph file with option "Activation as Task Plan". In the container node properties selected Generator option as "Task", provide the target schema name and checked the "Realtime Behaviour".

Created a flowgraph with one data source with the virtual table created above and target as Data Sink used a local which i have already created a local table same as my source table.

In the source properties also i have checked the real time check box., save my change and tried to activate it but getting below error.

Here ORACLE is my remote source name.

Operation is not permitted: CREATE REMOTE SUBSCRIPTION is not permitted on remote source: ORACLE: line 1 col 1 (at pos 0)

I have executed below sql still we are getting the same error

GRANT CREATE VIRTUAL TABLE, CREATE REMOTE SUBSCRIPTION ON REMOTE SOURCE "ORACLE" TO _SYS_REPO;

Can someone help me with to overcome this problem.

Note: We dont have Web IDE to do this activity using replication task.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 30 at 02:47 PM

    First thing I want to confirm is that you are using OracleLogReaderAdapter, not the Oracle ECC adapter.

    Then I want to confirm that you have run the Oracle setup SQL, provided with the dpagent installation:

    Thanks
    Jeff

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 02 at 04:04 AM

    Please try it:

    GRANT CREATE REMOTE SUBSCRIPTION
    ON REMOTE SOURCE "YOUR_REMOTE_SOURCE_NAME" TO _SYS_REPO WITH GRANT OPTION;

    William

    Add comment
    10|10000 characters needed characters exceeded