mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"]

Pentaho BI Platform Tracking | Julian Hyde | 9 years ago
  1. 0

    A StarColumnPredicate references RolapStar.Column when used in an AggStar. The result is that the incorrect SQL is generated. For example, set Bug.<thisbug>Fixed=true and run mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount3 with aggregates enabled, and you get the following error. mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1104) at mondrian.olap.Util.newError(Util.java:1120) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:284) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:245) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:337) at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:74) ... Note that "time_by_day"."quarter" occurs in the query. This column from the regular star schema is used in a predicate, but the predicate should have been translated to refer to columns in the AggStar. One way to fix this would do the long-deferred unification of RolapStar and AggStar. The class AggStar.Table.Column would go away, so predicates in an AggStar query could legimately refer to RolapStar.Column objects.

    Pentaho BI Platform Tracking | 9 years ago | Julian Hyde
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"]
  2. 0

    A StarColumnPredicate references RolapStar.Column when used in an AggStar. The result is that the incorrect SQL is generated. For example, set Bug.<thisbug>Fixed=true and run mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount3 with aggregates enabled, and you get the following error. mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1104) at mondrian.olap.Util.newError(Util.java:1120) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:284) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:245) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:337) at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:74) ... Note that "time_by_day"."quarter" occurs in the query. This column from the regular star schema is used in a predicate, but the predicate should have been translated to refer to columns in the AggStar. One way to fix this would do the long-deferred unification of RolapStar and AggStar. The class AggStar.Table.Column would go away, so predicates in an AggStar query could legimately refer to RolapStar.Column objects.

    Pentaho BI Platform Tracking | 9 years ago | Julian Hyde
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"]
  3. 0

    Table alias when creating a MeasureExpression in Mondrian 4

    Stack Overflow | 2 years ago
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select `v_dm_calendar`.`calendar_date` as `c0`, count(distinct CASE WHEN > 0 THEN 1 END) as `m0` from `v_dm_calendar` as `v_dm_calendar`, `fc_customer_activity_sportsbook` as `fc_customer_activity_sportsbook` where `fc_customer_activity_sportsbook`.`bet_date` = `v_dm_calendar`.`calendar_date` and `v_dm_calendar`.`calendar_date` = '2015-03-30' group by `v_dm_calendar`.`calendar_date`]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Jasper OLAP desinger 4.0 connection with hive

    Stack Overflow | 2 years ago | yyny
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:hive2://xxx.xxxx.xxx.xxxx:10000/default?autocommit=false; JdbcUser=hive; JdbcPassword=hive
  6. 0

    Error : Error Di BI Server

    Google Groups | 5 years ago | Bambang Sistriadianto
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.apache.tomcat.dbcp.dbcp.BasicDataSource@67c8f3da

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

      Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"]

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
      1 frame
    3. mondrian.olap
      Util.newError
      1. mondrian.olap.Util.newInternal(Util.java:1104)
      2. mondrian.olap.Util.newError(Util.java:1120)
      2 frames
    4. mondrian.rolap
      RolapUtil.executeQuery
      1. mondrian.rolap.SqlStatement.handle(SqlStatement.java:208)
      2. mondrian.rolap.SqlStatement.execute(SqlStatement.java:138)
      3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:284)
      4. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:245)
      4 frames
    5. mondrian.rolap.agg
      SegmentLoader.load
      1. mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:337)
      2. mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:74)
      2 frames