Error - F_JT1478 Integration Update Affected 937 Rows, Less Than the 938 Rows Expected

Edit

Documentation: Error - F_JT1478 Integration Update Affected 937 Rows, Less Than the 938 Rows Expected

Error: F_JT1478: Integration Update Affected 937 Rows; Less Than the 938 Rows Expected

Issue

The following error appears:

F_JT1478: Integration update affected 937 rows; less than the 938 rows expected.

Environment

DSS v6.1.0/28
Source: SQL Server
Target: Snowflake

Resolution

To resolve this issue, do the following:

Define the environment variable DSS_COMPARE_VARCHAR_PADDING to both the source and the target locations.

Action Parameter

Environment Name=DSS_COMPARE_VARCHAR_PADDING
Value=1
Activate the channel with jobs.

Action	Parameter
Environment	Name=DSS_COMPARE_VARCHAR_PADDING Value=1

The DSS_COMPARE_VARCHAR_PADDING environment variable can accept only the following values:

DSS_COMPARE_VARCHAR_PADDING = 1: Consider the padded/trailing spaces when comparing varchar values.
DSS_COMPARE_VARCHAR_PADDING = 0: Ignore the padded/trailing spaces when comparing varchar values.
DSS_COMPARE_VARCHAR_PADDING=-1 default: Consider the padded/trailing spaces based on the internal data type used for the varchar when comparing varchar values.

Cause

The table has two versions of the same varchar key: one with and one without trailing space.

By default, we preserve the trailing space in varchar, and updates for characters with trailing space will appear in the burst table.

Snowflake doesn't consider trailing spaces significant. Updates for characters with trailing space will not exist in Snowflake because it only has a row with a key value that doesn't have trailing space. As a result, it will appear that a row is missing.