Same for me: weekly - OK, monthly -not. Maybe misunderstanding on hostgroups name? Seems like keywords are working, but not hostgroups name... Thanks Raffaello
Il 29/03/2010 17.29, Joe Goldberg ha scritto: > 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 > >
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
