topic Re: SAP hana endpoint in Qlik Replicate

SAP hana endpoint

suvbin — Mon, 22 Apr 2024 07:41:20 GMT

Hi Team ,

we are facing below issue. But the task is running. and slowly changes are getting captured.

source is saphana

target : Azure sql db

00028240: 2024-04-22T01:28:14 [SOURCE_CAPTURE ]T: RetCode: SQL_ERROR SqlState: S1000 NativeError: 146 Message: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;146 Resource busy and NOWAIT specified: (lock table failed on vid=3, owner's lockMode: EXCLUSIVE, transID: 24627011275) [1022502] (ar_odbc_stmt.c:2816)

00028240: 2024-04-22T01:28:15 [SOURCE_CAPTURE ]T: Failed (retcode -1) to execute statement: 'LOCK TABLE "XXATT"."attrep_cdc_log" IN EXCLUSIVE MODE NOWAIT' [1022502] (ar_odbc_stmt.c:2810)

could you please let us know what could be done.

Thanks.

Re: SAP hana endpoint

john_wang — Mon, 22 Apr 2024 05:19:43 GMT

Hello @suvbin ,

Thanks for reaching out to Qlik Community!

Would you please check:

1. Are there many tasks using the same source SAP HANA endpoint?

2. Could you please increase the value for transaction consistency SAP HANA source endpoint Advanced tab, let's set it to 3000 (from default 60), a sample:

Hope this helps.

John.

Re: SAP hana endpoint

SachinB — Mon, 22 Apr 2024 05:48:03 GMT

Hello @suvbin ,

Just to add the above comments from @john_wang , The main issue is with while reading attrep_CDC_log file is getting locked by another task. Use log table: When this option is enabled, during the task, Replicate copies the changes from the attrep_cdc_changes table to the attrep_cdc_log table. It could be one of your task is already locked this table while reading and hence it's not allowing this task to capture the changes or can also be that at the server restart, replicate services started before the SAP HANA DB was initialized, hence the error.

Hope this answer find you well.

Regards,

Sachin B

Re: SAP hana endpoint

narendersarva — Tue, 23 Apr 2024 23:54:15 GMT

Hi @suvbin

As John mentioned, increase the transaction consistency to stop seeing such warnings. Replicate should be able to insert the records after the previous locks get released.

Thanks
Naren

Re: SAP hana endpoint

suvbin — Thu, 25 Apr 2024 01:23:39 GMT

Thank you for the resolutions. customer is trying to implement logstream task. Before it was individual tasks . Need to check if it resolved the issue