topic Re: Experiancing frequent time out in in Qlik Replicate

Experiancing frequent time out in

PraveenP — Thu, 29 Feb 2024 20:21:01 GMT

Hi ,
We are facing time out issue get below error frequently in replicate task we are using SAP HANA as source and Microsoft Azure Sql database as target

Target: T___12 (Microsoft Azure SQL Database) Error Code: 1022502 Error details: Error cleaning the log Failed to execute 'Cleanup' statement.

RetCode: SQL_ERROR SqlState: S1000 NativeError: 613 Message: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;613 execution aborted by timeout Failed (retcode -1) to execute statement: 'DELETE FROM "x"."attrep_cdc_changes" WHERE "EVENT_TIME" < ? AND "INDX" < ?'

Please help on this issue.

Re: Experiancing frequent time out in

Dana_Baldwin — Thu, 29 Feb 2024 20:54:36 GMT

Hi @PraveenP

The issue appears to be related to target database performance or network performance between Replicate and the target. There are timeout values you can specify in the target endpoint, Advanced tab, Internal Parameters:

cdcTimeout, default 600 seconds

executeTimeout, default 120 seconds

loadTimeout, default 1200 seconds

Increasing these to 3x or 4x the default may help, but it is a work around. You may need to increase the values further or find the root cause of the performance issue to resolve it.

You can type in the parameters by name (case sensitive) or you can enter an exclamation point and scroll down to select each one.

After your edits, click OK to close the window, click save on the endpoint, and then start/resume the tasks that use this endpoint so they go into effect (endpoints are only read/processed upon task startup).

Hope this helps!

Dana

Re: Experiancing frequent time out in

PraveenP — Thu, 29 Feb 2024 21:26:31 GMT

Hi @Dana_Baldwin ,
We are facing issue from Source SAP HANA side,

RetCode: SQL_ERROR SqlState: S1000 NativeError: 613 Message: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;613 execution aborted by timeout Failed (retcode -1) to execute statement: 'DELETE FROM "x"."attrep_cdc_changes" WHERE "EVENT_TIME" < ? AND "INDX" < ?'

Re: Experiancing frequent time out in

Dana_Baldwin — Thu, 29 Feb 2024 21:33:18 GMT

Hi @PraveenP

I apologize, my mistake.

There are two timeout parameters you can set on the source endpoint in the same manner as described above:

executeTimeout, default 60 seconds

loadTimeout, default 1200 seconds

Please check with the source DBA on performance.

Thanks,

Dana

Re: Experiancing frequent time out in

sureshreddyaddula — Mon, 24 Feb 2025 16:25:04 GMT

Hi Praveen,

We are running into similiar error where HANA is source. could you please share the details of how it was resolved? We tried adjusting the parameters, but unfortunately, it did not resolve the problem.