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

• HVR v6.1.0/28
• Source: SQL Server
• Target: Snowflake

Resolution

To resolve this issue, do the following:

1. Define the environment variable HVR_COMPARE_VARCHAR_PADDING to both the source and the target locations.

   Action	Parameter
   Environment	Name=HVR_COMPARE_VARCHAR_PADDING Value=1

2. Activate the channel with jobs.

The HVR_COMPARE_VARCHAR_PADDING environment variable can accept only the following values:

• HVR_COMPARE_VARCHAR_PADDING = 1: Consider the padded/trailing spaces when comparing varchar values.
• HVR_COMPARE_VARCHAR_PADDING = 0: Ignore the padded/trailing spaces when comparing varchar values.
• HVR_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.