Error: F_JD22C1: Unexpected Datatype ‘0’ Encountered for Column

Issue

While activating a Redshift target channel, the following error appears:

F_JD22C1: Unexpected datatype '0' encountered for column <column_name> of table <table_name> while binding Redshift output data.

Environment

• DSS 6
• Target database: Redshift

Resolution

To resolve this issue, downgrade the ODBC driver for Redshift to version 1.5.7.

Cause

This issue is caused by the ODBC driver for Redshift version 2.0.07 and above.