[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Error saving data set on latest Ubuntu update  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

[Solved]



Hi,

Recently I've updated my Ubuntu environment to 10.10, with java:
- java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.1) (6b20-1.9.1-1ubuntu3) OpenJDK 64-Bit Server VM (build 17.0-b16, mixed mode)
- Apache Tomcat
- SpagoBI 2.6.
- mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1

If I try to save a dataset that I created before the update, I get a 'Generic error'. Even if I open the dataset and immediately press the save button. It also occurs creating a new dataset.

The SpagoBI log shows the following messages:
[http-8080-1] 06 nov 2010 22:26:33,616 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 06 nov 2010 22:26:33,616 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 06 nov 2010 22:26:33,617 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:282)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:416)
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:127)
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:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
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] 06 nov 2010 22:26:33,617 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:282)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:416)
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:127)
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:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
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] 06 nov 2010 22:26:33,619 ERROR it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.modifyDataSet:284 - 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:282)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:416)
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:127)
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:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
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] 06 nov 2010 22:26:33,622 ERROR it.eng.spagobi.tools.dataset.presentation.DetailDataSetPublisher.getPublisherName:113 - error handler contains errors

Anybody any clue?

Thanks in advance,
Freek

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

mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

In the Detail Data Source window, enter you the JNDI name or the JDBC parameters?
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi,

The error only happens on saving data sets sofar. I take an existing dataset and only press save and it fails. That was the example above.

The fields that were filled were:
label, name, descr, type, query, data source and one analytical driver was added.

If I create a new one:
Label F
Name F
Descr: F
Type Query
Query: SELECT 1 ONE FROM dual
Datasource SpagoBI

I get the same behavour. The log then looks as follows:

[http-8080-1] 08 nov 2010 10:45:10,955 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 08 nov 2010 10:45:10,955 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 08 nov 2010 10:45:10,974 ERROR it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.insertDataSet:393 - Error while inserting the data Set with id -1
org.hibernate.exception.GenericJDBCException: could not insert: [it.eng.spagobi.tools.dataset.metadata.SbiQueryDataSet]
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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510)
at it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.insertDataSet(DataSetDAOHibImpl.java:390)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:40
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.service(DetailDataSetModule.java:136)
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:127)
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:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: Incorrect arguments to mysqld_stmt_execute
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1967)
... 41 more
[http-8080-1] 08 nov 2010 10:45:10,985 ERROR it.eng.spagobi.tools.dataset.presentation.DetailDataSetPublisher.getPublisherName:113 - error handler contains errors

I hope you can help me out.

Thanks in advance,
Freek
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Hi Freek,
sorry but your information about this problem are not sufficient to understand exactly what is wrong.
To better understand I need to know:
Where is the Data Source?
Are you testing the connection with the Data Source?
Where is the JNDI name or the JDBC parameters?

Here you can find more information about configuring of data source and data set in SpagoBI.

https://wiki.spagobi.org/xwiki/bin/view/Main/

bye
Monia
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

I'm sorry to provide the wrong info.

The datasource is defined as follows:
Label: SpagoBI
Desc: SpagoBI Metadata
Dialect: MySQL
Multischema: No
Type: JDBC
URL: jdbc:mysql://localhost/spagobi
Userid: root
Password: xxx
Driver: com.mysql.jdbc.Driver

In the server.xml of tomcat you will find:
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/spagobi" password="xxx" type="javax.sql.DataSource" url="jdbc:mysql://localhost/spagobi" username="root" />

I cannot imagine that the datasource is the problem, since I can login with different users and the login is stored in the database which is accessed via this datasource, also I can create and resave datasources, documents, etc. As far as I can see only saving the "data set" does not work.

Your help is much appreciated...

Thanks in advance,
Freek
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

I've just copied my Ubuntu Tomcat directory to a windows pc. After that I unloaded my two MySQL databases and reloaded them on my windows pc. I do the same actions there and it saves correctly.

In my view this prooves that there is a problem with 'java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.1) (6b20-1.9.1-1ubuntu3) OpenJDK 64-Bit Server VM (build 17.0-b16, mixed mode)' in combination with SpagoBI 2.6 or with SpagoBI 2.6 and Mysql under linux.

Any clue to which version of OpenJDK I need to downgrade and if there is an easy way to do this under Ubuntu?

Thanks in advance,
Freek
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Hi Freek,
I've ubuntu 10.10 with openJDK-6 64-Bit and SpagoBI 2.6 installed, and I not have this problem.
Now I do some further testing

Monia
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Hi Freek,
today I downloaded SpagoBI 2.6 from the web and I replayed all installations. I've ubuntu 10.10 with OpenJDK and I haven't a problem. You have solved? It could be maybe the configuration of tomcat?

Greetings
Monia
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

I've not done that other than exporting my spagobi database and importing it in windows, create the dataset there and export it and import it in ubuntu. Probably I will have to reinstall my laptop which I tried to avoid. Just a few questions:
1) Are you also using: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1
2) Which version of Tomcat are you using?

Thanks in advance,
Freek
mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Hi Freek,
my version of ubuntu is 10.10 x86_64
1) Yes. I installed it from synaptic.
2) I use a version of tomcat in the folder of SpagoBI, but I had to change the port from 8080 to 18080 because otherwise gave me conflicts with the tomcat installed from synaptic.

Bye

Monia
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

Thanks for all of that. It looks like we've done almost the same with everything. So I'm running Ubuntu 64 bit as well. I installed mysql the same way.

The only difference I see is the version of Tomcat. I run Apache Tomcat/6.0.26 and as far as I can see the download area contains 6.0.18. I cannot imagine that this would be the problem since before the upgrade I ran the same version and it worked fine. I'll reinstall my laptop, but it'll have to wait until at least thursday. I'll keep you posted.

Thanks again for your help,

Freek
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

I've just installed my laptop from scratch and copied my tomcat environment in. It did not help. So I'll try one more thing... (probably tomorrow) which is... take the system from the download area. and import my created reports from scratch into a new fresh tomcat environment and spagobi environment. If you have any other advice, please let me know...

Best regards,
Freek
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

It still does not work.

I've done the following... After reinstalling my machine from scratch.

I installed the demo environment and changed the server.xml to:
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/spagobi" password="xxx" type="javax.sql.DataSource" url="jdbc:mysql://localhost/spagobi" username="root" />

I dropped the mysql database spagobi and recreated it with the following scripts:
MySQL_create.sql
MySQL_create_comment.sql
MySQL_create_quartz_schema.sql
(I left the foreign keys out on purpose just to prevent it generating the error).

I started the server. I could login with biadmin. In mysql I could see that e.g. the sbi_user table was filled correctly; so the connection works.

I created the data source. No problem.
I typed in the dataset. Test it, that works ok. Then press the save and exit error and it generates the error. The SpagoBI.log file shows again the message below...

Any idea?

If I use the hsqldb which is the standard in the demo environment then it works ok, but I do not want to use the hsqldb database.

Thanks in advance,

Freek

[http-8080-1] 11 Nov 2010 21:54:58,812 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 11 Nov 2010 21:54:58,812 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - Incorrect arguments to mysqld_stmt_execute
[http-8080-1] 11 Nov 2010 21:54:58,822 ERROR it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.insertDataSet:393 - Error while inserting the data Set with id -1
org.hibernate.exception.GenericJDBCException: could not insert: [it.eng.spagobi.tools.dataset.metadata.SbiQueryDataSet]
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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510)
at it.eng.spagobi.tools.dataset.dao.DataSetDAOHibImpl.insertDataSet(DataSetDAOHibImpl.java:390)
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.modifyDataSet(DetailDataSetModule.java:40
at it.eng.spagobi.tools.dataset.service.DetailDataSetModule.service(DetailDataSetModule.java:136)
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.SQLException: Incorrect arguments to mysqld_stmt_execute
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1967)
... 41 more
[http-8080-1] 11 Nov 2010 21:54:58,827 ERROR it.eng.spagobi.tools.dataset.presentation.DetailDataSetPublisher.getPublisherName:113 - error handler contains errors
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Another question...

I run with
lower_case_table_names = 1
in the /etc/mysql/my.cnf in order to prevent that table names have either upper or lower case filenames. This I did before creating the spagobi database.

Could this be the problem?

Thanks in advance,
Freek
freekb.spw

SpagoBI supporter

Joined: 08/07/2010 09:46:26
Messages: 152
Offline

Hi Monia,

I've just dropped the database, removed the line in the my.cnf so that mysql uses case-sensitive table names, restarted mysql, recreated the database and it didn't work. I've even checked whether moving the spagobi database to the MyISAM engine would work, but also that does not work.

I found out that writing into the SBI_DATA_SET table generates problems. E.g. the SBI_DATA_SOURCE and other tables are not a problem.

The problem also occurs in case I'm importing a report that contains a data set.

Is there anything different in your calls to the database between writing to sbi_data_source and sbi_data_set?

Since you do not seem to have the problem, which JAR file are you using for MySQL? I'm using mysql-connector-java-3.1.13-bin.jar.

Thanks in advance,
Freek
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team