I am seeing a similar thing. My canned weekly report for keyword Opsview is working flawlessly but the monthly report has no data in it.
Any insight would be appreciated. Thanks, Joe -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, March 29, 2010 2:13 AM To: [email protected] Subject: Re: [opsview-users] issue with scheduled reports Thanks for a fast response to this issue! Now openJDK seems to work! Kind of.... When running monthly report (./run_opsview_report -N 6 -S 2010-02 -f /tmp/miau.pdf -t generic_availability), the script starts looping and never ends... 2441 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2441 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/odw] 2457 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [Mon Feb 01 00:00:00 CET 2010], value class [java.util.Date], SQL type unknown 2497 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 2, parameter value [Sun Feb 28 22:59:59 CET 2010], value class [java.util.Date], SQL type unknown 2497 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 3, parameter value [00:00:00], value class [java.lang.String], SQL type unknown 2497 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 4, parameter value [23:59:59], value class [java.lang.String], SQL type unknown 36610 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource 36612 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL query 36612 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [SELECT hostgroup FROM reports.reports, reports.selectionhostgroups WHERE reports.reports.selection = reports.selectionhostgroups.selection and reports.reports.id = ?] 36612 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 36612 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/reports] 36625 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [6], value class [java.lang.Integer], SQL type unknown 36626 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource 36629 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL query 36629 [main] DEBUG org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [SELECT date(CONVERT_TZ(start_datetime,'+00:00','SYSTEM')) Date, sum(seconds_ok)/sum(seconds_ok+seconds_not_ok)*100 availability FROM service_availability_hourly_summary, servicechecks, hosts WHERE CONVERT_TZ(start_datetime,'+00:00','SYSTEM') BETWEEN ? and ? and service_availability_hourly_summary.servicecheck = servicechecks.id and hosts.id = servicechecks.host and time(CONVERT_TZ(start_datetime,'+00:00','SYSTEM')) BETWEEN ? and ? and hosts.hostgroup IN (' UNIX hosts ')GROUP BY Date ORDER BY Date] 36630 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 36630 [main] DEBUG org.springframework.jdbc.datasource.DriverManagerDataSource - Creating new JDBC Connection to [jdbc:mysql://localhost/odw] 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 1, parameter value [2009-11-01 00:00:00], value class [java.lang.String], SQL type unknown 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 2, parameter value [2010-02-28 23:59:59], value class [java.lang.String], SQL type unknown 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 3, parameter value [00:00:00], value class [java.lang.String], SQL type unknown 36641 [main] DEBUG org.springframework.jdbc.core.StatementCreatorUtils - Setting SQL statement parameter value: column index 4, parameter value [23:59:59], value class [java.lang.String], SQL type unknown However, with weekly reports (./run_opsview_report -N 7 -S 2010-02-01 -f /tmp/miau.pdf -t generic_availability) it succeeds but no data exists in PDF report: No summary data found for report period. No data found for module 'Weekly Availability Summary' No data found for module 'Weekly Availability Summary Table' Etc... This is the same for SUN and openJDK. It was like that even before Opsview-reports upgrade on sunJDK. ODW seems to be fine, data is in there. Please let me know if you have any ideas... Regards, Rimvydas Sneideris -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ton Voon Sent: Thursday, March 25, 2010 6:56 PM To: Opsview Users Subject: Re: [opsview-users] issue with scheduled reports On 24 Mar 2010, at 17:53, Ton Voon wrote: > > On 23 Mar 2010, at 18:52, Ton Voon wrote: > >> We'll look into why openjdk doesn't work. > > After a lot of debugging, we've found the root cause of the problem > for openjdk. One of the dependency libraries, FOP, raises an error > because the colour profile was called "sRGB" but in openjdk it is > called "sRGB built-in" and the code does not handle this difference. > > We've made a patch to this library and we're currently testing it. > We expect to release a newer version of opsview-reports tomorrow > morning (UK time) and will let you know when it is available. We've published a new version of opsview-reports now (2.2.3.255) for centos, rhel5, etch, lenny and hardy. This will fix the issue when run with openjdk. (Solaris is not updated as that uses sun's jre). Ton _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
