Error: F_JD5E0E Missing Input Encoding for Datatype VARCHAR

Issue

After upgrading, one specific Integrate job fails with the following error:

F_JD5E0E: Missing input encoding for datatype '2' [varchar] with CBuf string 'iv32.0:0' during coercion of column [hvr_tx_seq] of table [tablename].

Running the hvrmigratemissingencoding script does not resolve the issue.

Environment

• Product: Fivetran HVR 6.3.5/4
• Platform: Windows x64, 64-bit

Resolution

To resolve this issue:

1. In the HVR GUI, go to the TARGET location group.
2. For each affected table, add the following environment variables:
   • Name=HVR_COERCE_INVALID_ENCODING_CHECK_ENABLED
   • Value=0
   • Name=HVR_LOCALIZE_INVALID_ENCODING_CHECK_ENABLED
   • Value=0
3. Activate Replication for the channel with the following options selected:
   • Jobs
   • Table Enrollment
   • Replace all old Enrollment
4. If the error persists, stale transaction files from the upgrade process may be the underlying cause. Refresh the affected table or channel to align all components with the upgraded environment.

For guidance on missing input encoding for the VARCHAR data type, see F_JD5E12 Missing Input Encoding for Datatype.

Cause

This issue occurs when character columns are missing an encoding in the HVR catalog after an upgrade. This may happen when channels created in an older version that did not require explicit character encodings are later processed in a newer version that does.