java.lang.NullPointerException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • NullPointerException is getting out from ResultSet class. Independently of what I'm doing wrong, it's not nice to let a NullPointerException go all the way to the system output. Some better error message should be displayed. Follows the error, and after, my xaction. By the way, if anybody knows how can this be solved, please tell me. :) I found this forum entry: http://forums.pentaho.org/archive/index.php/t-53637.html It seems to be the same problem I have, but there is no solution for it yet, just the workaround of having two different working sets for the same thing. 19:04:16,127 INFO [STDOUT] 19:04:16,127 ERROR [SecureFilterComponent] Error Start: Pentaho Pentaho BI Platform 1.6.1.873 (class) 19:04:16,138 INFO [STDOUT] 19:04:16,132 ERROR [SecureFilterComponent] dd549daa-83ed-11dc-a048-63a1df6525e0:COMPONENT:context-29886917-1193421855812:traficParJours3.xactionBase.ERROR_0002 - L'exécution du composant à échouée java.lang.NullPointerException at org.pentaho.data.connection.sql.SQLResultSet.next(SQLResultSet.java:89) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:128) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:91) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:173) at org.pentaho.plugin.core.SecureFilterComponent.executeAction(SecureFilterComponent.java:132) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:454) at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1122) at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1094) at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1006) at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:961) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:864) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:768) at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169) at org.pentaho.core.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:150) at org.pentaho.ui.servlet.ViewAction.handleActionRequest(ViewAction.java:139) at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:261) at org.pentaho.ui.servlet.ViewAction.doPost(ViewAction.java:271) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) 19:04:16,139 INFO [STDOUT] 19:04:16,139 ERROR [SecureFilterComponent] Error end: XACTION: <?xml version="1.0" encoding="UTF-8"?> <action-sequence> <title>%title</title> <version>1</version> <logging-level>DEBUG</logging-level> <documentation> <author>Axel Haustant</author> <description>%description</description> <icon>listing-icon.png</icon> <help>Choose Report Output Format.</help> <result-type>report</result-type> </documentation> <inputs> <outputType type="string"> <sources> <request>outputType</request> <request>type</request> </sources> <default-value><![CDATA[html]]></default-value> </outputType> <outputTypeList type="property-map-list"> <sources> <runtime>outputTypeList</runtime> </sources> <default-value type="property-map-list"> <property-map> <entry key="report-output-desc">PDF</entry> <entry key="report-output-type-id">pdf</entry> </property-map> <property-map> <entry key="report-output-desc">Excel</entry> <entry key="report-output-type-id">xls</entry> </property-map> <property-map> <entry key="report-output-desc">Word</entry> <entry key="report-output-type-id">rtf</entry> </property-map> <property-map> <entry key="report-output-desc">Web Page</entry> <entry key="report-output-type-id">html</entry> </property-map> <property-map> <entry key="report-output-desc">Comma Separated Value</entry> <entry key="report-output-type-id">csv</entry> </property-map> </default-value> </outputTypeList> <ExploitSlicer type="string"> <sources> <session>ExploitSlicer</session> </sources> </ExploitSlicer> <NumCouleurSet type="string"> <sources> <session>NumCouleurSet</session> </sources> </NumCouleurSet> <WhereExp type="string"> <sources> <session>WhereExp</session> </sources> </WhereExp> <startDay type="string"> <sources> <request>startDay</request> </sources> <default-value/> </startDay> <endDay type="string"> <sources> <request>endDay</request> </sources> <default-value/> </endDay> <startMonth type="string"> <sources> <request>startMonth</request> </sources> <default-value/> </startMonth> <endMonth type="string"> <sources> <request>endMonth</request> </sources> <default-value/> </endMonth> <startYear type="string"> <sources> <request>startYear</request> </sources> <default-value/> </startYear> <endYear type="string"> <sources> <request>endYear</request> </sources> <default-value/> </endYear> </inputs> <outputs> <content type="content"> <destinations> <response>content</response> </destinations> </content> </outputs> <resources> <report-definition> <solution-file> <location>/rapports/traficParJours2.xml</location> <mime-type>text/plain</mime-type> </solution-file> </report-definition> <catalog> <solution-file> <location>/models/appels.mondrian.xml</location> <mime-type>text/xml</mime-type> </solution-file> </catalog> </resources> <actions> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Open database connection</action-type> <action-outputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-outputs> <component-definition> <jndi><![CDATA[3gfstats]]></jndi> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Get days</action-type> <action-inputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-inputs> <action-outputs> <query-result type="result-set" mapping="days"/> <jour type="integer"/> </action-outputs> <component-definition> <query><![CDATA[select distinct jour from temps;]]></query> <live><![CDATA[true]]></live> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Get Months</action-type> <action-inputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-inputs> <action-outputs> <query-result type="result-set" mapping="months"/> <mois type="string"/> </action-outputs> <component-definition> <query><![CDATA[select distinct mois from temps]]></query> <live><![CDATA[true]]></live> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Get Years</action-type> <action-inputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-inputs> <action-outputs> <query-result type="result-set" mapping="years"/> <annee type="integer"/> </action-outputs> <component-definition> <query><![CDATA[select distinct annee from temps]]></query> <live><![CDATA[true]]></live> </component-definition> </action-definition> <action-definition> <component-name>SecureFilterComponent</component-name> <action-type>Filters</action-type> <action-inputs> <startDay type="string"/> <days type="result-set"/> <endDay type="string"/> <startMonth type="string"/> <months type="result-set"/> <startYear type="string"/> <years type="result-set"/> <endMonth type="string"/> <endYear type="string"/> </action-inputs> <action-resources/> <component-definition> <selections> <startDay style="select" prompt-if-one-value="true"> <filter value-col-name="jour" display-col-name="jour">days</filter> <title>Jour initial</title> </startDay> <startMonth style="select"> <filter value-col-name="mois" display-col-name="mois">months</filter> </startMonth> <startYear style="select"> <filter value-col-name="annee" display-col-name="annee">years</filter> </startYear> <endDay style="select"> <filter value-col-name="jour" display-col-name="jour">days</filter> <title>Jour final</title> </endDay> <endMonth style="select"> <filter value-col-name="mois" display-col-name="mois">months</filter> </endMonth> <endYear style="select"> <filter value-col-name="annee" display-col-name="annee">years</filter> </endYear> </selections> <xsl><![CDATA[none.xsl]]></xsl> </component-definition> </action-definition> <action-definition> <component-name>MDXLookupRule</component-name> <action-inputs> <startYear type="string"/> <startMonth type="string"/> <endYear type="string"/> <endMonth type="string"/> </action-inputs> <action-resources> <catalog type="resource"/> </action-resources> <action-outputs> <query-results type="result-set" mapping="report_data"/> </action-outputs> <component-definition> <query><![CDATA[with member [Measures].[Duree Heure vraisment facturee] as [Measures].[Duree Heure facturee] - [Measures].[Nb Appels factures]*12 select {[Measures].[Nb Appels],[Measures].[Nb Appels factures], [Measures].[Nb Appels non-factures], [Measures].[Duree Heure], [Measures].[Duree Heure vraisment facturee], [Measures].[Duree Heure non-facturee], [Measures].[Duree Moyenne]} on columns, [Temps].[{startYear}].[{startMonth}]:[Temps].[{endYear}].[{endMonth}] on rows from [Appels]]]></query> <jndi><![CDATA[3gfstats]]></jndi> <location><![CDATA[mondrian]]></location> </component-definition> </action-definition> <action-definition> <component-name>JFreeReportComponent</component-name> <action-type>report</action-type> <action-inputs> <output-type type="string" mapping="outputType"/> <data type="result-set" mapping="report_data"/> </action-inputs> <action-resources> <report-definition type="resource"/> </action-resources> <action-outputs> <report-output type="content" mapping="content"/> </action-outputs> <component-definition/> </action-definition> </actions> </action-sequence>
    via by Tiago Rinck Caveden,
  • NullPointerException is getting out from ResultSet class. Independently of what I'm doing wrong, it's not nice to let a NullPointerException go all the way to the system output. Some better error message should be displayed. Follows the error, and after, my xaction. By the way, if anybody knows how can this be solved, please tell me. :) I found this forum entry: http://forums.pentaho.org/archive/index.php/t-53637.html It seems to be the same problem I have, but there is no solution for it yet, just the workaround of having two different working sets for the same thing. 19:04:16,127 INFO [STDOUT] 19:04:16,127 ERROR [SecureFilterComponent] Error Start: Pentaho Pentaho BI Platform 1.6.1.873 (class) 19:04:16,138 INFO [STDOUT] 19:04:16,132 ERROR [SecureFilterComponent] dd549daa-83ed-11dc-a048-63a1df6525e0:COMPONENT:context-29886917-1193421855812:traficParJours3.xactionBase.ERROR_0002 - L'exécution du composant à échouée java.lang.NullPointerException at org.pentaho.data.connection.sql.SQLResultSet.next(SQLResultSet.java:89) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:128) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:91) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:173) at org.pentaho.plugin.core.SecureFilterComponent.executeAction(SecureFilterComponent.java:132) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:454) at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1122) at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1094) at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1006) at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:961) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:864) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:768) at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169) at org.pentaho.core.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:150) at org.pentaho.ui.servlet.ViewAction.handleActionRequest(ViewAction.java:139) at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:261) at org.pentaho.ui.servlet.ViewAction.doPost(ViewAction.java:271) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) 19:04:16,139 INFO [STDOUT] 19:04:16,139 ERROR [SecureFilterComponent] Error end: XACTION: <?xml version="1.0" encoding="UTF-8"?> <action-sequence> <title>%title</title> <version>1</version> <logging-level>DEBUG</logging-level> <documentation> <author>Axel Haustant</author> <description>%description</description> <icon>listing-icon.png</icon> <help>Choose Report Output Format.</help> <result-type>report</result-type> </documentation> <inputs> <outputType type="string"> <sources> <request>outputType</request> <request>type</request> </sources> <default-value><![CDATA[html]]></default-value> </outputType> <outputTypeList type="property-map-list"> <sources> <runtime>outputTypeList</runtime> </sources> <default-value type="property-map-list"> <property-map> <entry key="report-output-desc">PDF</entry> <entry key="report-output-type-id">pdf</entry> </property-map> <property-map> <entry key="report-output-desc">Excel</entry> <entry key="report-output-type-id">xls</entry> </property-map> <property-map> <entry key="report-output-desc">Word</entry> <entry key="report-output-type-id">rtf</entry> </property-map> <property-map> <entry key="report-output-desc">Web Page</entry> <entry key="report-output-type-id">html</entry> </property-map> <property-map> <entry key="report-output-desc">Comma Separated Value</entry> <entry key="report-output-type-id">csv</entry> </property-map> </default-value> </outputTypeList> <ExploitSlicer type="string"> <sources> <session>ExploitSlicer</session> </sources> </ExploitSlicer> <NumCouleurSet type="string"> <sources> <session>NumCouleurSet</session> </sources> </NumCouleurSet> <WhereExp type="string"> <sources> <session>WhereExp</session> </sources> </WhereExp> <startDay type="string"> <sources> <request>startDay</request> </sources> <default-value/> </startDay> <endDay type="string"> <sources> <request>endDay</request> </sources> <default-value/> </endDay> <startMonth type="string"> <sources> <request>startMonth</request> </sources> <default-value/> </startMonth> <endMonth type="string"> <sources> <request>endMonth</request> </sources> <default-value/> </endMonth> <startYear type="string"> <sources> <request>startYear</request> </sources> <default-value/> </startYear> <endYear type="string"> <sources> <request>endYear</request> </sources> <default-value/> </endYear> </inputs> <outputs> <content type="content"> <destinations> <response>content</response> </destinations> </content> </outputs> <resources> <report-definition> <solution-file> <location>/rapports/traficParJours2.xml</location> <mime-type>text/plain</mime-type> </solution-file> </report-definition> <catalog> <solution-file> <location>/models/appels.mondrian.xml</location> <mime-type>text/xml</mime-type> </solution-file> </catalog> </resources> <actions> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Open database connection</action-type> <action-outputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-outputs> <component-definition> <jndi><![CDATA[3gfstats]]></jndi> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Get days</action-type> <action-inputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-inputs> <action-outputs> <query-result type="result-set" mapping="days"/> <jour type="integer"/> </action-outputs> <component-definition> <query><![CDATA[select distinct jour from temps;]]></query> <live><![CDATA[true]]></live> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Get Months</action-type> <action-inputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-inputs> <action-outputs> <query-result type="result-set" mapping="months"/> <mois type="string"/> </action-outputs> <component-definition> <query><![CDATA[select distinct mois from temps]]></query> <live><![CDATA[true]]></live> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>Get Years</action-type> <action-inputs> <prepared_component type="sql-connection" mapping="shared_sql_connection"/> </action-inputs> <action-outputs> <query-result type="result-set" mapping="years"/> <annee type="integer"/> </action-outputs> <component-definition> <query><![CDATA[select distinct annee from temps]]></query> <live><![CDATA[true]]></live> </component-definition> </action-definition> <action-definition> <component-name>SecureFilterComponent</component-name> <action-type>Filters</action-type> <action-inputs> <startDay type="string"/> <days type="result-set"/> <endDay type="string"/> <startMonth type="string"/> <months type="result-set"/> <startYear type="string"/> <years type="result-set"/> <endMonth type="string"/> <endYear type="string"/> </action-inputs> <action-resources/> <component-definition> <selections> <startDay style="select" prompt-if-one-value="true"> <filter value-col-name="jour" display-col-name="jour">days</filter> <title>Jour initial</title> </startDay> <startMonth style="select"> <filter value-col-name="mois" display-col-name="mois">months</filter> </startMonth> <startYear style="select"> <filter value-col-name="annee" display-col-name="annee">years</filter> </startYear> <endDay style="select"> <filter value-col-name="jour" display-col-name="jour">days</filter> <title>Jour final</title> </endDay> <endMonth style="select"> <filter value-col-name="mois" display-col-name="mois">months</filter> </endMonth> <endYear style="select"> <filter value-col-name="annee" display-col-name="annee">years</filter> </endYear> </selections> <xsl><![CDATA[none.xsl]]></xsl> </component-definition> </action-definition> <action-definition> <component-name>MDXLookupRule</component-name> <action-inputs> <startYear type="string"/> <startMonth type="string"/> <endYear type="string"/> <endMonth type="string"/> </action-inputs> <action-resources> <catalog type="resource"/> </action-resources> <action-outputs> <query-results type="result-set" mapping="report_data"/> </action-outputs> <component-definition> <query><![CDATA[with member [Measures].[Duree Heure vraisment facturee] as [Measures].[Duree Heure facturee] - [Measures].[Nb Appels factures]*12 select {[Measures].[Nb Appels],[Measures].[Nb Appels factures], [Measures].[Nb Appels non-factures], [Measures].[Duree Heure], [Measures].[Duree Heure vraisment facturee], [Measures].[Duree Heure non-facturee], [Measures].[Duree Moyenne]} on columns, [Temps].[{startYear}].[{startMonth}]:[Temps].[{endYear}].[{endMonth}] on rows from [Appels]]]></query> <jndi><![CDATA[3gfstats]]></jndi> <location><![CDATA[mondrian]]></location> </component-definition> </action-definition> <action-definition> <component-name>JFreeReportComponent</component-name> <action-type>report</action-type> <action-inputs> <output-type type="string" mapping="outputType"/> <data type="result-set" mapping="report_data"/> </action-inputs> <action-resources> <report-definition type="resource"/> </action-resources> <action-outputs> <report-output type="content" mapping="content"/> </action-outputs> <component-definition/> </action-definition> </actions> </action-sequence>
    via by Tiago Rinck Caveden,
    • java.lang.NullPointerException at org.pentaho.data.connection.sql.SQLResultSet.next(SQLResultSet.java:89) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:128) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:91) at org.pentaho.core.runtime.SelectionMapper.create(SelectionMapper.java:173) at org.pentaho.plugin.core.SecureFilterComponent.executeAction(SecureFilterComponent.java:132) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:454) at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1122) at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1094) at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1006) at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:961) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:864) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:768) at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169) at org.pentaho.core.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:150) at org.pentaho.ui.servlet.ViewAction.handleActionRequest(ViewAction.java:139) at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:261) at org.pentaho.ui.servlet.ViewAction.doPost(ViewAction.java:271) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595)
    No Bugmate found.