Error: Failure in setting a safeguard latch for task

[lyka]

When using SQL Server Source Endpoint, and you encountered the following error:

00003056: 2022-01-10T02:20:03 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Query timeout expired [1022502] (ar_odbc_stmt.c:4895)
00003056: 2022-01-10T02:20:03 [SOURCE_CAPTURE ]E: Failure in setting a safeguard latch for task '[ESJ0003]' / 'f0895f9f-c28f-cd42-bc06-b14dd1d5d7a7' / 'A' [1022506] (sqlserver_log_truncation_safeguard.c:212)
00003056: 2022-01-10T02:20:03 [SOURCE_CAPTURE ]E: Failure in setting a safeguard latch 'A' for task '[ESJ0003]' [1022506] (sqlserver_log_truncation_safeguard.c:1111)
00003056: 2022-01-10T02:24:03 [SOURCE_CAPTURE ]E: Failure in un-setting a safeguard latch for task '[ESJ0003]' [1022502] (sqlserver_log_truncation_safeguard.c:257)

Add the following two internal parameters into your source endpoint and increase the value respectively:

executeTimeout
cdcTimeout

For information on how to set Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for? 

If the TLOG backups are available for this source, a separate parameter can be used, however its use is not recommended without instruction by Qlik Support. This parameter prevents Qlik Replicate from creating a transaction on the source.

safeguardPolicyDesignator=None 

Environment

Qlik Replicate 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

[dhina]

What the above parameter will do?

safeguardPolicyDesignator=None

[Sonja_Bauernfeind]

Hello @dhina 

We're reviewing this article and the parameter provided (I have also updated the article with more information until then). Will update you as soon as we've looked into this further.

All the best,
Sonja 

[SwathiPulagam]

Hi @dhina ,

 If you add the internal parameter "safeguardPolicyDesignator set the values as None" then it will disable the safeguard table and there is a risk of truncating the LDF file.

Before adding this IP you have to make sure that the TLOG backups are available for Replicate and that they are in Native format so Replicate and start reading from the .trn file if the LSN does not exist in TLOG.

Thanks,

Swathi

[Reinie]

Just found this article.  In my case, the DBA was running the MSSQL Kill Sleeping Sessions job every hour.

My Qlik task was running with Prioritize Backup Log.  It appears it was idle for too long and was terminated by the Kill Sleeping Sessions job.  Resulting in the Error listed above.