Issue while migrating TAC database from 7.1 to 7.3

poojitha619 — Fri, 15 Nov 2024 23:30:48 GMT

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)

Re: Issue while migrating TAC database from 7.1 to 7.3

Anonymous — Thu, 18 Nov 2021 06:40:10 GMT

Hello,

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

Best regards

Sabrina

topic Re: Issue while migrating TAC database from 7.1 to 7.3 in Installing and Upgrading

Issue while migrating TAC database from 7.1 to 7.3

Re: Issue while migrating TAC database from 7.1 to 7.3