Skip to Content
0

CREATE REMOTE SUBSCRIPTION is not permitted on remote source

Apr 29 at 08:17 AM

153

avatar image
Former Member

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.

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

1 Answer

Jeff Kresse
Apr 30 at 02:47 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded