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

Pentaho BI Platform Tracking | hhaas | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The following MDX causes an exception select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON columns, ToggleDrillState({([Promotion Media].[All Media]. [Radio], [Product].[All Products].[Drink].[Alcoholic Beverages]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages].[Carbonated Beverages]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages].[Drinks]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored Drinks]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages].[Hot Beverages]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages].[Pure Juice Beverages]), ([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Dairy]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Alcoholic Beverages]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Beverages]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Beverages].[Carbonated Beverages]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Beverages].[Drinks]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored Drinks]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Beverages].[Hot Beverages]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Beverages].[Pure Juice Beverages]), ([Promotion Media].[All Media].[TV], [Product].[All Products].[Drink].[Dairy]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Alcoholic Beverages]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Beverages]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Beverages].[Carbonated Beverages]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Beverages].[Drinks]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Beverages].[Drinks]. [Flavored Drinks]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Beverages].[Hot Beverages]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Beverages].[Pure Juice Beverages]), ([Promotion Media].[All Media].[Sunday Paper], [Product].[All Products].[Drink].[Dairy]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Alcoholic Beverages]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Beverages]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Beverages].[Carbonated Beverages]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Beverages].[Drinks]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Beverages].[Drinks]. [Flavored Drinks]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Beverages].[Hot Beverages]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Beverages].[Pure Juice Beverages]), ([Promotion Media].[All Media].[Street Handout], [Product].[All Products].[Drink].[Dairy])}, {[Product].[All Products].[Drink].[Beverages].[Drinks]. [Flavored Drinks]}) ON rows from [Sales] where ([Time].[1997]) shorter, Java: String mdxQuery = "select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON columns,"+ "ToggleDrillState({"+ "([Promotion Media].[All Media].[Radio], [Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored Drinks])"+ "}, {[Product].[All Products].[Drink].[Beverages]. [Drinks].[Flavored Drinks]}) ON rows "+ "from [Sales] where ([Time].[1997])"; works fine with Microsoft MDX the call stack is: com.tonbeller.jpivot.olap.model.OlapException: 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`] com.tonbeller.jpivot.olap.model.OlapException: 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.executeQu ery(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.readMemberChildre n(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.executeQu ery(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

    Pentaho BI Platform Tracking | 1 decade ago | hhaas
    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`]

    Root Cause Analysis

    1. java.sql.SQLException

      [Microsoft][ODBC Microsoft Access Driver] 4 Parameter wurden erwartet, aber es wurden zu wenig Parameter ´┐Żbergeben.

      at mondrian.rolap.RolapUtil.executeQuery()
    2. mondrian.rolap
      RolapMember.getMemberChildren
      1. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:151)
      2. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:535)
      3. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:518)
      4. mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:235)
      5. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:154)
      6. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:127)
      7. mondrian.rolap.RolapHierarchy.getChildMembers(RolapHierarchy.java:331)
      8. mondrian.rolap.RolapMember.getMemberChildren(RolapMember.java:70)
      8 frames
    3. mondrian.olap.fun
      FunkFunDef.evaluate
      1. mondrian.olap.fun.BuiltinFunTable$54.evaluate(BuiltinFunTable.java:1994)
      2. mondrian.olap.fun.FunkFunDef.evaluate(MultiResolver.java:93)
      2 frames
    4. mondrian.rolap
      RolapEvaluator.xx
      1. mondrian.rolap.RolapEvaluator.xx(RolapEvaluator.java:116)
      1 frame
    5. mondrian.olap
      FunCall.evaluate
      1. mondrian.olap.FunCall.evaluate(FunCall.java:244)
      1 frame
    6. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:154)
      2. mondrian.rolap.RolapResult.<init>(RolapResult.java:70)
      3. mondrian.rolap.RolapConnection.execute(RolapConnection.java:99)
      3 frames
    7. com.tonbeller.jpivot
      HHTest.main
      1. com.tonbeller.jpivot.mondrian.MondrianResult.executeQuery(MondrianResult.java:32)
      2. com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:114)
      3. com.tonbeller.jpivot.mondrian.HHTest.main(HHTest.java:111)
      3 frames