BigQuery Error: Field iMessageType has changed type from INTEGER to BOOLEAN
In Adobe Campaign Classic, if you receive a BigQuery error when attempting to insert an INT8 bit data type from Adobe Campaign Classic to GCP BigQuery database, you should update the ODBC driver to the latest version.
Description description
Environment
-
Campaign
-
Campaign Classic Hosted
-
Campaign Classic On-premise
Issue/Symptoms
When trying to insert a INT8 Bit data type from Adobe Campaign Classic to GCP BigQuery Database, an error occurs:
[ BigQuery] Cloud SDK error: BigQuery error in load operation: Provided Schema does not match Table skyuk-uk- marketing-pres-dev:uk_pub_adobefda_is.wkf1385981793_44_1_0. Field iMessageType has changed type from INTEGER to BOOLEAN
There seems to be a problem in BigQuery with implicit conversions between integer and boolean data types.
Resolution resolution
Solution:
There are two ways to resolve this:
-
For the older versions of Open Database Connectivity (ODBC), this issue can be resolved by adding capability
retainNumericBoolean="true"inside:Administration
>Platform>Options>WdbcCapabilities_BigQuery -
The update of the ODBC driver to the latest version can also fix this issue.
The Simba ODBC driver made some changes with the boolean type.