Ask Your Question
1

SQL server to Kafka pipeline cannot fetch tables

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

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

Comments

Can you please share your pipeline configuration JSON somewhere?

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

2 Answers

Sort by ยป oldest newest most voted
1

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

Jisun gravatar image

found potential issue here: https://issues.streamsets.com/browse/... the fix will be in 2.8

edit flag offensive delete link more
0

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

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: https://streamsets.com/documentation/...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 123 times

Last updated: Sep 18 '17