Database CDC adapter error if 'Perform Enable CDC Calls' is unchecked

Database CDC adapter error if 'Perform Enable CDC Calls' is unchecked

book

Article ID: KB0076875

calendar_today

Updated On:

Products Versions
TIBCO Streaming 10.4.4 and earlier

Description

When using the Database Change Data Capture adapter with a Microsoft SQL Server, you may see the following error if the 'Perform Enable CDC Calls' option is NOT selected in the adapter properties:

2019-09-23 13:27:53.310+0400 [OperatorThread(default.SQLServerCDC.reader)] WARN SQLServerCDC - Error reading capture activity between LSNs 0000002700001D600003 and 0000002700001D600003, sql: SELECT __$operation AS "_Operation", __$start_lsn AS "_CommitSeqNum", __$seqval AS "_SubSeqNum", __$update_mask AS "_UpdateMask" null FROM cdc.fn_cdc_get_all_changes_customers_capture_instance(?, ?, 'all'): Incorrect syntax near the keyword 'null'.
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'null'."

 

Resolution

This is a known defect which will be addressed in a future release. 

To work around this issue, you may leave the 'Perform Enable CDC Calls' option selected even though you have enabled CDC in MS SQL Server, as no changes to the database configuration will be attempted once the adapter detects that CDC is already enabled.

Issue/Introduction

Database CDC adapter error if 'Perform Enable CDC Calls' is unchecked