Warning: W_JT0704: Coercion Error (Nulls) Affected X Rows of Table

Issue

Refresh completes as expected. However, the following warning appears:

Warning: W_JT0704: Coercion error (nulls) affected X rows of table <table_name>, columns <column_names>.

Environment

• HVR 6
• Channels that have the TableProperties action defined with the CoerceErrorPolicy parameter.

Resolution

To resolve this issue, do the following:

1. Modify the applicable ColumnProperties action to include the Nullable parameter.
2. Activate the channel.
3. Run the Refresh job again.

Cause

This issue occurs when there are one or more ColumnProperties actions without Nullable parameters in your channel. This causes HVR to create the target's table column with a NOT NULL constraint even if the source table column does not include a NOT NULL constraint.