Handling Columns Added with the NOT NULL and DEFAULT Options to a SQL Server Source Table
Handling Columns Added with the NOT NULL and DEFAULT Options to a SQL Server Source Table
Previously, if you captured change data from a Microsoft SQL Server 2012 or later source, capture processing might fail with the following error message after an ADD
column_name
datatype
NOT NULL DEFAULT operation occurred on a source table:
PWX-15748 Invalid Capture data for table
schema
.
table_name
, column
column_name
. Found NULL data expected non-NULL.
PowerExchange processed the added columns after an Update or Delete occurred on the source, but the captured before image showed null values for the not-null columns.
In PowerExchange 10.1, PowerExchange populates the added columns in the before image with an appropriate default non-null value, which is based on the column datatype. PowerExchange then continues capture processing. You cannot change the default values that PowerExchange uses. If the use of these default values is not acceptable in your environment, you must rebuild the source table after the columns are added. Then restart CDC.
For more information, see the "Microsoft SQL Server Change Data Capture" chapter of the
PowerExchange CDC Guide for Linux, UNIX, and Windows