[SBI QBE] Problème avec la crosstab [Résolu]

[zakato]

Salut a tous,
Alors il m'arrive quelque chose d'un peu bizarre, hier j'ai mis en place mon datamart QBE et je pouvais runner des requêtes sans soucis ainsi que construire une crosstab et l'exporter sur excel sans problème.

Mais aujourd'hui je redémarre mon serveur et alors que rien n'a changé entre temps, je ne peut runner la crosstab, la requête se fait sans problème, je peux mettre à jour les champs pour la construction de le crosstab, mais quand je lance l'aperçu, spago load puis m'affiche :

An unpredicted error occurred while executing LOAD_CROSSTAB_ACTION service. The root cause of the error is: For input string: "none"

j'ai essayé de modifier ma requête mais rien n'y fait, je ne comprend vraiment pas pourquoi cela marchait hier mais plus aujourd'hui...

Si quelqu'un à une piste ou une idée je prends

[zakato]

Je ne sais pas si cela peut aider mais voici le contenu des log SBIQBEengine et SBIQBEaudit :

sbIQBEengine :

06 avr. 2011 15:00:41,745 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:100 - An unpredicted error occurred while executing LOAD_CROSSTAB_ACTION service.
The root cause of the error is: For input string: "none"
06 avr. 2011 15:00:41,745 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:101 - The error root cause is: For input string: "none"
06 avr. 2011 15:00:41,761 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:110 - The error root cause stack trace is:
java.lang.NumberFormatException: For input string: "none"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.<init>(Unknown Source)
at it.eng.qbe.crosstab.bo.CrossTab.<init>(CrossTab.java:88)
at it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction.service(LoadCrosstabAction.java:189)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:158)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:497)
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.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:221)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.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: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)
06 avr. 2011 15:00:41,761 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:111 - The error full stack trace is:
it.eng.spagobi.utilities.engines.SpagoBIEngineServiceException: An unpredicted error occurred while executing LOAD_CROSSTAB_ACTION service.
The root cause of the error is: For input string: "none"
at it.eng.spagobi.utilities.engines.SpagoBIEngineServiceExceptionHandler.getWrappedException(SpagoBIEngineServiceExceptionHandler.java:93)
at it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction.service(LoadCrosstabAction.java:202)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:158)
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:497)
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.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:221)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.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: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: java.lang.NumberFormatException: For input string: "none"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.<init>(Unknown Source)
at it.eng.qbe.crosstab.bo.CrossTab.<init>(CrossTab.java:88)
at it.eng.spagobi.engines.qbe.services.crosstab.LoadCrosstabAction.service(LoadCrosstabAction.java:189)
... 22 more

SBIQBEaudit :

06 avr. 2011 14:56:37,023: [biadmin]:: HQL: SELECT t_0.site, t_0.mois, t_0.annee, t_0.profondeur, moyenne FROM pnpc.tables.Moyenne t_0 WHERE t_0.annee=2011

06 avr. 2011 14:56:37,039: [biadmin]:: SQL: select moyenne0_.SITE as col_0_0_, moyenne0_.MOIS as col_1_0_, moyenne0_.ANNEE as col_2_0_, moyenne0_.PROFONDEUR as col_3_0_, moyenne0_.MOYENNE as col_4_0_ from lportal_605.moyenne moyenne0_ where moyenne0_.ANNEE=2011

06 avr. 2011 15:00:41,480: Temporary table definition for user [biadmin]:: HQL: SELECT t_0.site, t_0.mois, t_0.annee, t_0.profondeur, moyenne FROM pnpc.tables.Moyenne t_0 WHERE t_0.annee=2011

06 avr. 2011 15:00:41,480: Temporary table definition for user [biadmin]:: SQL: select moyenne0_.SITE as col_0_0_, moyenne0_.MOIS as col_1_0_, moyenne0_.ANNEE as col_2_0_, moyenne0_.PROFONDEUR as col_3_0_, moyenne0_.MOYENNE as col_4_0_ from lportal_605.moyenne moyenne0_ where moyenne0_.ANNEE=2011

06 avr. 2011 15:00:41,480: Querying temporary table: user [biadmin] (SQL): [SELECT col_2_0_, col_1_0_, col_3_0_, AVG(col_4_0_) FROM TEMPORARY_TABLE GROUP BY col_2_0_, col_1_0_, col_3_0_]

[zakato]

Règlé en supprimant le dossier QBE de webapps et en redeployant le moteur (même version que la précédente pourtant ...)
Bref je ne comprend toujours pas mais bon ça marche ^^