Hello Team,
We are using Open source BI Helical Insight version 6.1. We recently moved our backend database from Derby to MySQL 8.
After migration, we are not able to create new metadata. When we try to expand any database connection to see tables, we get this error:
“Could not obtain cache”
In the logs, we see this error:
“Data too long for column ‘cache_value’”
How can we fix this?
Thanks,
Vema.
Hello Vema,
This issue is happening because MySQL is not allowing large data to be stored in the cache_value column.
When Helical Insight creates metadata, it tries to save cache data in this column. But the column size is too small, so the insert fails.
Solution:
You need to increase the size of the cache_value column.
Run the following SQL query on your MySQL database:
ALTER TABLE generic_cache
MODIFY cache_value BLOB;
What this does:
After this change, you should be able to create metadata without errors.
Thank You,
Helical Insight.