Solved - at least for me: to have a scheduled report, you must define a selection. When you select a group, typing on the right side of the template, the application displays the possibilities: choose one of them instead of writing the whole group by hand. Raffaello
Il 29/03/2010 17.34, Raffaello Poltronieri - Eutelia SpA ha scritto: > 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 >
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
