Qlik Replicate: SQL Server Tasks Fails with Error: Invalid parameter passed to OpenRowset(DBLog, ...)

[Gerald_U]

CDC tasks fail with the:

00011720: 2023-11-27T12:21:34 [SOURCE_CAPTURE ]T: Failed (retcode -1) to execute statement: '
select top 1
[Current LSN],
[operation],
[Begin Time] as begin_time,
[End Time] as end_time,
getdate() as curr_time
from sys.fn_dblog ('0x00009396:00023df4:0001', NULL)
where operation in ('LOP_BEGIN_XACT','LOP_COMMIT_XACT')
' [1022502] (ar_odbc_stmt.c:2783)
00011720: 2023-11-27T12:21:34 [SOURCE_CAPTURE ]T: RetCode: SQL_ERROR SqlState: 42000 NativeError: 9005 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid parameter passed to OpenRowset(DBLog, ...). Line: 1 Column: -1 [1022502] (ar_odbc_stmt.c:2789)

Resolution

Reload the tasks.

or

Ask the DBA to restore the back up transaction log with the last LSN in question and then resume the task.

Cause 

When Qlik Replicate read from the online log it will use the fn_dblog function, the first parameter passed to the query is the last LSN that Qlik Replicate processed.

If there is no access to the backups and the log has been truncated, the error is thrown and the task fails. 

Environment

• Qlik Replicate 
• SQL Server