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!

[Mohamed_Sadek]

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"