SQL server endpoint encountering error

[desmondchew]

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'

'.

[SushilKumar]

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/...

Regards,

Sushil Kumar

[sureshkumar]

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

[desmondchew]

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