Discussion :

[maxine]

bonjour,
j'ai installé spagobi 2.8 sur un serveur ubuntu 10.10. J'arrive à la page d'accueil, je me peux me connecter mais si je vais sur Ressources/Gestion des moteurs, j'ai une pile d'erreurs:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'ENGINE_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5012) at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:328) at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:328) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.engines.config.service.ListEnginesModule.getList(ListEnginesModule.java:49) at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:98) at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) 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:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.engines.config.service.ListEnginesModule.getList(ListEnginesModule.java:49) at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:98) at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) 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:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)
Parent non disponible

Si je vais dans Ressources/Sources de données, il n'y arien à afficher et totu est correct. Je peux entrer une nouvelle source de données, la tester, la sauvegarder et quand je retourne sur cet écran, à nouveau erreur:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'DS_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5012) at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:328) at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:328) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.tools.datasource.service.ListDataSourceModule.getList(ListDataSourceModule.java:48) at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:98) at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) 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:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.tools.datasource.service.ListDataSourceModule.getList(ListDataSourceModule.java:48) at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:98) at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) 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:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)
Parent non disponible

J'ai mis mysql en mode trace et j'ai exécuté les commandes passées à mysql et tout est bon !
du coup, je ne comprends pas: est ce que quelqu'un a une idée ?
merci d'avance,

[maxine]

corrigé en remplaçant le connecteur ODBC mysql 5.1.10 par le connecteur 3.1.13
Finalement, c'est dans les vieux pots qu'on fait les meilleurs soupes