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"]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Julian Hyde, 1 year ago
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
via Pentaho BI Platform Tracking by Julian Hyde, 1 year ago
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
via Stack Overflow by Unknown author, 2 years ago
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
via GitHub by wingman-pentaho
, 9 months ago
Mondrian Error:Internal error: Error while executing query [select {[Measures].[Store Sales]} ON COLUMNS, Order(Filter(Descendants([Customers].[USA].[CA], [Customers].[Name]), ([Measures].[Store Sales] > 200.0)), [Measures].[Store Sales], DESC) ON ROWS from [Sales] where [Time].[1997] ]
via GitHub by wingman-pentaho
, 9 months ago
Mondrian Error:Internal error: Error while executing query [select {[Measures].[Store Sales]} ON COLUMNS, Order(Filter(Descendants([Customers].[USA].[CA], [Customers].[Name]), ([Measures].[Store Sales] > 200.0)), [Measures].[Store Sales], DESC) ON ROWS from [Sales] where [Time].[1997] ]
via Stack Overflow by yyny
, 2 years ago
Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:hive2://xxx.xxxx.xxx.xxxx:10000/default?autocommit=false; JdbcUser=hive; JdbcPassword=hive
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 week ago

Know the solutions? Share your knowledge to help other developers to debug faster.