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!