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 , query has an issue [CREATE TABLE `DASHBOARD_PERSONALIZATION. Please find attached full error stack.
Solved! Go to Solution.
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
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.