topic Re: SQL server endpoint encountering error in Qlik Replicate

SQL server endpoint encountering error

desmondchew — Tue, 26 Sep 2023 01:27:39 GMT

We received an email alert from Qlik Replicate saying a task has the following error. The issue happens frequently though is not causing any issues. The task was able to resume, did not cause error.

Please share how to resolve this.

=========

TASK_AA replication task encountered the following error:

Stream component 'st_0_TASK_AA' terminated Stream component failed at subtask 0, component st_0_TASK_AA Error executing source loop Endpoint is disconnected Encountered an unexpeceted error.

do_organize_fetched_row(...) failed in executing mssql_get_table_tlog_attributes(...)

Failure in querying for compression setting for table 'dbo.MASTERTABLE'

RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Query timeout expired Failed (retcode -1) to execute statement: '

select p.data_compression from sys.partitions p,sys.objects o where p.object_id = o.object_id

and schema_name(o.schema_id ) = N'dbo'

and o.name=N'MASTERTABLE'

Re: SQL server endpoint encountering error

SushilKumar — Tue, 26 Sep 2023 04:55:55 GMT

Hello Team,

Thanks for reaching out to Qlik via Qlik Community Support page. As the mentioned Error "RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Query timeout expired Failed (retcode -1) to execute statement: '"

It seems where ever the query is executed ( Source/Target endpoint) QR task is not able to get the info in defined time limit and through the error about timeout expired Failed (retcode -1) to execute statement:

However, there are other factor which may pertain to it. hence request you to engage TSE vIa Support case for further analysis.

Request you to upload the diagnostic package/log/DDL and attached the relevant info/files to the case.

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Regards,

Sushil Kumar

Re: SQL server endpoint encountering error

sureshkumar — Tue, 26 Sep 2023 05:02:08 GMT

Hello @desmondchew

Apart from Sushil kumar suggestion,

please add below internal parameter at Source/Target endpoint depending on where you getting this error

cdcTimeout = 1800 executeTimeout = 600 loadTimeout = 3600 (If you've already enabled these parameters means please increase the value by 2x)

Click OK to close the window. Then click Save on the endpoint. The tasks that use this endpoint will need to be stopped & resumed before the new settings will take effect.

Regards,

Suresh

Re: SQL server endpoint encountering error

desmondchew — Tue, 26 Sep 2023 08:07:59 GMT

The error is happening at the source. SQL Server on premise 2019.

I have enabled the suggested internal parameters and will continue to monitor.

Desmond

Re: SQL server endpoint encountering error

Nitesh_22 — Wed, 11 Sep 2024 19:10:04 GMT

@desmondchew - did you ever resolve this issue ? Did the parameter change help ?

Re: SQL server endpoint encountering error

desmondchew — Thu, 12 Sep 2024 02:47:44 GMT

After adding the timeout internal parameter, the issue seems to resolve. I will need to monitor for a while.

Thank you.
Desmond

Re: SQL server endpoint encountering error

Dana_Baldwin — Thu, 12 Sep 2024 15:35:15 GMT

Hi @desmondchew

I'm glad to hear the timeout setting helped. I generally consider an increase to timeout values as a work around, the root cause is generally a performance or environment issue on the endpoint, network, or etc.

Thanks,

Dana