Hi Michael, You can try changing this property (and restarting tomcat) to get the query: log4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug
But if you say they run properly on JasperReports Server then the culprit seems more of the interface. I'm wondering a couple of things too. Since JasperReports Server 4.2.1 there's a new XHTML exporter (instead of HTML). The win here is that you can overlap elements. I need to double check to see if the way you guys call the server with this code would use XHTML https://git.icinga.org/?p=icinga-web.git;a=blob;f=app/modules/Reporting/lib/jasper/JasperI.interface.php The way to check is to try a PDF export, if there are overlapping elements in the report then HTML will ignore, XHTML and PDF will show properly. I'll check with developers here and post back tomorrow. Also, you said not all reports are listed in the web interface, strange, the API should return them all. Is there anything funny in the name of the reports, special characters and whatnot? Ernesto Ongaro Jaspersoft Corporation ► Email: [email protected] ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org ______________________________________________________________ ----- Original Message ----- From: "Michael Lübben" <[email protected]> To: [email protected] Sent: Tuesday, December 20, 2011 3:57:08 AM Subject: Re: [icinga-users] JasperReports still empty Hi Ernesto, thanks for this information. I have enable debugging, but i don't see any sql queries in the logs. Musst i enable another parameters in the properties? Bye Michael On 12/19/2011 11:55 PM, Ernesto Ongaro wrote: > Hi Tamme! > > Probably the best thing you can do is turn on DEBUG to JasperReports Server, > find webapps/jasperserver-pro/WEB-INF/log4j.properties and change > log4j.rootLogger=WARN, stdout, fileout to log4j.rootLogger=DEBUG, stdout, > fileout > > Once you've changed that file, restart Tomcat and then re-run the reports in > question. In ../WEB-INF/logs/jasperserver.log will get the parameters that > are passed to the report, any stack traces (errors) and the SQL query that is > generated. From this you should be able to gather what is wrong. Feel free to > send me the logs if you can't find it > > Best of luck! > > Ernesto Ongaro > Jaspersoft Corporation > > ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org > ______________________________________________________________ > > ----- Original Message ----- > From: "tamme lennon"<[email protected]> > To: [email protected] > Sent: Friday, December 16, 2011 8:33:53 AM > Subject: [icinga-users] JasperReports still empty > > > Hello, I've been having the same issues with JasperReports since 1.5.0. The > only reports that seem to work out of the box are Host and Service > Notification Reports about a given time and the top 10 in a given time. > > Some of the host reports display graphs, but they are always 100% and don't > seem to line up with known outages reported correctly in the Host > Notifications Reports over a given time. > > > Is there some setting in icinga.cfg, ido2db.cfg, idomod.cfg that aren't > mentioned in the JasperReport Install doc? > > I've tried the WAR install and the straight JasperReportBinary install. I've > also tried the git and regular install of icinga-reports. > > I noticed there is now a mentioned of setting the timestamps in the icinga > database to UTC. Could this all be related? > > I'm running Ubuntu 10.04 with icinga 1.6.1, and the lastest icinga-web and > icinga-reports. > > My timezone on the system is set to CDT. > > Any input is greatly appreciated. I'm at wits end on this. I've been > searching through the lists and docs for quite a while, and I've seen people > reporting similar errors, but I haven't found a solution that works. > > Thanks! > > Tamme > > ------------------------------------------------------------------------------ > Learn Windows Azure Live! Tuesday, Dec 13, 2011 > Microsoft is holding a special Learn Windows Azure training event for > developers. It will provide a great way to learn Windows Azure and what it > provides. You can attend the event by watching it streamed LIVE online. > Learn more at http://p.sf.net/sfu/ms-windowsazure > _______________________________________________ > icinga-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/icinga-users > > ------------------------------------------------------------------------------ > Write once. Port to many. > Get the SDK and tools to simplify cross-platform app development. Create > new or port existing apps to sell to consumers worldwide. Explore the > Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join > http://p.sf.net/sfu/intel-appdev > _______________________________________________ > icinga-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/icinga-users ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ icinga-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/icinga-users ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ icinga-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/icinga-users
