Closed icinga-migration closed 12 years ago
Updated by mfriedrich on 2012-09-04 13:38:21 +00:00
i do not see any sense in creating just another issue. update your original one, put the notes there, etc. but do not proceed in reopening new issues for the same cause, thanks.
closing for duplicate.
This issue has been migrated from Redmine: https://dev.icinga.com/issues/3059
Created by JohnMassal on 2012-09-04 09:20:21 +00:00
Assignee: (none) Status: Closed (closed on 2012-09-04 13:38:21 +00:00) Target Version: (none) Last Update: 2012-09-04 13:38:21 +00:00 (in Redmine)
Hi...
was able to successfully implement:
CentOS release 6.3 (Final) icinga(IDOUTIL/PostgreSQL-8.4.12) icinga-WEB
wonderful !!!
BUT after having installed(without problems...}:
jasperreports-server-cp-4.7.0{PostgreSQL-9.0.4} icinga-reports-1.7.0
I am not able to produce ANY icinga reports neither with localhost/icinga-web/ nor with localhost:8080/jasperserver/
In both cases I always get the same error report shown below for EVERY possible icinga Report{with varations of the PostgreSQL exception}:
JRException: Error executing SQL statement for org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 186 at\
The Jasper JDBC into PostgreSQL works perfectly....
Apparently it seems that the SQL that is being passed into PostgreSQL is causing this problem...
I have already remitted Bug-#3049...
HOWEVER, with the BUG Report I've added more details and NEED to know UNTIL icinga 1.8 is available is there ANY possibilty of using a version of Jasper with icinga to get reports now ???:
icinga-reports-1.7.0 jasperreports-server-cp
?.?.?{PostgreSQL?.?.?} icinga-1,71/IDOUTILS{PostgreSQL-8.4.12}If PostgreSQL doesn't work is there an alternative DB where these reports can be used now ???
Thank you very much in advance for any support or input here...
all-the-best4now,
John
Ablaufverfolgung für Fehler
com.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1030) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:211) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:733) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:695) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1474) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:874) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:754) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Activity report about a selected Host in a given time at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:246) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:167) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1073) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1253) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) ... 9 more Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 186 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 org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239) ... 15 more
Relations: