Hello! *I was upgrading acs 4.20 to 4.22 acs and getting database schema issue. I was following instruction but did not succeed. Please find the logs.*
*ACS Version: 4.20* *KVM and MGMT running on Ubuntu 22* *mysql version: 8.0* *Java version: 17 * 2026-09-12 00:44:06,688 ERROR [o.a.c.f.c.d.ConfigurationDaoImpl] (qtp1404565079-22:[]) (logid:) DB Exception on: HikariProxyPreparedStatement@601710788 wrapping com.mysql.cj.jdbc.ServerPreparedStatement[3]: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated, configuration.group_id, configuration.subgroup_id, configuration.parent, configuration.display_text, configuration.kind, configuration.options FROM configuration WHERE configuration.name = x'70726f78792e6865616465722e766572696679' java.sql.SQLDataException: Cannot determine value type from string 'global' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:115) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1431) at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:830) at com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java) at com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:598) at com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:2078) at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1933) at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1894) at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1087) at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1062) at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:997) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) Any help would be really appreciated. Thank you!
