java.lang.reflect.InvocationTargetException: Unable to get fields for step [OLAP Input 2] : Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312)

Pentaho BI Platform Tracking | gunter rombauts | 6 years ago
  1. 0

    Use the attached transformation. Select olap input step and do a show output fields. java.lang.reflect.InvocationTargetException: Unable to get fields for step [OLAP Input 2] : Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:73) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleStepException: Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields(OlapInputMeta.java:139) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1886) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1663) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:68) ... 1 more Caused by: java.lang.NullPointerException at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData(OlapInputMeta.java:312) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields(OlapInputMeta.java:133) ... 5 more

    Pentaho BI Platform Tracking | 6 years ago | gunter rombauts
    java.lang.reflect.InvocationTargetException: Unable to get fields for step [OLAP Input 2] : Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312)
  2. 0

    Use the attached transformation. Select olap input step and do a show output fields. java.lang.reflect.InvocationTargetException: Unable to get fields for step [OLAP Input 2] : Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:73) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleStepException: Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields(OlapInputMeta.java:139) at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1886) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1663) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:68) ... 1 more Caused by: java.lang.NullPointerException at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData(OlapInputMeta.java:312) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields(OlapInputMeta.java:133) ... 5 more

    Pentaho BI Platform Tracking | 6 years ago | gunter rombauts
    java.lang.reflect.InvocationTargetException: Unable to get fields for step [OLAP Input 2] : Unable to get query result for MDX query: SELECT NON EMPTY Hierarchize(Union(Crossjoin({[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}), Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}, Union(Crossjoin([Region].[All Regions].Children, {[Department].[All Departments]}), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS, NON EMPTY Hierarchize(Union({[Positions].[All Positions]}, [Positions].[All Positions].Children)) ON ROWS from [Quadrant Analysis] at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113) at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run (SearchFieldsProgressDialog.java:68) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1663) at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1741) at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1886) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields (OlapInputMeta.java:133) at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData (OlapInputMeta.java:312)
  3. 0

    Android: Saving Map State in Google map

    Stack Overflow | 11 months ago | Junie Negentien
    java.lang.RuntimeException: Unable to resume activity {com.ourThesis.junieNegentien2015/com.ourThesis.junieNegentien2015.MainActivity}: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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.lang.NullPointerException

      No message provided

      at org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData()
    2. org.pentaho.di
      SearchFieldsProgressDialog.run
      1. org.pentaho.di.trans.steps.olapinput.OlapInputMeta.initData(OlapInputMeta.java:312)
      2. org.pentaho.di.trans.steps.olapinput.OlapInputMeta.getFields(OlapInputMeta.java:133)
      3. org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1886)
      4. org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1741)
      5. org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1663)
      6. org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:68)
      6 frames
    3. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame