SQL Server CDC Client: The column name __$command_id is not valid.

  • 24 May 2022
  • 0 replies
  • 16 views

Userlevel 3

Issue:

Pipeline with SQL Server CDC Client failing with:

com.microsoft.sqlserver.jdbc.SQLServerException: The column name __$command_id is not valid.

 

Solution:

This seems to be an issue with SQL Server - https://ask.streamsets.com/question/1811/jdbc_78-the-column-name-__command_id-is-not-valid/:

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


0 replies

Be the first to reply!

Reply