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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • SUMMARY: Commenting out a piece of SQL that includes parameter e.g. ${PARAM} will cause reports to stop working. I expected the parameter to be ignored because it is commented out. Tested on Trunk snapshot as at 15-Oct-2009. TO REPRODUCE: 1. Open "samples\Operational Reports\Open Inventory.prpt" in PRD. 2. Check report runs OK 3. Edit the "default" data set and change the query to read as below. SELECT PRODUCTS.PRODUCTLINE, PRODUCTS.PRODUCTVENDOR, PRODUCTS.PRODUCTCODE, PRODUCTS.PRODUCTNAME, PRODUCTS.PRODUCTSCALE, PRODUCTS.PRODUCTDESCRIPTION, PRODUCTS.QUANTITYINSTOCK, PRODUCTS.BUYPRICE, PRODUCTS.MSRP FROM PRODUCTS /* COMMENTING OUT THIS RESTRICTION WHERE PRODUCTS.PRODUCTLINE IN (${line}) */ ORDER BY PRODUCTLINE ASC, PRODUCTVENDOR ASC, PRODUCTCODE ASC 4. Click the "Preview" button in the JDBC Data Source window. EXPECTED RESULT: Preview listing of all the fields for the full data set ACTUAL RESULT: The following error is received. The report doesn't work at all anymore. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:402) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619) ParentException: java.sql.SQLException: socket creation error 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:185) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:97) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:77) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.JndiConnectionProvider.getConnection(JndiConnectionProvider.java:103) at org.pentaho.reporting.ui.datasources.jdbc.connection.JndiConnectionDefinition.createConnection(JndiConnectionDefinition.java:122) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker$PreviewConnectionProvider.getConnection(JdbcPreviewWorker.java:66) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:91) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:397) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619)
    via by Phillip Cole,
  • SUMMARY: Commenting out a piece of SQL that includes parameter e.g. ${PARAM} will cause reports to stop working. I expected the parameter to be ignored because it is commented out. Tested on Trunk snapshot as at 15-Oct-2009. TO REPRODUCE: 1. Open "samples\Operational Reports\Open Inventory.prpt" in PRD. 2. Check report runs OK 3. Edit the "default" data set and change the query to read as below. SELECT PRODUCTS.PRODUCTLINE, PRODUCTS.PRODUCTVENDOR, PRODUCTS.PRODUCTCODE, PRODUCTS.PRODUCTNAME, PRODUCTS.PRODUCTSCALE, PRODUCTS.PRODUCTDESCRIPTION, PRODUCTS.QUANTITYINSTOCK, PRODUCTS.BUYPRICE, PRODUCTS.MSRP FROM PRODUCTS /* COMMENTING OUT THIS RESTRICTION WHERE PRODUCTS.PRODUCTLINE IN (${line}) */ ORDER BY PRODUCTLINE ASC, PRODUCTVENDOR ASC, PRODUCTCODE ASC 4. Click the "Preview" button in the JDBC Data Source window. EXPECTED RESULT: Preview listing of all the fields for the full data set ACTUAL RESULT: The following error is received. The report doesn't work at all anymore. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:402) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619) ParentException: java.sql.SQLException: socket creation error 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:185) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:97) at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:77) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.JndiConnectionProvider.getConnection(JndiConnectionProvider.java:103) at org.pentaho.reporting.ui.datasources.jdbc.connection.JndiConnectionDefinition.createConnection(JndiConnectionDefinition.java:122) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker$PreviewConnectionProvider.getConnection(JdbcPreviewWorker.java:66) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:91) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:397) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619)
    via by Phillip Cole,
  • Call Stored Procedure in Pentaho Reporting
    via by Unknown author,
  • Parameter - Reports Designer (Oracle DB)
    via by Unknown author,
    • org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:402) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139) at java.lang.Thread.run(Thread.java:619)
    No Bugmate found.