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 similar to the following:
[ BigQuery] Cloud SDK error: BigQuery error in load operation: Provided Schema does not match. 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.
Ask Questions In Our Experience League Campaign Community
If you have any questions you’d like answered about this topic, or read previous answered-questions, we invite you to view our Experience League Community blog post that includes this article, send us your questions and comments, and join our Experience League Campaign Community!