Hi,
I hava choose Cube: Sales Ragged, Measure: Store Cost Unit Sales and Dimension: Time to build a report. The report builds success. But when I choose Drill Through, then click on cell to open the drill through window, a Error has happened.
It notices that "Unhandled exception has occurred, Please see the log for more details : ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed."
The log shows that
11:06:25.325 ERROR [Pivot4JExceptionHandler] - Unhandled exception has occurred
javax.el.ELException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error in drill through; sql=[select "store"."store_sqft" as "Store Sqft", "store"."store_type" as "Store Type", "time_by_day"."the_year" as "Year", "time_by_day"."quarter" as "Quarter", "time_by_day"."month_of_year" as "Month", "time_by_day"."week_of_year" as "Week", "time_by_day"."day_of_month" as "Day", "product_class"."product_family" as "Product Family", "product_class"."product_department" as "Product Department", "product_class"."product_category" as "Product Category", "product_class"."product_subcategory" as "Product Subcategory", "product"."brand_name" as "Brand Name", "product"."product_name" as "Product Name", "promotion"."media_type" as "Media Type", "promotion"."promotion_name" as "Promotion Name", "customer"."country" as "Country", "customer"."state_province" as "State Province", "customer"."city" as "City", "customer"."education" as "Education Level", "customer"."gender" as "Gender", "customer"."marital_status" as "Marital Status", "customer"."yearly_income" as "Yearly Income", "store_ragged"."store_country" as "Store Country", "store_ragged"."store_state" as "Store State", "store_ragged"."store_city" as "Store City", "store_ragged"."store_name" as "Store Name", "customer"."fullname" as "Name", "_dummy"."foo" as "Scenario", "sales_fact_1997"."store_cost" as "Store Cost" from "store" as "store", "sales_fact_1997" as "sales_fact_1997", "time_by_day" as "time_by_day", "product_class" as "product_class", "product" as "product", "promotion" as "promotion", "customer" as "customer", "store_ragged" as "store_ragged", (SELECT FROM (VALUES ) AS "t" ("foo")) as "_dummy" where "sales_fact_1997"."store_id" = "store"."store_id" and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" = 'Q1' and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" and "sales_fact_1997"."promotion_id" = "promotion"."promotion_id" and "sales_fact_1997"."customer_id" = "customer"."customer_id" and "sales_fact_1997"."store_id" = "store_ragged"."store_id" and "sales_fact_1997"."time_id" = "_dummy"."time_id" order by "store"."store_sqft" ASC, "store"."store_type" ASC, "time_by_day"."the_year" ASC, "time_by_day"."quarter" ASC, "time_by_day"."month_of_year" ASC, "time_by_day"."week_of_year" ASC, "time_by_day"."day_of_month" ASC, "product_class"."product_family" ASC, "product_class"."product_department" ASC, "product_class"."product_category" ASC, "product_class"."product_subcategory" ASC, "product"."brand_name" ASC, "product"."product_name" ASC, "promotion"."media_type" ASC, "promotion"."promotion_name" ASC, "customer"."country" ASC, "customer"."state_province" ASC, "customer"."city" ASC, "customer"."education" ASC, "customer"."gender" ASC, "customer"."marital_status" ASC, "customer"."yearly_income" ASC, "store_ragged"."store_country" ASC, "store_ragged"."store_state" ASC, "store_ragged"."store_city" ASC, "store_ragged"."store_name" ASC, "customer"."fullname" ASC, "_dummy"."foo" ASC]
at org.apache.el.parser.AstValue.invoke(AstValue.java:291) ~[jasper-el.jar:7.0.32]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) ~[jasper-el.jar:7.0.32]
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74) ~[myfaces-impl-2.2.3.jar:2.2.3]
at javax.faces.component.UICommand.broadcast(UICommand.java:120) ~[myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1172) ~[myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:365) ~[myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1656) ~[myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:862) ~[myfaces-api-2.2.3.jar:2.2.3]
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:42) ~[myfaces-impl-2.2.3.jar:2.2.3]
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:196) [myfaces-impl-2.2.3.jar:2.2.3]
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:143) [myfaces-impl-2.2.3.jar:2.2.3]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) [myfaces-api-2.2.3.jar:2.2.3]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.32]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.32]
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:67) [log4j-web-2.0.2.jar:2.0.2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.32]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.32]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.32]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.32]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.32]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.32]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.32]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929) [catalina.jar:7.0.32]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.32]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.32]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002) [tomcat-coyote.jar:7.0.32]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) [tomcat-coyote.jar:7.0.32]
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) [tomcat-coyote.jar:7.0.32]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_79]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_79]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error in drill through; sql=[select "store"."store_sqft" as "Store Sqft", "store"."store_type" as "Store Type", "time_by_day"."the_year" as "Year", "time_by_day"."quarter" as "Quarter", "time_by_day"."month_of_year" as "Month", "time_by_day"."week_of_year" as "Week", "time_by_day"."day_of_month" as "Day", "product_class"."product_family" as "Product Family", "product_class"."product_department" as "Product Department", "product_class"."product_category" as "Product Category", "product_class"."product_subcategory" as "Product Subcategory", "product"."brand_name" as "Brand Name", "product"."product_name" as "Product Name", "promotion"."media_type" as "Media Type", "promotion"."promotion_name" as "Promotion Name", "customer"."country" as "Country", "customer"."state_province" as "State Province", "customer"."city" as "City", "customer"."education" as "Education Level", "customer"."gender" as "Gender", "customer"."marital_status" as "Marital Status", "customer"."yearly_income" as "Yearly Income", "store_ragged"."store_country" as "Store Country", "store_ragged"."store_state" as "Store State", "store_ragged"."store_city" as "Store City", "store_ragged"."store_name" as "Store Name", "customer"."fullname" as "Name", "_dummy"."foo" as "Scenario", "sales_fact_1997"."store_cost" as "Store Cost" from "store" as "store", "sales_fact_1997" as "sales_fact_1997", "time_by_day" as "time_by_day", "product_class" as "product_class", "product" as "product", "promotion" as "promotion", "customer" as "customer", "store_ragged" as "store_ragged", (SELECT FROM (VALUES ) AS "t" ("foo")) as "_dummy" where "sales_fact_1997"."store_id" = "store"."store_id" and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" = 'Q1' and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" and "sales_fact_1997"."promotion_id" = "promotion"."promotion_id" and "sales_fact_1997"."customer_id" = "customer"."customer_id" and "sales_fact_1997"."store_id" = "store_ragged"."store_id" and "sales_fact_1997"."time_id" = "_dummy"."time_id" order by "store"."store_sqft" ASC, "store"."store_type" ASC, "time_by_day"."the_year" ASC, "time_by_day"."quarter" ASC, "time_by_day"."month_of_year" ASC, "time_by_day"."week_of_year" ASC, "time_by_day"."day_of_month" ASC, "product_class"."product_family" ASC, "product_class"."product_department" ASC, "product_class"."product_category" ASC, "product_class"."product_subcategory" ASC, "product"."brand_name" ASC, "product"."product_name" ASC, "promotion"."media_type" ASC, "promotion"."promotion_name" ASC, "customer"."country" ASC, "customer"."state_province" ASC, "customer"."city" ASC, "customer"."education" ASC, "customer"."gender" ASC, "customer"."marital_status" ASC, "customer"."yearly_income" ASC, "store_ragged"."store_country" ASC, "store_ragged"."store_state" ASC, "store_ragged"."store_city" ASC, "store_ragged"."store_name" ASC, "customer"."fullname" ASC, "_dummy"."foo" ASC]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:987) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap.Util.newInternal(Util.java:2410) ~[mondrian-3.12.0.2-208.jar:3.12.0.2-208]
at mondrian.olap.Util.newError(Util.java:2426) ~[mondrian-3.12.0.2-208.jar:3.12.0.2-208]
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:361) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?]
at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32]
... 30 more
Caused by: java.sql.SQLSyntaxErrorException: VALUES clause must contain at least one element. Empty elements are not allowed.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) ~[commons-dbcp-1.2.1.jar:1.2.1]
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?]
at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32]
... 30 more
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: VALUES clause must contain at least one element. Empty elements are not allowed.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) ~[commons-dbcp-1.2.1.jar:1.2.1]
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?]
at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32]
... 30 more
Caused by: org.apache.derby.iapi.error.StandardException: VALUES clause must contain at least one element. Empty elements are not allowed.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.rowValueConstructorElement(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.rowValueConstructor(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableValueConstructorList(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableValueConstructor(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.subquery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableSubquery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.derivedTable(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableFactor(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableReference(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableReferenceTypes(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.dummyTableReferenceRule(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.fromClause(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableExpression(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.querySpecification(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.subquery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableSubquery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.derivedTable(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableFactor(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableReference(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableReferenceTypes(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.dummyTableReferenceRule(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.fromClause(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.tableExpression(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.querySpecification(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.preparableSelectStatement(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.preparableSQLDataStatement(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.StatementPart(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.SQLParser.Statement(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) ~[commons-dbcp-1.2.1.jar:1.2.1]
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?]
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?]
at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?]
at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?]
at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32]
... 30 more
Hi, I hava choose Cube: Sales Ragged, Measure: Store Cost Unit Sales and Dimension: Time to build a report. The report builds success. But when I choose Drill Through, then click on cell to open the drill through window, a Error has happened. It notices that "Unhandled exception has occurred, Please see the log for more details : ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed."
The log shows that 11:06:25.325 ERROR [Pivot4JExceptionHandler] - Unhandled exception has occurred javax.el.ELException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error in drill through; sql=[select "store"."store_sqft" as "Store Sqft", "store"."store_type" as "Store Type", "time_by_day"."the_year" as "Year", "time_by_day"."quarter" as "Quarter", "time_by_day"."month_of_year" as "Month", "time_by_day"."week_of_year" as "Week", "time_by_day"."day_of_month" as "Day", "product_class"."product_family" as "Product Family", "product_class"."product_department" as "Product Department", "product_class"."product_category" as "Product Category", "product_class"."product_subcategory" as "Product Subcategory", "product"."brand_name" as "Brand Name", "product"."product_name" as "Product Name", "promotion"."media_type" as "Media Type", "promotion"."promotion_name" as "Promotion Name", "customer"."country" as "Country", "customer"."state_province" as "State Province", "customer"."city" as "City", "customer"."education" as "Education Level", "customer"."gender" as "Gender", "customer"."marital_status" as "Marital Status", "customer"."yearly_income" as "Yearly Income", "store_ragged"."store_country" as "Store Country", "store_ragged"."store_state" as "Store State", "store_ragged"."store_city" as "Store City", "store_ragged"."store_name" as "Store Name", "customer"."fullname" as "Name", "_dummy"."foo" as "Scenario", "sales_fact_1997"."store_cost" as "Store Cost" from "store" as "store", "sales_fact_1997" as "sales_fact_1997", "time_by_day" as "time_by_day", "product_class" as "product_class", "product" as "product", "promotion" as "promotion", "customer" as "customer", "store_ragged" as "store_ragged", (SELECT FROM (VALUES ) AS "t" ("foo")) as "_dummy" where "sales_fact_1997"."store_id" = "store"."store_id" and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" = 'Q1' and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" and "sales_fact_1997"."promotion_id" = "promotion"."promotion_id" and "sales_fact_1997"."customer_id" = "customer"."customer_id" and "sales_fact_1997"."store_id" = "store_ragged"."store_id" and "sales_fact_1997"."time_id" = "_dummy"."time_id" order by "store"."store_sqft" ASC, "store"."store_type" ASC, "time_by_day"."the_year" ASC, "time_by_day"."quarter" ASC, "time_by_day"."month_of_year" ASC, "time_by_day"."week_of_year" ASC, "time_by_day"."day_of_month" ASC, "product_class"."product_family" ASC, "product_class"."product_department" ASC, "product_class"."product_category" ASC, "product_class"."product_subcategory" ASC, "product"."brand_name" ASC, "product"."product_name" ASC, "promotion"."media_type" ASC, "promotion"."promotion_name" ASC, "customer"."country" ASC, "customer"."state_province" ASC, "customer"."city" ASC, "customer"."education" ASC, "customer"."gender" ASC, "customer"."marital_status" ASC, "customer"."yearly_income" ASC, "store_ragged"."store_country" ASC, "store_ragged"."store_state" ASC, "store_ragged"."store_city" ASC, "store_ragged"."store_name" ASC, "customer"."fullname" ASC, "_dummy"."foo" ASC] at org.apache.el.parser.AstValue.invoke(AstValue.java:291) ~[jasper-el.jar:7.0.32] at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) ~[jasper-el.jar:7.0.32] at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74) ~[myfaces-impl-2.2.3.jar:2.2.3] at javax.faces.component.UICommand.broadcast(UICommand.java:120) ~[myfaces-api-2.2.3.jar:2.2.3] at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1172) ~[myfaces-api-2.2.3.jar:2.2.3] at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:365) ~[myfaces-api-2.2.3.jar:2.2.3] at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1656) ~[myfaces-api-2.2.3.jar:2.2.3] at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:862) ~[myfaces-api-2.2.3.jar:2.2.3] at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:42) ~[myfaces-impl-2.2.3.jar:2.2.3] at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:196) [myfaces-impl-2.2.3.jar:2.2.3] at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:143) [myfaces-impl-2.2.3.jar:2.2.3] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) [myfaces-api-2.2.3.jar:2.2.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.32] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:67) [log4j-web-2.0.2.jar:2.0.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.32] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.32] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.32] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.32] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.32] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) [catalina.jar:7.0.32] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929) [catalina.jar:7.0.32] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.32] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.32] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002) [tomcat-coyote.jar:7.0.32] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) [tomcat-coyote.jar:7.0.32] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) [tomcat-coyote.jar:7.0.32] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_79] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_79] at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79] Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error in drill through; sql=[select "store"."store_sqft" as "Store Sqft", "store"."store_type" as "Store Type", "time_by_day"."the_year" as "Year", "time_by_day"."quarter" as "Quarter", "time_by_day"."month_of_year" as "Month", "time_by_day"."week_of_year" as "Week", "time_by_day"."day_of_month" as "Day", "product_class"."product_family" as "Product Family", "product_class"."product_department" as "Product Department", "product_class"."product_category" as "Product Category", "product_class"."product_subcategory" as "Product Subcategory", "product"."brand_name" as "Brand Name", "product"."product_name" as "Product Name", "promotion"."media_type" as "Media Type", "promotion"."promotion_name" as "Promotion Name", "customer"."country" as "Country", "customer"."state_province" as "State Province", "customer"."city" as "City", "customer"."education" as "Education Level", "customer"."gender" as "Gender", "customer"."marital_status" as "Marital Status", "customer"."yearly_income" as "Yearly Income", "store_ragged"."store_country" as "Store Country", "store_ragged"."store_state" as "Store State", "store_ragged"."store_city" as "Store City", "store_ragged"."store_name" as "Store Name", "customer"."fullname" as "Name", "_dummy"."foo" as "Scenario", "sales_fact_1997"."store_cost" as "Store Cost" from "store" as "store", "sales_fact_1997" as "sales_fact_1997", "time_by_day" as "time_by_day", "product_class" as "product_class", "product" as "product", "promotion" as "promotion", "customer" as "customer", "store_ragged" as "store_ragged", (SELECT FROM (VALUES ) AS "t" ("foo")) as "_dummy" where "sales_fact_1997"."store_id" = "store"."store_id" and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" = 'Q1' and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" and "sales_fact_1997"."promotion_id" = "promotion"."promotion_id" and "sales_fact_1997"."customer_id" = "customer"."customer_id" and "sales_fact_1997"."store_id" = "store_ragged"."store_id" and "sales_fact_1997"."time_id" = "_dummy"."time_id" order by "store"."store_sqft" ASC, "store"."store_type" ASC, "time_by_day"."the_year" ASC, "time_by_day"."quarter" ASC, "time_by_day"."month_of_year" ASC, "time_by_day"."week_of_year" ASC, "time_by_day"."day_of_month" ASC, "product_class"."product_family" ASC, "product_class"."product_department" ASC, "product_class"."product_category" ASC, "product_class"."product_subcategory" ASC, "product"."brand_name" ASC, "product"."product_name" ASC, "promotion"."media_type" ASC, "promotion"."promotion_name" ASC, "customer"."country" ASC, "customer"."state_province" ASC, "customer"."city" ASC, "customer"."education" ASC, "customer"."gender" ASC, "customer"."marital_status" ASC, "customer"."yearly_income" ASC, "store_ragged"."store_country" ASC, "store_ragged"."store_state" ASC, "store_ragged"."store_city" ASC, "store_ragged"."store_name" ASC, "customer"."fullname" ASC, "_dummy"."foo" ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:987) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap.Util.newInternal(Util.java:2410) ~[mondrian-3.12.0.2-208.jar:3.12.0.2-208] at mondrian.olap.Util.newError(Util.java:2426) ~[mondrian-3.12.0.2-208.jar:3.12.0.2-208] at mondrian.rolap.SqlStatement.handle(SqlStatement.java:361) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?] at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79] at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32] ... 30 more Caused by: java.sql.SQLSyntaxErrorException: VALUES clause must contain at least one element. Empty elements are not allowed. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) ~[commons-dbcp-1.2.1.jar:1.2.1] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?] at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79] at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32] ... 30 more Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: VALUES clause must contain at least one element. Empty elements are not allowed. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) ~[commons-dbcp-1.2.1.jar:1.2.1] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?] at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79] at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32] ... 30 more Caused by: org.apache.derby.iapi.error.StandardException: VALUES clause must contain at least one element. Empty elements are not allowed. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.rowValueConstructorElement(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.rowValueConstructor(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableValueConstructorList(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableValueConstructor(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.subquery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableSubquery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.derivedTable(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableFactor(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableReference(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableReferenceTypes(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.dummyTableReferenceRule(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.fromClause(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableExpression(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.querySpecification(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.subquery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableSubquery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.derivedTable(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableFactor(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableReference(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableReferenceTypes(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.dummyTableReferenceRule(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.fromClause(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.tableExpression(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.querySpecification(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.simpleTable(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryPrimary(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.nonJoinQueryTerm(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.queryExpression(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.preparableSelectStatement(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.preparableSQLDataStatement(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.StatementPart(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.SQLParser.Statement(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) ~[derby-10.10.2.0.jar:?] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) ~[commons-dbcp-1.2.1.jar:1.2.1] at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:488) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:165) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:98) ~[mondrian-3.12.0.2-208.jar:?] at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.12.0.2-208.jar:?] at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:203) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:83) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.transform.impl.DrillThroughImpl.drillThrough(DrillThroughImpl.java:63) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT] at org.pivot4j.analytics.ui.DrillThroughDataModel.execute(DrillThroughDataModel.java:161) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughDataModel.initialize(DrillThroughDataModel.java:96) ~[DrillThroughDataModel.class:?] at org.pivot4j.analytics.ui.DrillThroughHandler.update(DrillThroughHandler.java:69) ~[DrillThroughHandler.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:977) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler$DrillThroughCommandImpl.execute(ViewHandler.java:956) ~[ViewHandler$DrillThroughCommandImpl.class:?] at org.pivot4j.analytics.ui.ViewHandler.executeCommand(ViewHandler.java:641) ~[ViewHandler.class:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79] at org.apache.el.parser.AstValue.invoke(AstValue.java:278) ~[jasper-el.jar:7.0.32] ... 30 more