java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request.

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.

  • It's impossible to create analyzer report based on database tables data source using table from data services created from csv file *BTW* it happens only with *analyzer report* if you try to create an *interactive report* based on the same datsource the report is created *successfully* without any errors. *Expected Result*: analyzer report based on datasource with data services created from csv file is created successfully *without any errors* Here the full *error output*: {noformat} WITH SET [*NATIVE_CJ_SET_WITH_SLICER] AS 'FILTER([*BASE_MEMBERS__CONTACTFIRSTNAME_], NOT ISEMPTY ([Measures].[SALES]))' SET [*NATIVE_CJ_SET] AS '[*NATIVE_CJ_SET_WITH_SLICER]' SET [*SORTED_ROW_AXIS] AS 'ORDER([*CJ_ROW_AXIS],[CONTACTFIRSTNAME].CURRENTMEMBER.ORDERKEY,BASC)' SET [*BASE_MEMBERS__Measures_] AS '{[Measures].[SALES]}' SET [*CJ_ROW_AXIS] AS 'GENERATE([*NATIVE_CJ_SET], {([CONTACTFIRSTNAME].CURRENTMEMBER)})' SET [*BASE_MEMBERS__CONTACTFIRSTNAME_] AS '[CONTACTFIRSTNAME].[CONTACTFIRSTNAME].MEMBERS' SELECT [*BASE_MEMBERS__Measures_] ON COLUMNS ,[*SORTED_ROW_AXIS] ON ROWS FROM [last] 2016-08-16 10:45:21,834 ERROR [com.pentaho.analyzer.b.c] Ticket Number: 1471333521834 2016-08-16 10:45:21,834 ERROR [com.pentaho.analyzer.b.c] Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:168) at com.pentaho.analyzer.content.controller.b.b(SourceFile:202) 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:302) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1510) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) 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:74) 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.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 86 more Caused by: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:322) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:139) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.sql.SQLException: An error occurred while processing request. at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:77) at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187) at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187) at mondrian.olap.Util.close(Util.java:2317) at mondrian.rolap.SqlStatement.close(SqlStatement.java:295) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:553) at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:568) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:262) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:195) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:122) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:114) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:203) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:977) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:801) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:757) at mondrian.rolap.RolapResult.<init>(RolapResult.java:401) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) ... 4 more {noformat}
    via by Alena Karneichyk,
  • *Actual result* Data used : Dados --> Integer Type Binary --> Binary Type When we add binary fields to the pivot table with another field type , we have a popup with the message "something went wrong" and in log we have this error : {code:xml} java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:175) at com.pentaho.analyzer.content.controller.b.b(SourceFile:206) at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:294) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:151) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:237) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:162) at org.pentaho.platform.pdi.ContentGeneratorServlet.service(ContentGeneratorServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at Proxya29a4333_2037_4b4f_9e2e_4292dc498a1f.service(Unknown Source) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:69) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:240) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:75) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Unknown Source) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 35 more Caused by: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:326) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:145) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: java.sql.SQLException: An error occurred while processing request. at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:76) at mondrian.olap.Util.close(Util.java:2317) at mondrian.rolap.SqlStatement.close(SqlStatement.java:292) at mondrian.spi.impl.SqlStatisticsProvider.getColumnCardinality(SqlStatisticsProvider.java:136) at mondrian.rolap.RolapStatisticsCache.getColumnCardinality(RolapStatisticsCache.java:171) at mondrian.rolap.RolapStatisticsCache.getColumnCardinality(RolapStatisticsCache.java:137) at mondrian.rolap.RolapStar$Column.getCardinality(RolapStar.java:1024) at mondrian.rolap.FastBatchingCellReader.preloadColumnCardinality(FastBatchingCellReader.java:461) at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:240) at mondrian.rolap.RolapResult.phase(RolapResult.java:603) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:1027) at mondrian.rolap.RolapResult.<init>(RolapResult.java:504) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:662) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:613) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:611) ... 4 more {code} *Error occurs too in 7.0 GA*
    via by Ronye Sarreira,
  • *Actual Result* When we have a binary field in the data and we inspect the data in DET, when we select that field for a visualization different from the flat table, we see: +In Stream view:+ We see the following Error in the console and DET shows the following error message !binary-stream.png|thumbnail! {code} 2017/05/15 18:15:08 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" LIMIT 5001 OFFSET 0 - Dispatching started for transformation [transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" LIMIT 5001 OFFSET 0] 2017/05/15 18:15:08 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - Service - -120058439 - Dispatching started for transformation [transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - Service - -120058439] 2017/05/15 18:15:08 - CSV file input 2 2 2.0 - Finished processing (I=100, O=0, R=0, W=100, U=0, E=0) 2017/05/15 18:15:08 - Injector.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:15:08 - Limit input rows.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:15:08 - Set Conversion.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:15:08 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" LIMIT 5001 OFFSET 0 - Service Transformation results cached 2017/05/15 18:15:08 - Group by.0 - Finished processing (I=0, O=0, R=100, W=1, U=0, E=0) 2017/05/15 18:15:08 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2017/05/15 18:15:08 - Limit rows.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2017/05/15 18:15:08 - RESULT.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2017/05/15 18:15:09 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT "Field_002" AS "Field_002",SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" GROUP BY "Field_002" ORDER BY "Field_001" DESC,"Field_002" ASC LIMIT 5001 OFFSET 0 - Dispatching started for transformation [transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT "Field_002" AS "Field_002",SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" GROUP BY "Field_002" ORDER BY "Field_001" DESC,"Field_002" ASC LIMIT 5001 OFFSET 0] 2017/05/15 18:15:09 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - Service - 1054559700 - Dispatching started for transformation [transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - Service - 1054559700] 2017/05/15 18:15:10 - CSV file input 2 2 2.0 - Finished processing (I=100, O=0, R=0, W=100, U=0, E=0) 2017/05/15 18:15:10 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT "Field_002" AS "Field_002",SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" GROUP BY "Field_002" ORDER BY "Field_001" DESC,"Field_002" ASC LIMIT 5001 OFFSET 0 - Service Transformation results cached 2017/05/15 18:15:10 - Injector.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:15:10 - Limit input rows.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:15:10 - Set Conversion.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) java.lang.NullPointerException at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.getAggregateResult(MemoryGroupBy.java:498) at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.handleLastOfGroup(MemoryGroupBy.java:204) at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.processRow(MemoryGroupBy.java:177) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Unknown Source) 2017/05/15 18:15:10 - Group by.0 - ERROR (version 8.0-QAT-104, build 1 from 2017-05-14 20.13.38 by buildguy) : Unexpected error 2017/05/15 18:15:10 - Group by.0 - ERROR (version 8.0-QAT-104, build 1 from 2017-05-14 20.13.38 by buildguy) : java.lang.NullPointerException 2017/05/15 18:15:10 - Group by.0 - at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.getAggregateResult(MemoryGroupBy.java:498) 2017/05/15 18:15:10 - Group by.0 - at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.handleLastOfGroup(MemoryGroupBy.java:204) 2017/05/15 18:15:10 - Group by.0 - at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.processRow(MemoryGroupBy.java:177) 2017/05/15 18:15:10 - Group by.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2017/05/15 18:15:10 - Group by.0 - at java.lang.Thread.run(Unknown Source) 2017/05/15 18:15:10 - Group by.0 - Finished processing (I=0, O=0, R=100, W=0, U=0, E=1) 2017/05/15 18:15:10 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT "Field_002" AS "Field_002",SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" GROUP BY "Field_002" ORDER BY "Field_001" DESC,"Field_002" ASC LIMIT 5001 OFFSET 0 - Transformation detected one or more steps with errors. 2017/05/15 18:15:10 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT "Field_002" AS "Field_002",SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" GROUP BY "Field_002" ORDER BY "Field_001" DESC,"Field_002" ASC LIMIT 5001 OFFSET 0 - Transformation is killing the other steps! 2017/05/15 18:15:10 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - SELECT "Field_002" AS "Field_002",SUM("Field_001") AS "Field_001" FROM "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" GROUP BY "Field_002" ORDER BY "Field_001" DESC,"Field_002" ASC LIMIT 5001 OFFSET 0 - ERROR (version 8.0-QAT-104, build 1 from 2017-05-14 20.13.38 by buildguy) : Errors detected! 18:15:10,782 ERROR [d] java.sql.SQLException: An error occurred while processing request. {code} +In Model view:+ We see the following Error in the console and DET retrieves the "No data available message" !binary-model.png|thumbnail! {code} 2017/05/15 18:34:09 - Injector.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:34:09 - Limit input rows.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:34:09 - Set Conversion.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:34:09 - Group by.0 - Finished processing (I=0, O=0, R=100, W=1, U=0, E=0) 2017/05/15 18:34:09 - Select values.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2017/05/15 18:34:09 - RESULT.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) 2017/05/15 18:34:14 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - select "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" as "c0" from "Kettle"."transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" as "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" group by "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" having NOT((sum("transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_001") is null)) order by CASE WHEN "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" IS NULL THEN 1 ELSE 0 END, "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" ASC - Dispatching started for transformation [transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - select "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" as "c0" from "Kettle"."transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" as "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" group by "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" having NOT((sum("transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_001") is null)) order by CASE WHEN "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" IS NULL THEN 1 ELSE 0 END, "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" ASC] 2017/05/15 18:34:14 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - Service - -1320665761 - Dispatching started for transformation [transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - Service - -1320665761] 2017/05/15 18:34:14 - CSV file input 2 2 2.0 - Finished processing (I=100, O=0, R=0, W=100, U=0, E=0) 2017/05/15 18:34:14 - Injector.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:34:14 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - select "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" as "c0" from "Kettle"."transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" as "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" group by "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" having NOT((sum("transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_001") is null)) order by CASE WHEN "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" IS NULL THEN 1 ELSE 0 END, "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" ASC - Service Transformation results cached 2017/05/15 18:34:14 - Set Conversion.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) 2017/05/15 18:34:14 - Limit input rows.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0) java.lang.NullPointerException at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.getAggregateResult(MemoryGroupBy.java:498) at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.handleLastOfGroup(MemoryGroupBy.java:204) at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.processRow(MemoryGroupBy.java:177) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Unknown Source) 2017/05/15 18:34:14 - Group by.0 - ERROR (version 8.0-QAT-104, build 1 from 2017-05-14 20.13.38 by buildguy) : Unexpected error 2017/05/15 18:34:14 - Group by.0 - ERROR (version 8.0-QAT-104, build 1 from 2017-05-14 20.13.38 by buildguy) : java.lang.NullPointerException 2017/05/15 18:34:14 - Group by.0 - at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.getAggregateResult(MemoryGroupBy.java:498) 2017/05/15 18:34:14 - Group by.0 - at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.handleLastOfGroup(MemoryGroupBy.java:204) 2017/05/15 18:34:14 - Group by.0 - at org.pentaho.di.trans.steps.memgroupby.MemoryGroupBy.processRow(MemoryGroupBy.java:177) 2017/05/15 18:34:14 - Group by.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2017/05/15 18:34:14 - Group by.0 - at java.lang.Thread.run(Unknown Source) 2017/05/15 18:34:14 - Group by.0 - Finished processing (I=0, O=0, R=100, W=0, U=0, E=1) 2017/05/15 18:34:14 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - select "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" as "c0" from "Kettle"."transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" as "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" group by "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" having NOT((sum("transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_001") is null)) order by CASE WHEN "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" IS NULL THEN 1 ELSE 0 END, "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" ASC - Transformation detected one or more steps with errors. 2017/05/15 18:34:14 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - select "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" as "c0" from "Kettle"."transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" as "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" group by "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" having NOT((sum("transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_001") is null)) order by CASE WHEN "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" IS NULL THEN 1 ELSE 0 END, "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" ASC - Transformation is killing the other steps! 2017/05/15 18:34:14 - transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI= - SQL - select "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" as "c0" from "Kettle"."transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" as "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI=" group by "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" having NOT((sum("transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_001") is null)) order by CASE WHEN "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" IS NULL THEN 1 ELSE 0 END, "transient:QzpcVXNlcnNcemFuYV9nYWl2b3RhXE9uZURyaXZlIC0gUGVudGFobyBDb3JwXFBlbnRhaG8gU29mdHdhcmVcc2FtcGxlIGZpbGVzXGV4YW1wbGUtYmluYXJ5Lmt0cg==:bG9jYWw6Q1NWIGZpbGUgaW5wdXQgMiAyIDI="."Field_002" ASC - ERROR (version 8.0-QAT-104, build 1 from 2017-05-14 20.13.38 by buildguy) : Errors detected! 18:34:14,882 ERROR [c] Ticket Number: 1494869654882 18:34:14,884 ERROR [c] Exception in AJAX handler. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:183) at com.pentaho.analyzer.content.controller.b.b(SourceFile:206) at com.pentaho.analyzer.content.AnalyzerContentGenerator.a(SourceFile:294) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:151) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:237) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:162) at org.pentaho.platform.pdi.ContentGeneratorServlet.service(ContentGeneratorServlet.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at Proxy8ec6b267_cf2b_4ae5_85c3_09ce609b5c9b.service(Unknown Source) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:69) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:240) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:75) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Unknown Source) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 35 more Caused by: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:326) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:145) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) ... 1 more Caused by: java.sql.SQLException: An error occurred while processing request. at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:76) at mondrian.olap.Util.close(Util.java:2317) at mondrian.rolap.SqlStatement.close(SqlStatement.java:292) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:567) at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:583) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:262) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:195) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:122) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1092) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:114) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1092) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateDual(OrderFunDef.java:160) at mondrian.olap.fun.OrderFunDef$ContextCalc.evaluate(OrderFunDef.java:362) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1092) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:980) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:804) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:760) at mondrian.rolap.RolapResult.<init>(RolapResult.java:401) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:662) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:613) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:611) ... 4 more {code} *Additional information:* # Flat table works fine when displaying the binary field # When we change the data type of the binary field to string, stream and model work fine # Attached you can find a transformation to simulate this behavior # Screenshots and error console logs are from pdi-ee-client-8.0-QAT-104 ## the console log errors and DET UI in pdi-ee-client-7.0.0.1-37 are not exactly the same we have in pdi-ee-client-8.0-QAT-104 but the visualizations don't render also in the presence of a binary field selected
    via by Susana Goncalves,
    • java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.n.a(SourceFile:168) at com.pentaho.analyzer.content.controller.b.b(SourceFile:202) 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:302) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1510) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) 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:74) 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.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 86 more Caused by: java.lang.RuntimeException: java.sql.SQLException: An error occurred while processing request. at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:322) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:139) at com.pentaho.analyzer.report.ReportRequestService$2.a(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.sql.SQLException: An error occurred while processing request. at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.close(ThinResultSet.java:77) at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187) at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:187) at mondrian.olap.Util.close(Util.java:2317) at mondrian.rolap.SqlStatement.close(SqlStatement.java:295) at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:553) at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:568) at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:262) at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:195) at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:122) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:114) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:203) at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65) at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:1089) at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:100) at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:66) at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:98) at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:977) at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:801) at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:757) at mondrian.rolap.RolapResult.<init>(RolapResult.java:401) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621) ... 4 more
    No Bugmate found.