Error: No Datatype Specified for New Column

Issue

While attempting to refresh an HVR table, the process fails with the following error:

No datatype specified for new column '<column>' for table '<table>'.

Environment

HVR 6

Resolution

To resolve this issue, check whether the column referenced in the error exists in both the source and target tables.

If the column is missing from the target table, run Refresh with the Create Missing Target Tables and Alter or Recreate Tables with Incorrect Layout option selected. This causes HVR to alter or recreate the target table to match the channel's table definition, including the missing column. Alternatively, manually add the missing column to the target table manually using a SQL ALTER TABLE statement, then re-run Refresh again.

Cause

This issue occurs when a column defined in the HVR channel is missing from the target table. A misconfiguration during the data replication setup can cause the target table's schema to fall out of sync with the channel definition. When this happens, we can't determine the column's datatype during Refresh.