Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

How to upgrade #4556

jintaeson ·

Hi,

current version : 9.0.27
new version : 13.0.44

I am currently trying to upgrade to version 13.0.44.
When running the ./bin/upgrade.sh script, the following error occurs in the database integration part. Is there a solution?
And is “qb_conf_err_notify” a field that actually exists?

2024-02-22 09:43:26,886 ERROR >>> Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'configurat0_.qb_conf_err_notify' in 'field list'

error log:

2024-02-22 09:43:26,880 ERROR >>> Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not extract ResultSet
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186)
2024-02-22 09:43:26,881 ERROR >>> at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:275)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:716)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.type.EntityType.resolve(EntityType.java:502)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:170)
2024-02-22 09:43:26,882 ERROR >>> at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:144)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1115)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.processResultSet(Loader.java:973)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.doQuery(Loader.java:921)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.doList(Loader.java:2554)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.doList(Loader.java:2540)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
2024-02-22 09:43:26,883 ERROR >>> at org.hibernate.loader.Loader.list(Loader.java:2365)
2024-02-22 09:43:26,885 ERROR >>> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
2024-02-22 09:43:26,885 ERROR >>> at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
2024-02-22 09:43:26,885 ERROR >>> at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
2024-02-22 09:43:26,885 ERROR >>> at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
2024-02-22 09:43:26,885 ERROR >>> at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
2024-02-22 09:43:26,885 ERROR >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.exportEntity(DefaultDataManager.java:876)
2024-02-22 09:43:26,885 ERROR >>> at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.exportData(DefaultDataManager.java:847)
2024-02-22 09:43:26,885 ERROR >>> at com.pmease.quickbuild.persistence.SessionInterceptor.invoke(SessionInterceptor.java:49)
2024-02-22 09:43:26,885 ERROR >>> at com.pmease.quickbuild.Quickbuild.exportData(Quickbuild.java:1099)
2024-02-22 09:43:26,885 ERROR >>> at com.pmease.quickbuild.bootstrap.Bootstrap$3.execute(Bootstrap.java:168)
2024-02-22 09:43:26,885 ERROR >>> at com.pmease.quickbuild.Quickbuild$3.run(Quickbuild.java:817)
2024-02-22 09:43:26,886 ERROR >>> at java.lang.Thread.run(Thread.java:750)
2024-02-22 09:43:26,886 ERROR >>> Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'configurat0_.qb_conf_err_notify' in 'field list'
2024-02-22 09:43:26,886 ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
2024-02-22 09:43:26,886 ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
2024-02-22 09:43:26,886 ERROR >>> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2024-02-22 09:43:26,886 ERROR >>> at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
2024-02-22 09:43:26,886 ERROR >>> at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1025)
2024-02-22 09:43:26,886 ERROR >>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
2024-02-22 09:43:26,886 ERROR >>> ... 37 more
2024-02-22 09:43:27,245 ERROR Unable to upgrade specified installation due to above error

  • solved #2
  • replies 3
  • views 376
  • stars 0
robinshen ADMIN ·

This column is added after QB9. The correct upgrade approach is:
/path/to/qb13/bin/upgrade.sh /path/to/qb9

I just tried this and it works fine.

jintaeson ·

Thankyou for your answer.

I have a question.

Is there any way to exclude MeasurementData during upgrade?
INFO >>> 2024-02-26 12:49:37,332 INFO Importing from data file 'MeasurementDataR01s.xml.8'...

Importing takes too long.

robinshen ADMIN ·

If it is not important to you, you may simply purge various meansurement data from database before upgrade. Table names are starting with QB_MEASUREMENT_DATA_