Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: NullPointerException

  1. #1
    Join Date
    Jul 2016
    Posts
    2

    Default NullPointerException

    I started working on Pentaho recently and designed a sample report (Treemap to be specific).
    it worked fine but later got the NullPointerException.
    I am attaching the log as well.
    Can some one please help me resolve it.

    Thanks in advance


    Log session start time Thu Jul 21 20:43:32 IST 2016

    Query Failed!
    java.lang.NullPointerException
    at com.pentaho.analyzer.report.a.i.a(SourceFile:285)
    at com.pentaho.analyzer.report.a.i.e(SourceFile:302)
    at com.pentaho.analyzer.report.a.i.d(SourceFile:329)
    at com.pentaho.analyzer.report.a.i.b(SourceFile:357)
    at com.pentaho.analyzer.report.a.i.a(SourceFile:229)
    at com.pentaho.analyzer.report.a.i.x(SourceFile:178)
    at com.pentaho.analyzer.report.a.i.(SourceFile:156)
    at com.pentaho.analyzer.content.controller.n.c(SourceFile:119)
    at com.pentaho.analyzer.content.controller.b.b(SourceFile:218)
    at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:311)
    at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:157)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:236)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:163)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54)
    at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33)
    at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
    at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:109)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:114)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:185)
    at com.pentaho.platform.web.http.filters.PentahoEnterpriseWebContextFilter.doFilter(SourceFile:72)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:191)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    at org.pentaho.platform.web.http.security.PentahoBasicProcessingFilter.doFilterHttp(PentahoBasicProcessingFilter.java:115)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:87)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.pentaho.platform.web.http.filters.PentahoPathDecodingFilter.doFilter(PentahoPathDecodingFilter.java:34)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2500)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2489)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)
    Time Thread Level Category Message
    274391 Analyzer ReportRequestService-1 DEBUG mondrian.rolap.RolapUtil // Request ID: aff40c4f-4f55-11e6-ab42-e8b1fc355db3 - RUN_REPORT
    WITH
    SET [*NATIVE_CJ_SET_WITH_SLICER] AS 'NONEMPTYCROSSJOIN([*BASE_MEMBERS__Sub LOB_],NONEMPTYCROSSJOIN([*BASE_MEMBERS__Risk Level_],[*BASE_MEMBERS__Supervisorkey_]))'
    SET [*NATIVE_CJ_SET] AS '[*NATIVE_CJ_SET_WITH_SLICER]'
    SET [*SORTED_ROW_AXIS] AS 'ORDER([*CJ_ROW_AXIS],[Sub LOB].CURRENTMEMBER.ORDERKEY,BASC,[Risk Level].CURRENTMEMBER.ORDERKEY,BASC,[Supervisorkey].CURRENTMEMBER.ORDERKEY,BASC)'
    SET [*BASE_MEMBERS__Measures_] AS '{[Measures].[*FORMATTED_MEASURE_0]}'
    SET [*BASE_MEMBERS__Supervisorkey_] AS '[Supervisorkey].[Supervisorkey].MEMBERS'
    SET [*BASE_MEMBERS__Sub LOB_] AS '[Sub LOB].[Sub LOB].MEMBERS'
    SET [*BASE_MEMBERS__Risk Level_] AS '[Risk Level].[Risk Level].MEMBERS'
    SET [*CJ_ROW_AXIS] AS 'GENERATE([*NATIVE_CJ_SET], {([Sub LOB].CURRENTMEMBER,[Risk Level].CURRENTMEMBER,[Supervisorkey].CURRENTMEMBER)})'
    MEMBER [Measures].[*FORMATTED_MEASURE_0] AS '[Measures].[Score100]', FORMAT_STRING = '#', SOLVE_ORDER=500
    SELECT
    [*BASE_MEMBERS__Measures_] ON COLUMNS
    ,NON EMPTY
    [*SORTED_ROW_AXIS] ON ROWS
    FROM [Source]
    274927 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlTupleReader.readTuples [[Sub LOB].[Sub LOB], [Risk Level].[Risk Level], [Supervisorkey].[Supervisorkey]]: executing sql [select "source"."Sub_LOB" as "c0", "source"."Risk_Level" as "c1", "source"."Supervisorkey" as "c2" from "source" as "source" group by "source"."Sub_LOB", "source"."Risk_Level", "source"."Supervisorkey" order by "source"."Sub_LOB" ASC NULLS LAST, "source"."Risk_Level" ASC NULLS LAST, "source"."Supervisorkey" ASC NULLS LAST], exec 41 ms
    274971 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlTupleReader.readTuples [[Sub LOB].[Sub LOB], [Risk Level].[Risk Level], [Supervisorkey].[Supervisorkey]]: done executing sql [select "source"."Sub_LOB" as "c0", "source"."Risk_Level" as "c1", "source"."Supervisorkey" as "c2" from "source" as "source" group by "source"."Sub_LOB", "source"."Risk_Level", "source"."Supervisorkey" order by "source"."Sub_LOB" ASC NULLS LAST, "source"."Risk_Level" ASC NULLS LAST, "source"."Supervisorkey" ASC NULLS LAST], exec+fetch 87 ms, 173 rows, ex=1, close=1, open=[]
    275145 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "Risk_Level") from "source"], exec 80 ms
    275145 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlStatisticsProvider.getColumnCardinality: done executing sql [select count(distinct "Risk_Level") from "source"], exec+fetch 85 ms, 1 rows, ex=2, close=2, open=[]
    275147 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "Sub_LOB") from "source"], exec 1 ms
    275148 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlStatisticsProvider.getColumnCardinality: done executing sql [select count(distinct "Sub_LOB") from "source"], exec+fetch 2 ms, 1 rows, ex=3, close=3, open=[]
    275150 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "Supervisorkey") from "source"], exec 2 ms
    275150 mondrian.rolap.RolapResultShepherd$executor_1 DEBUG mondrian.rolap.RolapUtil SqlStatisticsProvider.getColumnCardinality: done executing sql [select count(distinct "Supervisorkey") from "source"], exec+fetch 2 ms, 1 rows, ex=4, close=4, open=[]
    275283 mondrian.rolap.agg.SegmentCacheManager$sqlExecutor_1 DEBUG mondrian.rolap.RolapUtil Segment.load: executing sql [select "source"."Risk_Level" as "c0", "source"."Sub_LOB" as "c1", "source"."Supervisorkey" as "c2", sum("source"."score100") as "m0" from "source" as "source" group by "source"."Risk_Level", "source"."Sub_LOB", "source"."Supervisorkey"], exec 4 ms
    275344 mondrian.rolap.agg.SegmentCacheManager$sqlExecutor_1 DEBUG mondrian.rolap.RolapUtil Segment.load: done executing sql [select "source"."Risk_Level" as "c0", "source"."Sub_LOB" as "c1", "source"."Supervisorkey" as "c2", sum("source"."score100") as "m0" from "source" as "source" group by "source"."Risk_Level", "source"."Sub_LOB", "source"."Supervisorkey"], exec+fetch 65 ms, 173 rows, ex=5, close=5, open=[]

  2. #2
    Join Date
    Jul 2016
    Posts
    2

    Default

    Anyone Please

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.