Qlik Replicate SAP Hana end point - Error insufficient privilege, Failed to create statement: 'SELECT 1 FROM "SAPABAP1"."DD03L"

[vinodn1989]

Trying to connect to SAP HANA End Point as Source.

Facing issue:

SYS-E-HTTPFAIL, Failed to create statement: 'SELECT 1 FROM "SAPABAP1"."DD03L"'.
SYS,GENERAL_EXCEPTION,Failed to create statement: 'SELECT 1 FROM "SAPABAP1"."DD03L"',RetCode: SQL_ERROR SqlState: S1000 NativeError: 258 Message: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: Detailed info for this error can be found with guid '662A53E877994346902B0196A1BDFE90'

Screenshot for reference:

[OritA · Accepted solution]

Hi, 

Please review the SAP HANA required permission section in the Replicate documentation (see link below) and make sure you have added all the pre-reuisite permissions. If after reviewing, you still face an issue please open a salesforce case and add to the case the resrv.log + the task diagnostic package so we can review the setting and troubleshoot the cause of the problem. 

https://help.qlik.com/en-US/replicate/November2024/Content/Global_Common/Content/SharedReplicateHDD/...

Regards,

Orit

[vinodn1989 · Accepted solution]

After giving the full permissions on the schema SAPABAP1, It worked. Since it is test environment, I gave full permissions for now.

Solution would be - 

• Grant SELECT and TRIGGER on the SAP schema containing the selected source tables to the user specified in the SAP HANA source endpoint.