HANA to HANA replication failing

[Former Member]

I'm trying to replicate a table from one of the Scale out HANA database to Single node HANA database. When I start the replication for a table it complains on no columns found for table. please find the attached error. Can someone please help.

[kishore_kumar59]

Hi Suresh

is this happening with all the tables? or only few tables?

check the table in source is it row or columnar table.

what is SLT system version and source and target HANA versions?

Regards

Kishore Ch

[Former Member]

Thank you for the response Kishore. It was a privilege issue and I got it figured out.

[Former Member]

We are facing the same error. Do you still remember which privilege was missing? I guess it was an missing privilege from the source database?

Cheers & thanks, Tim

[Former Member]

Hi Tim,

Below is the document link which has all the privileges that are needed for the HANA replication. Check out page 11.

https://help.sap.com/hana/SAP_HANA_Security_Guide_Trigger_Based_Replication_SLT_en.pdf

If you still have issues then you can enable authorization trace with the help of below note. It will help you to identify the privileges needed.

SAP NOTE - 1809199 SAP HANA DB: Debugging user authorization errors

Hope it helps,

Suresh