Ask Your Question

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

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

manza gravatar image

updated 2018-05-03 15:05:03 -0500

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

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

foxgarden gravatar image

Hi all, I hava a SqlServer2008R2, when I use 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:

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

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

metadaddy gravatar image

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

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


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

Seen: 2,696 times

Last updated: May 03 '18