Error: F_JG2918: Encountered Truncated Character While Encoding String

Issue

Capture or Refresh processes fail. The following error appears:

F_JG2918: Encountered truncated character while encoding string from UTF-16BE to UTF-8 for table.

Environment

• HVR 6
• Process: Capture or Refresh

Resolution

To resolve this error, do the following:

1. Define the TableProperties action with the following parameters for all locations in your channels:
   • CoerceErrorPolicy=WARNING
   • CoerceErrorType=ENCODING
2. Run Activate Replication with the following options selected.
   • Jobs
   • Table Enrollment

Cause

This error occurs when the Capture or Refresh process encounters non-UTF-8 encoded data in a column expected to contain UTF-8 data.

This may happen during data replication when we encode a string from one character set, such as UTF-16BE, to another, such as UTF-8, and the source string includes characters that cannot be properly encoded in the target character set.