net.sf.jasperreports.engine.JRException: Error executing SQL statement for : boss_charterfaktura_document_list_interval_positions

tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Get row from table for last date before date parameter if no row for date parameter or entries null

    Database Administrators | 3 years ago | BuZZ-dEE
    net.sf.jasperreports.engine.JRException: Error executing SQL statement for : boss_charterfaktura_document_list_interval_positions

    Root Cause Analysis

    1. java.sql.SQLException

      java.lang.NullPointerException

      at com.hxtt.sql.dl.a()
    2. com.hxtt.sql
      dn.executeQuery
      1. com.hxtt.sql.dl.a(Unknown Source)
      2. com.hxtt.sql.c3.a(Unknown Source)
      3. com.hxtt.sql.aj.else(Unknown Source)
      4. com.hxtt.sql.aj.cm(Unknown Source)
      5. com.hxtt.sql.aj.s(Unknown Source)
      6. com.hxtt.sql.dl.a(Unknown Source)
      7. com.hxtt.sql.dl.a(Unknown Source)
      8. com.hxtt.sql.el.a(Unknown Source)
      9. com.hxtt.sql.dl.a(Unknown Source)
      10. com.hxtt.sql.br.a(Unknown Source)
      11. com.hxtt.sql.ai.a(Unknown Source)
      12. com.hxtt.sql.dn.executeQuery(Unknown Source)
      12 frames
    3. JasperReports
      JasperFillManager.fillReport
      1. net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239)
      2. net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086)
      3. net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)
      4. net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1253)
      5. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)
      6. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)
      7. net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
      8. net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
      9. net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)
      10. net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)
      10 frames
    4. com.jaspersoft.ireport
      IReportCompiler.run
      1. com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)
      1 frame
    5. org.openide.util
      RequestProcessor$Processor.run
      1. org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
      2. org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
      2 frames
    6. com.hxtt.global
      SQLState.SQLException
      1. com.hxtt.global.SQLState.SQLException(Unknown Source)
      1 frame
    7. com.hxtt.sql
      dn.executeQuery
      1. com.hxtt.sql.br.a(Unknown Source)
      2. com.hxtt.sql.ai.a(Unknown Source)
      3. com.hxtt.sql.dn.executeQuery(Unknown Source)
      3 frames
    8. JasperReports
      JasperFillManager.fillReport
      1. net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239)
      2. net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086)
      3. net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)
      4. net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1253)
      5. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)
      6. net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)
      7. net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
      8. net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
      9. net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)
      10. net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)
      10 frames
    9. com.jaspersoft.ireport
      IReportCompiler.run
      1. com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)
      1 frame
    10. org.openide.util
      RequestProcessor$Processor.run
      1. org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
      2. org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
      2 frames