When loading SQL server for the first time you may receive an error like:
[SOURCE_CAPTURE ]W: Capture functionalities could not be set. RetCode: SQL_ERROR SqlState: 42000 NativeError: 20026 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The publication 'AR_PUBLICATION_0000#' does not exist. Line: 1 Column: -1 (sqlserver_log_utils.c:1822)
Where # is some number representing a publication that Replicate has attempted to create and then reference.
Environment
Qlik Replicate
SQL Server Source
Resolution
1) Add the user that Replicate is using to interface with SQL Server to the sysadmin role 2) Let Replicate create the publication by restarting the task. This can be either a fresh start or resume as the first thing Replicate does is check for publication and articles and will create them if they do not exist. 3) Optional: remove the user from the sysadmin role
Cause
Replicate cannot find this publication as it failed to create it. Some SQL Server instances will have competing security rules that prevent the standard install of Replicate from creating the publication.
