[Jfreereport-developers] [JIRA] Created: (PRD-2661) prerpoc.prpt example in PRD does not work, produces an error

[Pentaho J. N. (do-not-reply) <ji...@pe...>]

prerpoc.prpt example in PRD does not work, produces an error
------------------------------------------------------------

                 Key: PRD-2661
                 URL: http://jira.pentaho.com/browse/PRD-2661
             Project: Pentaho Report Designer
          Issue Type: Bug
    Affects Versions: 3.6.1 RC1 [3.6.0 RC1 (Platform Release)]
         Environment: PRD nightly from 4/29/10, Ubuntu 9.10 x86, JRE 1.6.0 32-bit
            Reporter: Jem Matzan
            Assignee: Triage


Start Report Designer, select the Advanced samples folder, then open preproc.prpt within it. Click the preview icon.

org.pentaho.reporting.engine.classic.core.ReportProcessingException: Unable to initialize the report
	at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:553)
	at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:78)
	at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266)
	at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
ParentException: 
org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM Customers
	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:236)
	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:186)
	at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279)
	at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:460)
	at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:78)
	at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266)
	at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
ParentException: 
java.sql.SQLException: User not found: PENTAHO_USER
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
	at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbcDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:154)
	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider.createConnection(DriverConnectionProvider.java:114)
	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:181)
	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:264)
	at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:232)
	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:186)
	at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.<init>(ProcessState.java:279)
	at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:460)
	at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:78)
	at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:266)
	at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.pentaho.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira