Operation failed: 500 The call failed on the server; see server log for details -- For more information see your log file

Highlighted
Five Stars

Operation failed: 500 The call failed on the server; see server log for details -- For more information see your log file

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)

Moderator

Re: Operation failed: 500 The call failed on the server; see server log for details -- For more information see your log file

Hello,

I saw this issue before and it seems to be a random case. This issue will appear when I set a license.

Are you getting this issue when click generate in job Conductor?

Best regards

Sabrina

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Operation failed: 500 The call failed on the server; see server log for details -- For more information see your log file

Hello,

I can not enter the admin console.
This problem appears when I want to update the tocken because we do it manually.
When I validate this tocken, I have this error message.

 

Regards,

vincent

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog