Diagnostics
Product: DataMigrator
Release: 8205
Primary OS: Windows
Solution Date:
Symptom
(FOC1400) SQLCODE IS 40000 (HEX: 00009C40) XOPEN: 42000
(FOC1500) (40000) [42000] Error while compiling statement: FAILED:
(FOC1500) RuntimeException Char length 500 out of allowed range [1, 255]
(FOC1414) EXECUTE IMMEDIATE ERROR.
(ICM18040) Return Code = 1414
Problem
The user receives the error messages above using a DataMigrator Flow that loads a Hive target when the length of a character field is greater than 255.
Solution
The target transformation for the field defined it as a fixed format. However, Hive does not support large character formats that are fixed. It must be a variable length. Specifying a variable-length format resolved the issue.