Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

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

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Gerald_U
Support
Support

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

Last Update:

Dec 12, 2023 1:15:46 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 12, 2023 1:15:46 AM

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

Labels (1)
Version history
Last update:
‎2023-12-12 01:15 AM
Updated by: