Error: No Authorization for Table/View NUMA_NODE_PREFERENCE_

Issue

Connections fail during setup tests or syncs with the following error:

Error while executing function /FIVETRAN/FETCH: ErrorCode=999 - No authorization for table/view NUMA_NODE_PREFERENCE_ in schema SYS in database LOCAL.

Environment

Connector: SAP ERP on HANA

Resolution

To resolve this issue, ask your SAP HANA administrator to grant the SAP user SELECT access to the SYS.NUMA_NODE_PREFERENCE_ object. For example:

GRANT SELECT ON SYS.NUMA_NODE_PREFERENCE_ TO <USERNAME>;

Then, rerun the setup test or sync. For the complete list of required SAP user permissions, see the SAP ERP (HANA) setup guide.

Cause

This issue occurs when the dedicated SAP user configured for your connection doesn't have permission to access the SYS.NUMA_NODE_PREFERENCE_ system object, which Fivetran uses to retrieve source metadata during connection validation and sync.