Issue while migrating TAC database from 7.1 to 7.3

[poojitha619]

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)

[Anonymous]

Hello,

Are you able to configure TAC db page normally and login 7.3 TAC?

Best regards

Sabrina