[prev in list] [next in list] [prev in thread] [next in thread]
List: opennms-discuss
Subject: Re: [opennms-discuss] Jasper Reports - how to create
From: avb <achuta.bodepu () relianceada ! com>
Date: 2010-11-30 9:15:29
Message-ID: 1291108529811-5787471.post () n2 ! nabble ! com
[Download RAW message or body]
Hi,
I feel there should be proper reporting utility. This is excerpt from the
link http://www.opennms.org/wiki/Jasper_Report_RRD_Datasource_Specification
which is as
Jasper reports can now be created from JRobin files. In this specification
we'll cover how to create and run a jasper report using jrb files as the
source for our dataset..
Instead of graphs I just want numeric values to displayed for a day.
I have written jrobin query for the In/Out bandwidth utilization . Please
find attached Jrobin query XML file. Please let me know for errors in the
.jrxml file. Error in reportd.log file as follows:-
2010-11-30 12:20:00,265 ERROR [reportd_Worker-2] DefaultReportService: Error
running report: net.sf.jasperreports.engine.JRRuntimeException:
net.sf.jasperreports.engine.JRException: No query executer factory class
registered for jrobin queries.
net.sf.jasperreports.engine.JRException:
net.sf.jasperreports.engine.JRRuntimeException:
net.sf.jasperreports.engine.JRException: No query executer factory class
registered for jrobin queries.
at
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239)
at
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:222)
at
net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:210)
at
net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:164)
at
net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:148)
at
net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:146) \
at
org.opennms.netmgt.reporting.service.DefaultReportService.runAndRender(DefaultReportService.java:94) \
at
org.opennms.netmgt.reporting.service.DefaultReportService.runReport(DefaultReportService.java:46) \
at
org.opennms.netmgt.reporting.service.Reportd.runReport(Reportd.java:85)
at
org.opennms.netmgt.reporting.service.ReportJob.execute(ReportJob.java:26)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: net.sf.jasperreports.engine.JRRuntimeException:
net.sf.jasperreports.engine.JRException: No query executer factory class
registered for jrobin queries.
at
org.apache.commons.digester.Digester.createSAXException(Digester.java:3181)
at
org.apache.commons.digester.Digester.createSAXException(Digester.java:3207)
at
org.apache.commons.digester.Digester.endElement(Digester.java:1225)
at
net.sf.jasperreports.engine.xml.JRXmlDigester.endElement(JRXmlDigester.java:183)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)
at org.apache.xerces.impl.xs.XMLSchemaValidator.endElement(Unknown
Source)
at
org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1745)
at
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:235)
... 11 more
Caused by: net.sf.jasperreports.engine.JRRuntimeException:
net.sf.jasperreports.engine.JRException: No query executer factory class
registered for jrobin queries.
at
net.sf.jasperreports.engine.design.JRDesignDataset.queryLanguageChanged(JRDesignDataset.java:1017) \
at
net.sf.jasperreports.engine.design.JRDesignDataset.setQuery(JRDesignDataset.java:551) \
at
net.sf.jasperreports.engine.design.JasperDesign.setQuery(JasperDesign.java:880)
at sun.reflect.GeneratedMethodAccessor501.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) \
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:217)
at org.apache.commons.digester.Rule.end(Rule.java:253)
at
org.apache.commons.digester.Digester.endElement(Digester.java:1222)
... 23 more
Caused by: net.sf.jasperreports.engine.JRException: No query executer
factory class registered for jrobin queries.
at
net.sf.jasperreports.engine.query.DefaultQueryExecuterFactoryBundle.getQueryExecuterFactory(DefaultQueryExecuterFactoryBundle.java:80) \
at
net.sf.jasperreports.engine.util.JRQueryExecuterUtils.getQueryExecuterFactory(JRQueryExecuterUtils.java:57) \
at
net.sf.jasperreports.engine.design.JRDesignDataset.queryLanguageChanged(JRDesignDataset.java:1006) \
... 32 more
2010-11-30 12:20:00,625 ERROR [reportd_Worker-2] Reportd: Java Mailer
messaging exception: javax.mail.MessagingException: IOException while
sending message;
nested exception is:
java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
javax.mail.MessagingException: IOException while sending message;
nested exception is:
java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
at
com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:676)
at org.opennms.javamail.JavaSendMailer.send(JavaSendMailer.java:278)
at org.opennms.javamail.JavaSendMailer.send(JavaSendMailer.java:254)
at
org.opennms.netmgt.reporting.service.JavaMailDeliveryService.deliverReport(JavaMailDeliveryService.java:42) \
at
org.opennms.netmgt.reporting.service.Reportd.runReport(Reportd.java:87)
at
org.opennms.netmgt.reporting.service.ReportJob.execute(ReportJob.java:26)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at
javax.activation.FileDataSource.getInputStream(FileDataSource.java:82)
at javax.activation.DataHandler.writeTo(DataHandler.java:290)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1403)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:874)
at javax.mail.internet.MimeMultipart.writeTo(MimeMultipart.java:444)
at
com.sun.mail.handlers.multipart_mixed.writeTo(multipart_mixed.java:102)
at
javax.activation.ObjectDataContentHandler.writeTo(DataHandler.java:869)
at javax.activation.DataHandler.writeTo(DataHandler.java:302)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1403)
at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1745)
at
com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:636)
... 7 more
2010-11-30 12:20:00,625 ERROR [reportd_Worker-2] JavaMailDeliveryService:
Problem with JavaMailer Java Mailer messaging exception:
javax.mail.MessagingException: IOException while sending message;
nested exception is:
java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
org.opennms.javamail.JavaMailerException: Java Mailer messaging exception:
javax.mail.MessagingException: IOException while sending message;
nested exception is:
java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
at org.opennms.javamail.JavaSendMailer.send(JavaSendMailer.java:285)
at org.opennms.javamail.JavaSendMailer.send(JavaSendMailer.java:254)
at
org.opennms.netmgt.reporting.service.JavaMailDeliveryService.deliverReport(JavaMailDeliveryService.java:42) \
at
org.opennms.netmgt.reporting.service.Reportd.runReport(Reportd.java:87)
at
org.opennms.netmgt.reporting.service.ReportJob.execute(ReportJob.java:26)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: javax.mail.MessagingException: IOException while sending message;
nested exception is:
java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
at
com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:676)
at org.opennms.javamail.JavaSendMailer.send(JavaSendMailer.java:278)
... 6 more
Caused by: java.io.FileNotFoundException: C:\Program
Files\OpenNMS\share\reports\report720101130122000.pdf (The system cannot
find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at
javax.activation.FileDataSource.getInputStream(FileDataSource.java:82)
at javax.activation.DataHandler.writeTo(DataHandler.java:290)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1403)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:874)
at javax.mail.internet.MimeMultipart.writeTo(MimeMultipart.java:444)
at
com.sun.mail.handlers.multipart_mixed.writeTo(multipart_mixed.java:102)
at
javax.activation.ObjectDataContentHandler.writeTo(DataHandler.java:869)
at javax.activation.DataHandler.writeTo(DataHandler.java:302)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1403)
at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1745)
at
com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:636)
... 7 more
Please help me to understand as i having difficulty in understanding this
reporting functionality.
http://opennms.530661.n2.nabble.com/file/n5787471/report7.jrxml
report7.jrxml
--
View this message in context: \
http://opennms.530661.n2.nabble.com/Jasper-Reports-how-to-create-customized-Jasper-reports-tp5587035p5787471.html
Sent from the OpenNMS - discuss mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic