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

tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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