Failed to update a row in table yyy.xxxxxxxxxx.
Database operation failed.
A SQL exception has occurred. The SQL error code is '0'. The SQL state is: ISCDC. The error message is:
A SQL exception has occurred. The SQL error code is '102'. The SQL state is: HY000. The error message is:
[CDC][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'WHERE'
Columns mapped to initial values should not be part of Primary key. Derived expressions
should be used instead
Resolving the problem
Columns that are part of primary key are not allowed to be mapped to initial values. Derived expressions should be used instead to split data coming from different sources into one target table. Initial values are not part of where clause and are not modified by the product after insert. They are considered unmapped columns. Please review the documentation regarding initial values.