Error saving data set on latest Ubuntu update

This message was edited 1 time. Last update was at 05/01/2011 10:32:42

[Solved]

Hi,

I've just upgraded to 2.7 and tried to modify a data source, which works without any problem. Trying to change a data set generates the same problem as before. Included the log from my SpagoBI 2.7 test with mysql.

[http-8080-1] 27 Nov 2010 21:21:19,721 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 27 Nov 2010 21:21:19,721 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 27 Nov 2010 21:21:19,732 ERROR org.hibernate.event.def.AbstractFlushingEventListener.performExecutions:299 - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.modifyDataSet(DataSetDAOHibImpl.java:294)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:419)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.service(DetailDataSetModule.java:132)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
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 it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:12

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(Thread.java:636)
Caused by: java.sql.BatchUpdateException: Incorrect arguments to mysqld_stmt_execute
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:64

at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193)
... 34 more
[http-8080-1] 27 Nov 2010 21:21:19,732 ERROR org.hibernate.event.def.AbstractFlushingEventListener.performExecutions:299 - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.modifyDataSet(DataSetDAOHibImpl.java:294)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:419)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.service(DetailDataSetModule.java:132)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
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 it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:12

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(Thread.java:636)
Caused by: java.sql.BatchUpdateException: Incorrect arguments to mysqld_stmt_execute
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:64

at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193)
... 34 more
[http-8080-1] 27 Nov 2010 21:21:19,738 ERROR it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.modifyDataSet:296 - Error while modifing the data Set with id 8
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.modifyDataSet(DataSetDAOHibImpl.java:294)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:419)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.service(DetailDataSetModule.java:132)
at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
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 it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:12

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(Thread.java:636)
Caused by: java.sql.BatchUpdateException: Incorrect arguments to mysqld_stmt_execute
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:64

at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193)
... 34 more
[http-8080-1] 27 Nov 2010 21:21:19,746 ERROR it.eng.spagobi.tools.dataset.presentation.DetailDataSetPublisher.getPublisherName:113 - error handler contains errors

Any one any clue, please????

Thanks in advance,
Freek

Anyone any clue?

In short again the problem.
If my system runs under ubuntu 10.10LTS and mysql latest updates.
- I save a datasource it goes ok.
- I save a dataset it gives an error.

if I copy my pack to a windows laptop and mysqldump and import the spagobi database in the windows mysql database.
- I save a datasource it goes ok.
- I save a dataset it goes ok.

The first error line that appears states 'Incorrect arguments to mysqld_stmt_execute'.

This happens at least in version 2.6 and 2.7.

Thanks in advance,
Freek

Hi Monia,

Would it be possible to post how the table looks like in your system. In another post I've mentioned that there are problems with the mysql update scripts and I hope that there is a difference. So a DESCRIBE spagobi.SBI_DATA_SET would be nice.

I've checked this problem also on another system meanwhile and I've found there the same problem. The difference with mine is that this is an Ubuntu 10.10 server rather than a desktop version.

Thanks in advance,
Freek

hey guys,

Not sure if this helps, but I stumbled across this post after receiving the same error message under similar circumstances whilst using Spring 3 and hibernate on Ubuntu 10.10 x86, when I run it on the redhat based server from my webhost it runs fine. Think I'll be connecting to the remote db server, and putting up with the latency,

.

Henry

Hi Henry,

Thanks for that. At least I know that if this escalates that there is an alternative. I'll certainly test it. And.... it's better for my ego that I'm not the only one experiencing this problem

Best regards,
Freek

hey,

I have found a solution: http://dev.joget.org/community/display/KB/Advanced+Installation+for+Apache+Tomcat+and+MySQL; works for me,

But not too sure about the exact details of SpagoWorld, or even what it is,

.

Henry

Hi,

Meanwhile the problem has been solved for me as well. I've added the port number to the jdbc url. After that it worked. Changing it back like it was, it kept on working. Strange... Perhaps an Ubuntu update has solved the problem and not the port number change it self.

Anyway... it's solved..

Thanks all,

Freek

Hi Freek,
please I ask you to open a new request on the forum, because your questions are different than the title of this post and we can not track them down.

Thanks in advance

Monia

This message was edited 1 time. Last update was at 05/01/2011 09:46:32

I expect you to open a new post for reply at your questions

Monia

Hi Monia,

No this change, so adding the port number to the URL, made the saving of the data set work. So this is not a new problem, it's the solution to the problem described in the subject. Meanwhile I've found out that it's not an Ubuntu update that caused it to be solved. Somehow the fact that the port number was once there seem to have solved the problem.

So there is no need to write a new problem since there is no new problem.

Best regards,
Freek

Sorry

No problem, I'm glad that you're watching the posts...

Best regards,
Freek