org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error

Pentaho BI Platform Tracking | Phillip Cole | 7 years ago
  1. 0

    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)

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error
  2. 0

    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)

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed to open the connection: java.sql.SQLException: socket creation error
  3. 0

    Error in querying a remote Oracle Database from Pentaho Report Designer

    Stack Overflow | 5 years ago | Hidalgo
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select * from fact_table;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Pentaho - Couldn't find SQLSERVER drivers to connect

    Stack Overflow | 3 years ago | Yann Braga
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM Client;
  6. 0

    Call Stored Procedure in Pentaho Reporting

    pentaho.com | 1 year ago
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: exec cursorResultSet

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. org.pentaho.reporting
      JdbcPreviewWorker.run
      1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.open(SimpleSQLReportDataFactory.java:402)
      2. org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:139)
      2 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame