Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, we are trying upgrade Talend from 7.1 to 7.3. While upgrading TAC admin database we are getting below error.
Task 'ExecutionHistoryCleanerMigrationOperation' 'before' part starts...
Task 'ExecutionHistoryCleanerMigrationOperation' 'before' part successfully ends
Task 'SchedulerMigration' 'before' part starts...
Task 'SchedulerMigration' 'before' part successfully ends
Task 'EmptyToken' 'before' part starts...
Task 'EmptyToken' 'before' part successfully ends
Task 'ChangeRoleName' 'before' part starts...
WARN: no 'Business user' or 'Guest' role name in userrole table.
Task 'ChangeRoleName' 'before' part successfully ends
Task 'JobPrmMigration' 'before' part starts...
org.hibernate.exception.GenericJDBCException: could not extract ResultSet
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2292)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2050)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2012)
at org.hibernate.loader.Loader.doQuery(Loader.java:953)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
at org.hibernate.loader.Loader.doList(Loader.java:2815)
at org.hibernate.loader.Loader.doList(Loader.java:2797)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2629)
at org.hibernate.loader.Loader.list(Loader.java:2624)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1859)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370)
at org.talend.migration.operations.JobPrmMigration.doOperationsBeforeDatabaseMigration(JobPrmMigration.java:112)
at org.talend.migration.AdministratorCenterMigration.doOperationsBeforeDatabaseMigration(AdministratorCenterMigration.java:112)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:270)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:51)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Connection reset
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1024)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
... 18 more
org.hibernate.TransactionException: Unable to rollback against JDBC Connection
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:122)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:304)
at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:142)
at org.talend.migration.operations.JobPrmMigration.doOperationsBeforeDatabaseMigration(JobPrmMigration.java:124)
at org.talend.migration.AdministratorCenterMigration.doOperationsBeforeDatabaseMigration(AdministratorCenterMigration.java:112)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:270)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:51)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.lang.Thread.run(Thread.java:748)
Hello,
Are you able to configure TAC db page normally and login 7.3 TAC?
Best regards
Sabrina