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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web8

  • via Pentaho BI Platform Tracking by hhaas, 9 months 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
  • via Pentaho BI Platform Tracking by Julian Hyde, 9 months ago
    Internal error: Error while executing query [select {[Measures]. [Unit Sales]} ON columns, Order(Except([Promotion Media].[Media Type].Members, {[Promotion Media].[All Media].[No Media]}), [Measures].[Unit Sales], DESC) ON rows from [Sales] where ([Time].[1997], [Customers]) ]
  • via Pentaho BI Platform Tracking by Julian Hyde, 1 year ago
    Internal error: Error while executing query [select {[Measures]. [Unit Sales]} ON columns, Order(Except([Promotion Media].[Media Type].Members, {[Promotion Media].[All Media].[No Media]}), [Measures].[Unit Sales], DESC) ON rows from [Sales] where ([Time].[1997], [Customers]) ]
  • Stack trace

    • 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 com.tonbeller.jpivot.mondrian.MondrianResult.executeQuery(MondrianResult.java:36) at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:114) at com.tonbeller.jpivot.mondrian.HHTest.main(HHTest.java:111) Caused by: 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.olap.MondrianResource.newInternal(MondrianResource.java:45) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:551) 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.<init>(RolapResult.java:70) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:99) at com.tonbeller.jpivot.mondrian.MondrianResult.executeQuery(MondrianResult.java:32) ... 2 more Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 4 Parameter wurden erwartet, aber es wurden zu wenig Parameter �bergeben. at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:151) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:535) ... 16 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.