Hello,
We already had this message and the Talend support asked us to stop Tomcat, delete the temporary files and restart Tomcat. These manipulations had corrected this anomaly.
But, this time, it does not work is the problem is that this version of Talend is no longer supported by the support (5.2.2). We still use it to retrieve our latest projects.
Here is the error message in the catalina.log file.
Thank you for your help because I do not know what to do to repair.
Regards,
Vincent
2019-05-17 07:25:11 ERROR TalendRemoteServiceServlet - !!!Cannot flush and commit transaction.!!!
org.talend.administrator.common.exception.DBException: !!!Cannot flush and commit transaction.!!!
at org.talend.administrator.common.persistence.hibernate.HibernatePersistenceAdapter.saveOrUpdate(HibernatePersistenceAdapter.java:253)
at org.talend.administrator.remoterepositorymgt.persistence.helper.LicenseHelper.saveOrUpdate(LicenseHelper.java:60)
at org.talend.administrator.common.util.license.LicenseUtil.setNewToken(LicenseUtil.java:256)
at org.talend.gwtadministrator.server.common.LoginServiceImpl.setNewToken(LoginServiceImpl.java:266)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at org.talend.gwttoolkit.server.TalendRemoteServiceServlet.processCall(TalendRemoteServiceServlet.java:81)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Caused by: org.talend.administrator.common.exception.DBException: !!!Cannot flush and commit transaction.!!!
at org.talend.administrator.common.persistence.hibernate.HibernateTransactionHolder.commitWithFlush(HibernateTransactionHolder.java:116)
at org.talend.administrator.common.persistence.hibernate.HibernatePersistenceAdapter.saveOrUpdate(HibernatePersistenceAdapter.java:244)
... 26 more
Caused by: org.hibernate.exception.GenericJDBCException: could not update: [License#338]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2360)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2242)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.talend.administrator.common.persistence.hibernate.HibernateTransactionHolder.commitWithFlush(HibernateTransactionHolder.java:108)
... 27 more
Caused by: java.sql.SQLException: Data size bigger than max size for this type: 228400
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
