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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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