Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-5379

NodeAvailabilityReport.jrxml doesn't work: PSQLException caused by date string in french locale

    XMLWordPrintable

    Details

      Description

      Database reports don't work anymore.

      When I run one of them, I see the following in report.log:

      2012-05-25 11:16:15,539 ERROR [qtp1911757924-654] JasperReportService: jasper report exception
      net.sf.jasperreports.engine.JRException: Error executing SQL statement for : AvailabilitySummaryReport
      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:143)
      at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684)
      at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
      at org.opennms.reporting.jasperreports.svclayer.JasperReportService.runAndRender(JasperReportService.java:482)
      at org.opennms.reporting.core.svclayer.support.DefaultReportWrapperService.runAndRender(DefaultReportWrapperService.java:288)
      at org.opennms.web.controller.OnlineReportController.onSubmit(OnlineReportController.java:125)
      at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:272)
      at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:268)
      at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
      at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
      at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
      <snip>
      Caused by: org.postgresql.util.PSQLException: ERREUR: syntaxe en entrée invalide pour le type timestamp : « ven. mai 25 00:00:00 +0200 2012 »
      Position : 1777
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137)
      ... 86 more
      2012-05-25 11:16:15,540 ERROR [qtp1911757924-654] DefaultReportWrapperService: failed to run or render report: local_Availability-Summary-Report
      org.opennms.api.reporting.ReportException: unable to run or render jdbc jasperReport
      at org.opennms.reporting.jasperreports.svclayer.JasperReportService.runAndRender(JasperReportService.java:494)
      at org.opennms.reporting.core.svclayer.support.DefaultReportWrapperService.runAndRender(DefaultReportWrapperService.java:288)
      at org.opennms.web.controller.OnlineReportController.onSubmit(OnlineReportController.java:125)
      at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:272)
      at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:268)
      at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
      at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
      at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
      at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
      at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
      at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
      at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1355)
      at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
      <snip>
      Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : AvailabilitySummaryReport
      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:143)
      at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684)
      at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)
      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
      at org.opennms.reporting.jasperreports.svclayer.JasperReportService.runAndRender(JasperReportService.java:482)
      ... 78 more
      Caused by: org.postgresql.util.PSQLException: ERREUR: syntaxe en entrée invalide pour le type timestamp : « ven. mai 25 00:00:00 +0200 2012 »
      Position : 1777
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137)
      ... 86 more

      (The strange thing is that I just started using these reports yesterday, and they were working... Though, I think they make my onnms crash during the night with a java.lang.OutOfMemoryError: PermGen space error)

      Something locale related (org.postgresql.util.PSQLException: ERREUR: syntaxe en entrée invalide pour le type timestamp : « ven. mai 25 00:00:00 +0200 2012 »)?

      Cyrille

        Attachments

          Activity

            People

            • Assignee:
              desloge Donald Desloge
              Reporter:
              stcyr Cyrille Bollu
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: