org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS

Pentaho BI Platform Tracking | Jake Cornelius | 8 years 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

    Created a parameterized query adding a parameter called 'ProductLine' and a default value of 'Classic Cars' Hit preview, stack trace in console: Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS at org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:468) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:464) at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274) at org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104) at org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorS erviceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632) at org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuer y(SwtMqlEditor.java:145) at org.pentaho.pms.ui.QueryBuilderDialog.viewSql(QueryBuilderDialog.java :467) at org.pentaho.pms.ui.QueryBuilderDialog$6.widgetSelected(QueryBuilderDi alog.java:197) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732) at org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577) org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS at org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:468) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:464) at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274) at org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104) at org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorS erviceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632) at org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuer y(SwtMqlEditor.java:145) at org.pentaho.pms.ui.QueryBuilderDialog.viewMql(QueryBuilderDialog.java :454) at org.pentaho.pms.ui.QueryBuilderDialog.access$400(QueryBuilderDialog.j ava:51) at org.pentaho.pms.ui.QueryBuilderDialog$5.widgetSelected(QueryBuilderDi alog.java:187) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732) at org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577)

    Pentaho BI Platform Tracking | 8 years ago | Jake Cornelius
    org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS
  2. 0

    Created a parameterized query adding a parameter called 'ProductLine' and a default value of 'Classic Cars' Hit preview, stack trace in console: Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS at org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:468) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:464) at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274) at org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104) at org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorS erviceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632) at org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuer y(SwtMqlEditor.java:145) at org.pentaho.pms.ui.QueryBuilderDialog.viewSql(QueryBuilderDialog.java :467) at org.pentaho.pms.ui.QueryBuilderDialog$6.widgetSelected(QueryBuilderDi alog.java:197) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732) at org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577) org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS at org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:468) at org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormu la.java:464) at org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274) at org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104) at org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorS erviceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632) at org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuer y(SwtMqlEditor.java:145) at org.pentaho.pms.ui.QueryBuilderDialog.viewMql(QueryBuilderDialog.java :454) at org.pentaho.pms.ui.QueryBuilderDialog.access$400(QueryBuilderDialog.j ava:51) at org.pentaho.pms.ui.QueryBuilderDialog$5.widgetSelected(QueryBuilderDi alog.java:187) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732) at org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842) at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577)

    Pentaho BI Platform Tracking | 8 years ago | Jake Cornelius
    org.pentaho.pms.core.exception.PentahoMetadataException: PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS

    Root Cause Analysis

    1. org.pentaho.pms.core.exception.PentahoMetadataException

      PMSFormula.ERROR_0010 - Field Name param:ProductLine not found in Business Model. Column param:ProductL ine not found in Business Table BT_PRODUCTS_PRODUCTS

      at org.pentaho.pms.mql.PMSFormula.addField()
    2. org.pentaho.pms
      WhereCondition.<init>
      1. org.pentaho.pms.mql.PMSFormula.addField(PMSFormula.java:340)
      2. org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormula.java:468)
      3. org.pentaho.pms.mql.PMSFormula.validateAndResolveObjectModel(PMSFormula.java:464)
      4. org.pentaho.pms.mql.PMSFormula.parseAndValidate(PMSFormula.java:274)
      5. org.pentaho.pms.mql.WhereCondition.<init>(WhereCondition.java:104)
      5 frames
    3. org.pentaho.commons
      SwtMqlEditor.getMqlQuery
      1. org.pentaho.commons.metadata.mqleditor.editor.service.util.MQLEditorServiceCWMDelegate.convertModel(MQLEditorServiceCWMDelegate.java:632)
      2. org.pentaho.commons.metadata.mqleditor.editor.SwtMqlEditor.getMqlQuery(SwtMqlEditor.java:145)
      2 frames
    4. org.pentaho.pms
      QueryBuilderDialog$5.widgetSelected
      1. org.pentaho.pms.ui.QueryBuilderDialog.viewMql(QueryBuilderDialog.java:454)
      2. org.pentaho.pms.ui.QueryBuilderDialog.access$400(QueryBuilderDialog.java:51)
      3. org.pentaho.pms.ui.QueryBuilderDialog$5.widgetSelected(QueryBuilderDialog.java:187)
      3 frames
    5. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    6. JFace
      Window.open
      1. org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
      2. org.eclipse.jface.window.Window.open(Window.java:796)
      2 frames
    7. org.pentaho.pms
      MetaEditor$43.widgetSelected
      1. org.pentaho.pms.ui.MetaEditor.testQR(MetaEditor.java:3732)
      2. org.pentaho.pms.ui.MetaEditor$43.widgetSelected(MetaEditor.java:1261)
      2 frames
    8. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    9. org.pentaho.pms
      MetaEditor.main
      1. org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:842)
      2. org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3577)
      2 frames