mondrian.resource.ChainableRuntimeException: Internal error: while building member cache; sql=[select `product`.`brand_name` as `c0` from `product` as `product` where `product_class`.`product_subcategory` = 'Flavored Drinks' and `product_class`.`product_category` = 'Drinks' and `product_class`.`product_department` = 'Beverages' and `product_class`.`product_family` = 'Drink' group by `product`.`brand_name` order by `product`.`brand_name`]

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 hhaas, 1 year ago
Internal error: while building member cache; sql=[select `product`.`brand_name` as `c0` from `product` as `product` where `product_class`.`product_subcategory` = 'Flavored Drinks' and `product_class`.`product_category` = 'Drinks' and
mondrian.resource.ChainableRuntimeException: Internal error: while building member cache; sql=[select `product`.`brand_name` as `c0` from `product` as `product` where `product_class`.`product_subcategory` = 'Flavored Drinks' and `product_class`.`product_category` = 'Drinks' and `product_class`.`product_department` = 'Beverages' and `product_class`.`product_family` = 'Drink' group by `product`.`brand_name` order by `product`.`brand_name`]
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:151)
at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:535)
at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:518)
at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:235)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:154)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:127)
at mondrian.rolap.RolapHierarchy.getChildMembers(RolapHierarchy.java:331)
at mondrian.rolap.RolapMember.getMemberChildren(RolapMember.java:70)
at mondrian.olap.fun.BuiltinFunTable$54.evaluate(BuiltinFunTable.java:1994)
at mondrian.olap.fun.FunkFunDef.evaluate(MultiResolver.java:93)
at mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:116)
at mondrian.olap.FunCall.evaluate(FunCall.java:244)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:154)
at mondrian.rolap.RolapResult.(RolapResult.java:70)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:99)
at com.tonbeller.jpivot.mondrian.MondrianResult.executeQuery(MondrianResult.java:32)
at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:114)
at com.tonbeller.jpivot.mondrian.HHTest.main(HHTest.java:111)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

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