CREATE REMOTE SUBSCRIPTION is not permitted on remote source

[former_member576008]

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.

[werner_daehn]

Don't ask why and don't believe I am completely out of my mind but if all obvious reasons (especially using the odbc adapter instead of the SDI adapter and permissions as mentioned above) were checked and you get the error still, execute the statement via Hana Studio instead of XSC WebIDE Catalog Editor.

XSC's Catalog Editor does not use a JDBC connection but an older hdb.xsjs and there are a few side effects.

[william_andradebatista]

Please try it:

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

William

[jeffrey_kresse]

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:

• Oracle permissions & setup script - oracle_init_example.sql

Thanks
Jeff