11-23-2022 11:54 PM
Hi,
OS : Ubuntu
Trying to install Incorta with CMC in CMC getting this error .
com.incorta.database.upgrade.UpgraderException: INC_05200000: Failed to update the metadata database. Upgrade db metatdata failed due to DB script number [52], query has an issue [CREATE TABLE `DASHBOARD_PERSONALIZATION. Please find attached full error stack.
Solved! Go to Solution.
11-28-2022 05:22 PM
We need to do following changes to resolve this error. In /etc/mysql/mysql.cnf file. Take a backup first of mysql.cnf . At first line add [mysqld] and at end add
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
[mysqld]
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Save the changes , start the mysql with systemctl stop mysql.service and then start it with systemctl start mysql.service . You can see the status of mysql.service by systemctl status mysql.service
Once mysql database is up and running, you can drop the "Incorta_metadata" and then recreate it and then run the CMC steps once again. It will run without any issues this time.
11-29-2022 09:42 AM
@Rajanish - Thanks for sharing the solution back to the thread!
05-31-2023 08:56 AM
Just a small addition that we don't need to delete the meta db the trick is in MYSQL version
Incorta currently uses ‘0000-00-00 00:00:00'
as default creation date. This value isn’t permitted in the recent versions of MySQL. We need to disable two modes: NO_ZERO_DATE
and NO_ZERO_IN_DATE
from sql mode. To do so, open the main configuration file as root:
sudo vim /etc/mysql/mysql.cnf
and then add the following lines at the end of the file for mysql 5.6
[mysqld]
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
for MySQL 8.0 append this instead otherwise MySQL won’t start/restart
[mysqld]
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"