# Common Error Messages **URL:** https://community.holistics.io/c/tips-hacks/error-messages/10.md [Latest](https://community.holistics.io/latest.md) · [Categories](https://community.holistics.io/categories.md) · [Tags](https://community.holistics.io/tags.md) --- ## [MySQL Error: This measure must be an aggregation / A Measure must be aggregated](https://community.holistics.io/t/mysql-error-this-measure-must-be-an-aggregation-a-measure-must-be-aggregated/452)
**Author:** [@anthonytd](https://community.holistics.io/u/anthonytd)\ **Replies:** 0\ **Last updated:** [September 25, 2020, 7:20am UTC](https://community.holistics.io/t/mysql-error-this-measure-must-be-an-aggregation-a-measure-must-be-aggregated/452 "2020-09-25T07:20:09Z")
Since we haven’t optimized our MySQL Data Modeling to work with SQL mode ONLY\_FULL\_GROUP\_BY disabled, the measure couldn’t be validated. If you are facing this error, please try to enable this SQL mode ONLY\_FULL\_GROU… --- ## [CSV Import Error - invalid byte sequence in UTF-8](https://community.holistics.io/t/csv-import-error-invalid-byte-sequence-in-utf-8/45)
**Author:** [@vincent](https://community.holistics.io/u/vincent)\ **Replies:** 1\ **Last updated:** [September 8, 2020, 11:08am UTC](https://community.holistics.io/t/csv-import-error-invalid-byte-sequence-in-utf-8/45 "2020-09-08T11:08:18Z")
Sometimes when importing a CSV, you may run into an error message like this. Status: failure - \*0.01 secs\* \[ \[2018-03-13\](tel:1234567)T08:22:44.340Z \] ERROR - invalid byte sequence in UTF-8 - This error typically hap… --- ## [ERROR: column "error\_not\_selected" does not exists in](https://community.holistics.io/t/error-column-error-not-selected-does-not-exists-in/41)
**Author:** [@triet.pham](https://community.holistics.io/u/triet.pham)\ **Replies:** 1\ **Last updated:** [February 7, 2020, 10:54am UTC](https://community.holistics.io/t/error-column-error-not-selected-does-not-exists-in/41 "2020-02-07T10:54:05Z")
Problem Sometimes, when using Holistics, you would see the error message like this ERROR: column "error\_not\_selected" does not exists in or ERROR: invalid input syntax for integer: "opt\_1" LINE 6: where id = 'opt\_1' … --- ## [Holistics Internal Server Error](https://community.holistics.io/t/holistics-internal-server-error/39)
**Author:** [@anthonytd](https://community.holistics.io/u/anthonytd)\ **Replies:** 0\ **Last updated:** [November 28, 2018, 2:08pm UTC](https://community.holistics.io/t/holistics-internal-server-error/39 "2018-11-28T14:08:33Z")
There are some reasons that might cause this error: In your Visualization Settings, there is a value in Legend which is longer than 64 characters Use SUBSTRING in your query to truncate your string to under 64 charac… --- ## [BigQuery: Can not query from table whose source is Google Sheet](https://community.holistics.io/t/bigquery-can-not-query-from-table-whose-source-is-google-sheet/30)
**Author:** [@triet.pham](https://community.holistics.io/u/triet.pham)\ **Replies:** 0\ **Last updated:** [November 15, 2018, 4:04am UTC](https://community.holistics.io/t/bigquery-can-not-query-from-table-whose-source-is-google-sheet/30 "2018-11-15T04:04:41Z")
When you are querying data from BigQuery and encounter this error Exec SQL failed: \[{"message" : "Not found: Files /gdrive/id/......", "reason =\> notFound"}\] It looks like the table is linked to a Google Sheet and you … --- ## [Report Sometimes Return: "ERROR: canceling statement due to conflict with recovery"](https://community.holistics.io/t/report-sometimes-return-error-canceling-statement-due-to-conflict-with-recovery/22)
**Author:** [@huy](https://community.holistics.io/u/huy)\ **Replies:** 0\ **Last updated:** [November 8, 2018, 6:39am UTC](https://community.holistics.io/t/report-sometimes-return-error-canceling-statement-due-to-conflict-with-recovery/22 "2018-11-08T06:39:01Z")
Hi everyone, This is one of the common issues that we receive from our customers, and usually pointing Holistics directly to their production cluster. Basically your report will run for a while, and then return this err…