org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "ORDERFACT"."QUANTITYORDERED", "ORDERFACT"."PRICEEACH", "ORDERFACT"."ORDERLINENUMBER", "ORDERFACT"."TOTALPRICE", "ORDERFACT"."SHIPPEDDATE", "ORDERFACT"."STATUS", "PRODUCTS"."PRODUCTNAME", "PRODUCTS"."PRODUCTCODE", "ORDERFACT"."PRODUCTCODE", "PRODUCTS"."PRODUCTLINE" FROM "PRODUCTS" INNER JOIN "ORDERFACT" ON "PRODUCTS"."PRODUCTCODE" = "ORDERFACT"."PRODUCTCODE" WHERE "ORDERFACT"."STATUS" <> 'Shipped' AND "PRODUCTS"."PRODUCTLINE" = 'Ships' GROUP BY "ORDERFACT"."STATUS" ORDER BY "ORDERFACT"."STATUS" ASC

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Jem Matzan, 1 year ago
", "PRODUCTS"."PRODUCTCODE", "ORDERFACT"."PRODUCTCODE", "PRODUCTS"."PRODUCTLINE" FROM "PRODUCTS" INNER JOIN "ORDERFACT" ON "PRODUCTS"."PRODUCTCODE" = "ORDERFACT"."PRODUCTCODE" WHERE "ORDERFACT"."STATUS" <> 'Shipped' AND "PRODUCTS"."PRODUCTLINE" = 'Ships' GROUP BY "ORDERFACT"."STATUS" ORDER BY "ORDERFACT"."STATUS" ASC
via Pentaho BI Platform Tracking by Jem Matzan, 1 year ago
", "PRODUCTS"."PRODUCTCODE", "ORDERFACT"."PRODUCTCODE", "PRODUCTS"."PRODUCTLINE" FROM "PRODUCTS" INNER JOIN "ORDERFACT" ON "PRODUCTS"."PRODUCTCODE" = "ORDERFACT"."PRODUCTCODE" WHERE "ORDERFACT"."STATUS" <> 'Shipped' AND "PRODUCTS"."PRODUCTLINE" = 'Ships' GROUP BY "ORDERFACT"."STATUS" ORDER BY "ORDERFACT"."STATUS" ASC
via Stack Overflow by akiong
, 1 year ago
as relasi, a.purchase_no as trx_no, 'D' as dt, 0 as debet, a.total_amount as kredit from purchase_invoice a LEFT JOIN supplier b ON a.supplier_id = b.id LEFT JOIN group_supplier c ON b.group_supplier_id = c.id LEFT JOIN account d ON c.uang_muka_id = d.id GROUP BY a.purchase_no ) ffasdff WHERE id =${acid} AND trx_date < ${dateFrom}
via Pentaho BI Platform Tracking by David Kincade, 1 year ago
Failed at query: select foo from bar
via Pentaho BI Platform Tracking by David Kincade, 1 year ago
Failed at query: select foo from bar
via Pentaho BI Platform Tracking by Kurtis Cruzada, 1 year ago
Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE"
org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "ORDERFACT"."QUANTITYORDERED", "ORDERFACT"."PRICEEACH", "ORDERFACT"."ORDERLINENUMBER", "ORDERFACT"."TOTALPRICE", "ORDERFACT"."SHIPPEDDATE", "ORDERFACT"."STATUS", "PRODUCTS"."PRODUCTNAME", "PRODUCTS"."PRODUCTCODE", "ORDERFACT"."PRODUCTCODE", "PRODUCTS"."PRODUCTLINE" FROM "PRODUCTS" INNER JOIN "ORDERFACT" ON "PRODUCTS"."PRODUCTCODE" = "ORDERFACT"."PRODUCTCODE" WHERE "ORDERFACT"."STATUS" <> 'Shipped' AND "PRODUCTS"."PRODUCTLINE" = 'Ships' GROUP BY "ORDERFACT"."STATUS" ORDER BY "ORDERFACT"."STATUS" ASC
at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:138)
at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:88)
at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryInternal(CachingDataFactory.java:168)
at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.queryData(CachingDataFactory.java:143)
at org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData(CascadingDataFactory.java:81)
at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:185)
at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.(ProcessState.java:255)
at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:375)
at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:77)
at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:261)
at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.