ALTER_REMOTE_SUBSCRIPTION RESET returns error

[former_member594385]

Problem description: Error while executing the replication task in web based development workbench with Load behavior as Initial+real time or real time.

Details:

I am trying to load data (KNA1,VBAP,VBAK tables)from SAP ECC to HANA using SDI replication task.

I am able to activate the replication task. but while running getting below error.

Could not execute 'ALTER REMOTE SUBSCRIPTION "GSAP_ECC_EIM"."SUB_KNA1" RESET' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Could someone help, which privileges required to resolve the issue.

Note: The User has ALTER,PROCESS REMOTE SUBSCRIPTION EXCEPTION, CREATE REMOTE SUBSCRIPTION privileges.

[jeffrey_kresse]

Not sure if you are referring to the application privileges or some other security object. Ensure your user has application privilege: sap.hana.im.dp.monitor::AlterRemoteSubscription

[former_member594385]

Hi Jeff,

my ID has sap.hana.im.dp.monitor::AlterRemoteSubscription application privilege assigned,

the above issue is because of Minimal supplemental logging at source system side, to enable the delta data load, which requires ALTER DATABASE ENABLE SUPPLEMENTAL LOGGING statement to be executed.

thanks for the information.