CMC metadata creation failed 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

[Rajanish]

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.

[Rajanish · Accepted 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

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.

[JoeM]

@Rajanish - Thanks for sharing the solution back to the thread!