Products | Versions |
---|---|
TIBCO Streaming | 10.4.4 and earlier |
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'."