DBCC Page Error - Qlik Community

kennytranps

We received the following error for a table that does not have a primary key and would like to understand what conditions cause Qlik to execute the DBCC PAGE command. The replication user does not have the necessary permissions to run this command.

03761178: 2026-08-10T13:51:22 [TASK_MANAGER    ]I:  Task error notification received from subtask 0, thread 2, status 1022505  (replicationtask.c:3740)
03761331: 2026-08-10T13:51:22 [STREAM_COMPONEN ]E:  Failed (retcode -1) to execute statement: 'DBCC PAGE(litrockfms, 1, 3336884, 1) WITH TABLERESULTS;' [1022502]  (ar_odbc_stmt.c:4719)
03761331: 2026-08-10T13:51:22 [STREAM_COMPONEN ]E:  RetCode: SQL_ERROR  SqlState: 42000 NativeError: 2571 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User 'ADEEFP2_Repl_User' does not have permission to run DBCC PAGE. Line: 1 Column: -1 [1022502]  (ar_odbc_stmt.c:4724)
03761331: 2026-08-10T13:51:22 [SOURCE_CAPTURE  ]E:  Failed to execute statement: 'DBCC PAGE(litrockfms, 1, 3336884, 1) WITH TABLERESULTS;' [1022505]  (sqlserver_endpoint_capture.c:1933)
03761331: 2026-08-10T13:51:22 [SOURCE_CAPTURE  ]E:  Failed to lookup the column 'comment' of table 'dbo.reqaprv', stream position '0000b020:00023752:0003' [1022505]  (sqlserver_endpoint_capture.c:2089)
03761331: 2026-08-10T13:51:22 [SORTER          ]E:  The Transaction sorter. Cannot forward transaction [1022505]  (sorter_transaction.c:1020)
03761331: 2026-08-10T13:51:22 [SORTER          ]E:  Error executing data handler [1022505]  (streamcomponent.c:2048)
03761331: 2026-08-10T13:51:22 [TASK_MANAGER    ]E:  Stream component failed at subtask 0, component st_0_transaction_sorter  [1022505]  (subtask.c:1647)
03761331: 2026-08-10T13:51:22 [SORTER          ]E:  Stream component 'st_0_transaction_sorter' terminated [1022505]  (subtask.c:1818)
03761178: 2026-08-10T13:51:22 [TASK_MANAGER    ]W:  Task 'mssql-ls-EFIP-litrockfmsusar-8ee9c8d7' encountered a fatal error  (repository.c:6582)

Mohammed_Messaoudi

Hi team,

Qlik Replicate executes DBCC Page when its SQL Server source-capture process needs to inspect the physical contents of a database page in order to resolve information from a transaction-log record.

In your case, the sequence is:

Replicate reads a change from the SQL Server transaction log.
The log record does not contain enough logical information for Replicate to directly resolve the affected column/row.
Replicate therefore uses the physical page information from the log record.
It issues:DBCC PAGE(litrockfms, 1, 3336884, 1) WITH TABLERESULTS;
Replicate uses the result to determine the column/row information it needs.
Your replication account cannot execute DBCC PAGE, so SQL Server returns error 2571, and the capture process stops.

-mjl-

Can you confirm the source endpoint type and if ADEEFP2_Repl_User has been granted Sysadmin?

kennytranps

We are using Microsoft SQL Server endpoint, and the user doesn't have Sysadmin

-mjl-

Hi, I would double check the process for setting up a non-sysadmin user has been followed: https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedReplicateHDD/SQLSe...

If that is all in place and you still have issues then a Support ticket is recommended. Cheers!