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

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

vinodn1989 — Thu, 20 Feb 2025 03:01:26 GMT

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:

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

OritA — Thu, 20 Feb 2025 08:57:30 GMT

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/SAP-HANA/security_req_saphana.htm

Regards,

Orit

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

vinodn1989 — Mon, 24 Feb 2025 20:46:44 GMT

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.