Ask Your Question

SQL server to Kafka pipeline cannot fetch tables

asked 2017-09-15 02:07:04 -0500

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to connect SQL server to Kafka with the help of SQL Server Change Tracking Client.The table specified by me has Change Tracking enabled. I get the following error:

"SQL Server Change Tracking Client 1 JDBC_66 - No Tables matches the configuration in the origin. : tableJdbcConfigBean.tableConfigs"

edit retag flag offensive close merge delete


Can you please share your pipeline configuration JSON somewhere?

jeff gravatar imagejeff ( 2017-09-15 12:15:46 -0500 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2017-09-19 12:07:25 -0500

Jisun gravatar image

found potential issue here: the fix will be in 2.8

edit flag offensive delete link more

answered 2017-09-18 16:52:49 -0500

Jisun gravatar image

Can you also check if the min_valid_version of the table is less then or equal to the currentVersion?

i.e. min_valid_version from sys.change_tracking_tables t where t.object_id = object_id(%tableName) <= select change_tracking_current_version()

Also, You can also modify the log level to "DEBUG" to check if the tables are selected or not:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-15 02:07:04 -0500

Seen: 175 times

Last updated: Sep 18 '17