Connecting to an SQL AG with an MS-CDC task, the Qlik Replicate task log reads:
MSSQL-CDC source endpoint to Snowflake. We are encountering the following error: Failed in MS-CDC fitness check [1020101] (sqlserver_endpoint_capture.c:274). Error log and task definition is attached.
When the task connects to AG, it will go through the listener, and the task will not be able to determine the database ID.
Testing the query manually (not from within Qlik Replicate), the query uses the database name and functions as expected.
Resolution:
Using the internal parameter UseDBNameInsteadOfDBID forces the Fitness check to use the database name rather than the database ID.
To set UseDBNameInsteadOfDBID:
- Go to the Endpoint connection
- Switch to the Advanced tab
- Click Internal Parameters
- Add UseDBNameInsteadOfDBID as the parameter.
For more informatin on internal parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?
Environment
Qlik Replicate
SQL Server MS-CDC
