org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: No such query: <?xml version="1.0" encoding="UTF-8"?> <mql><domain_id>steel-wheels</domain_id><model_id>BV_ORDERS</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>BC_CUSTOMER_W_TER_</view><column>BC_CUSTOMER_W_TER_TERRITORY</column><aggregation>NONE</aggregation></selection><selection><view>CAT_ORDERS</view><column>BC_ORDERDETAILS_TOTAL</column><aggregation>SUM</aggregation></selection></selections><constraints/><orders/></mql>

Pentaho BI Platform Tracking | Kurtis Cruzada | 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

    When I hit preview, I get the following error. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: No such query: <?xml version="1.0" encoding="UTF-8"?> <mql><domain_id>steel-wheels</domain_id><model_id>BV_ORDERS</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>BC_CUSTOMER_W_TER_</view><column>BC_CUSTOMER_W_TER_TERRITORY</column><aggregation>NONE</aggregation></selection><selection><view>CAT_ORDERS</view><column>BC_ORDERDETAILS_TOTAL</column><aggregation>SUM</aggregation></selection></selections><constraints/><orders/></mql> at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:438) at org.pentaho.reporting.ui.datasources.pmd.PmdPreviewWorker.run(PmdPreviewWorker.java:98) at java.lang.Thread.run(Thread.java:613) However, I am able to view the report.

    Pentaho BI Platform Tracking | 8 years ago | Kurtis Cruzada
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: No such query: <?xml version="1.0" encoding="UTF-8"?> <mql><domain_id>steel-wheels</domain_id><model_id>BV_ORDERS</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>BC_CUSTOMER_W_TER_</view><column>BC_CUSTOMER_W_TER_TERRITORY</column><aggregation>NONE</aggregation></selection><selection><view>CAT_ORDERS</view><column>BC_ORDERDETAILS_TOTAL</column><aggregation>SUM</aggregation></selection></selections><constraints/><orders/></mql>
  2. 0

    When I hit preview, I get the following error. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: No such query: <?xml version="1.0" encoding="UTF-8"?> <mql><domain_id>steel-wheels</domain_id><model_id>BV_ORDERS</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>BC_CUSTOMER_W_TER_</view><column>BC_CUSTOMER_W_TER_TERRITORY</column><aggregation>NONE</aggregation></selection><selection><view>CAT_ORDERS</view><column>BC_ORDERDETAILS_TOTAL</column><aggregation>SUM</aggregation></selection></selections><constraints/><orders/></mql> at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:438) at org.pentaho.reporting.ui.datasources.pmd.PmdPreviewWorker.run(PmdPreviewWorker.java:98) at java.lang.Thread.run(Thread.java:613) However, I am able to view the report.

    Pentaho BI Platform Tracking | 8 years ago | Kurtis Cruzada
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: No such query: <?xml version="1.0" encoding="UTF-8"?> <mql><domain_id>steel-wheels</domain_id><model_id>BV_ORDERS</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>BC_CUSTOMER_W_TER_</view><column>BC_CUSTOMER_W_TER_TERRITORY</column><aggregation>NONE</aggregation></selection><selection><view>CAT_ORDERS</view><column>BC_ORDERDETAILS_TOTAL</column><aggregation>SUM</aggregation></selection></selections><constraints/><orders/></mql>

    Root Cause Analysis

    1. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException

      No such query: <?xml version="1.0" encoding="UTF-8"?> <mql><domain_id>steel-wheels</domain_id><model_id>BV_ORDERS</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>BC_CUSTOMER_W_TER_</view><column>BC_CUSTOMER_W_TER_TERRITORY</column><aggregation>NONE</aggregation></selection><selection><view>CAT_ORDERS</view><column>BC_ORDERDETAILS_TOTAL</column><aggregation>SUM</aggregation></selection></selections><constraints/><orders/></mql>

      at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData()
    2. org.pentaho.reporting
      PmdPreviewWorker.run
      1. org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:438)
      2. org.pentaho.reporting.ui.datasources.pmd.PmdPreviewWorker.run(PmdPreviewWorker.java:98)
      2 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:613)
      1 frame