Ask Your Question
1

JDBC_78: The column name __$command_id is not valid?

asked 2018-04-24 05:30:55 -0600

manza gravatar image

updated 2018-05-03 15:05:03 -0600

metadaddy gravatar image

I am trying a pipeline with the SQL Server CDC Client origin and Hadoop FS as destination. When I run the pipeline I am getting JDBC_78: The column name __$command_id is not valid. I have set up the configuration as per the documentation; any help is appreciated.

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
0

answered 2018-11-20 03:49:49 -0600

foxgarden gravatar image

Hi all, I hava a SqlServer2008R2, when I use 2.7.2.1 it is OK to CDC. But after updating to 3.5.2, I meet the same issue. I'm sure this is caused by a bug of StreamSets: https://github.com/streamsets/datacol...

Because in SqlServer2008, cdc tables do not have a __$command_id column. You should check the version of sqlserver, then decide the columns for JDBC.

Btw, I'm in China so it is very difficult to sign this site's account because of the Great Firewall. Could you remove the validation image or change another provider...

edit flag offensive delete link more
0

answered 2018-05-03 15:03:25 -0600

metadaddy gravatar image

updated 2018-05-03 15:03:33 -0600

This seems to be an issue with SQL Server - one user was able to get around this error by applying SQL Server 2012 SP3 CU 10, which includes a fix for KB4038210. Let us know if this fixes the issue for you!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-24 05:30:55 -0600

Seen: 809 times

Last updated: May 03 '18