org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}

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 widelia, 1 year ago
Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}
via Pentaho BI Platform Tracking by widelia, 1 year ago
Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}
via pentaho.com by Unknown author, 2 years ago
Failed at query: { call cursorResultSet() }
via pentaho.com by Unknown author, 1 year ago
Failed at query: {call invoice_email_table_update(${email},${dealer},${period})}
via Stack Overflow by akiong
, 11 months ago
Failed at query: Select id, IFNULL(SUM(debet) - SUM(kredit),0) as saldoawal2 from ( SELECT g.id, g.code, a.trx_date, IF(a.trx_type = 1 OR a.trx_type = 2, a.relation,IF(a.trx_type = 3,e.name,IF(a.trx_type = 4,f.name, b.amount))) as
via Pentaho BI Platform Tracking by David Kincade, 1 year ago
Failed at query: select foo from bar
org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}
at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258)
at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:431)
at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:184)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130)
at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
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:188)
at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:260)
at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:477)
at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1647)
at org.pentaho.reporting.platform.plugin.output.PDFOutput.generate(PDFOutput.java:49)
at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1069)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

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