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
  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`]
  2. 0

    Java JPA Hibernate Annotation Umlauts

    Stack Overflow | 3 years ago | Stefan Wendelmann
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    Access MS-Access Databases from Java - CodeProject

    codeproject.com | 5 months ago
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] ??????? '(?? ????)' ?? ????.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I got this error when i tried to open Ms Access database

    Oracle Community | 3 years ago | 71cf1ad8-907b-466f-bf66-3b851b6b0190
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] ??????? '(?? ????)' ?? ????.
  6. 0

    MS-Access and JDBC

    Google Groups | 2 decades ago | stil...@ryuji.net
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 4.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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