I have finally managed to get iReport to compile a sample report and
have followed all the step to configure iReport to work with Sentinel
Log Manager. When I try to preview the report I get a
QueryParseException error. Below is the output from iReport.


Setting*com.novell.reports.jasper.data.event.Lucen eEventQueryExecutorFactory*as*Query*Executer*Facto ry*for*language:*LUCENE_EVENT

Compiling scriptlet source file...
/home/jkotze/content/dev/reports/Testing/Test
Report/6.1/TemplateReportScriptlet.java
Compilation running time: 257.
*Compiling to file... /home/jkotze/content/dev/reports/Testing/Test
Report/6.1/TemplateReport.jasper ->
/home/jkotze/content/dev/reports/Testing/Test
Report/6.1/TemplateReport.java
Compilation running time: 9,831.
*Filling report...
*Locale: English (United States)
*Time zone: Default
Error*filling*print...*Error*parsing*OVER*clause:* SELECT*******dt*AS*event_parse_time,*****evt*AS*ev ent_name,*****dun*AS*targetusername,*****sun*AS*in itusername,*****rv45*AS*target_user_domain,*****dh n*AS*target_host_name,*****dip*AS*target_ip,*****e i*AS*extended_info,*****xdasoutcome*AS*xdasoutcome ******WHERE******xdasoutcome:[0*TO*2]*AND*xdasclass:2*AND*xdasreg:0*AND*xdasprov:0*AND* (xdasid:0*OR*xdasid:4)**********OVER*,

Loading*Sentinel*Report*properties*from:*/home/jkotze/content/dev/sdk/build/config/sentinelreport.properties
Loaded*the*following*Sentinel*Report*properties:
--*listing*properties*--
java.runtime.name=Java(TM)*SE*Runtime*Environment
sun.boot.library.path=/usr/java/jdk1.6.0_21/jre/lib/i386
java.vm.version=17.0-b16 java.vm.vendor=Sun*Microsystems*Inc.
java.vendor.url=http://java.sun.com/ path.separator=:
java.vm.name=Java*HotSpot(TM)*Client*VM file.encoding.pkg=sun.io
user.country=US sun.java.launcher=SUN_STANDARD
sun.os.patch.level=unknown sun.swing.enableImprovedDragGesture=
java.vm.specification.name=Java*Virtual*Machine*Sp ecification
user.dir=/home/jkotze/iReport-3.0.0/bin
org.xml.sax.driver=org.apache.xerces.parsers.SAXPa rser
java.runtime.version=1.6.0_21-b06
java.awt.graphicsenv=sun.awt.X11GraphicsEnvironmen t
java.endorsed.dirs=/usr/java/jdk1.6.0_21/jre/lib/endorsed os.arch=i386
jasper.reports.compile.temp=/home/jkotze/iReport-3.0.0/bin
java.io.tmpdir=/tmp line.separator=
java.vm.specification.vendor=Sun*Microsystems*Inc.
novell.sentinel.reports.initiatinguser=admin os.name=Linux
esecurity.dataobjects.config.file=/xml/iReportMetaData.xml
sun.jnu.encoding=UTF-8
java.library.path=/usr/java/jdk1.6.0_21/jre/lib/i386/cl...
java.specification.name=Java*Platform*API*Specific ation
java.class.version=50.0 sun.management.compiler=HotSpot*Client*Compiler
ireport.home=/home/jkotze/iReport-3.0.0 os.version=2.6.32.23-0.3-pae
user.home=/home/jkotze user.timezone=Africa/Johannesburg
java.security.policy=/home/jkotze/iReport-3.0.0/policy.all
java.awt.printerjob=sun.print.PSPrinterJob
java.specification.version=1.6 file.encoding=UTF-8
esecurity.remote.timeout=180 user.name=jkotze
java.class.path=./../classes:./../fonts:./../lib/*.zi...
java.vm.specification.version=1.0 sun.arch.data.model=32
java.home=/usr/java/jdk1.6.0_21/jre
java.specification.vendor=Sun*Microsystems*Inc. user.language=en
esecurity.communication.service=WebUI java.vm.info=mixed*mode,*sharing
java.version=1.6.0_21
java.ext.dirs=/usr/java/jdk1.6.0_21/jre/lib/ext:/us...
sun.boot.class.path=/usr/java/jdk1.6.0_21/jre/lib/resourc...
java.vendor=Sun*Microsystems*Inc. file.separator=/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport...
sun.cpu.endian=little sun.io.unicode.encoding=UnicodeLittle
sun.desktop=gnome
com.esecurity.configurationfile=/home/jkotze/content/dev/sdk/build/co...
sun.cpu.isalist= Using*the*following*user*to*execute*the*search:*ad min
com.novell.reports.jasper.data.event.QueryParseExc eption:*Error*parsing*OVER*clause:*SELECT*******dt *AS*event_parse_time,*****evt*AS*event_name,*****d un*AS*targetusername,*****sun*AS*initusername,**** *rv45*AS*target_user_domain,*****dhn*AS*target_hos t_name,*****dip*AS*target_ip,*****ei*AS*extended_i nfo,*****xdasoutcome*AS*xdasoutcome******WHERE**** **xdasoutcome:[0*TO*2]*AND*xdasclass:2*AND*xdasreg:0*AND*xdasprov:0*AND* (xdasid:0*OR*xdasid:4)**********OVER*,
****at*com.novell.reports.jasper.data.event.QueryP arser.parse(QueryParser.java:210)
****at*com.novell.reports.jasper.data.event.Lucene EventQueryExecutor.createDatasource(LuceneEventQue ryExecutor.java:74)
****at*net.sf.jasperreports.engine.fill.JRFillData set.createQueryDatasource(JRFillDataset.java:656)
****at*net.sf.jasperreports.engine.fill.JRFillData set.initDatasource(JRFillDataset.java:588)
****at*net.sf.jasperreports.engine.fill.JRBaseFill er.setParameters(JRBaseFiller.java:1196)
****at*net.sf.jasperreports.engine.fill.JRBaseFill er.fill(JRBaseFiller.java:833)
****at*net.sf.jasperreports.engine.fill.JRFiller.f illReport(JRFiller.java:123)
****at*net.sf.jasperreports.engine.JasperFillManag er.fillReport(JasperFillManager.java:420)
****at*net.sf.jasperreports.engine.JasperFillManag er.fillReport(JasperFillManager.java:256)
****at*it.businesslogic.ireport.IReportCompiler.ru n(IReportCompiler.java:1053)
****at*java.lang.Thread.run(Thread.java:619)
Caused*by:*java.text.ParseException:*Unparseable*d ate:*""
****at*java.text.DateFormat.parse(DateFormat.java: 337)
****at*com.novell.reports.jasper.data.event.QueryP arser.parse(QueryParser.java:207)
****...*10*more
Print was not filled. Try using an EmptyDataSource...


Any help will be appreciated as my java skills are limited.


--
gogga
------------------------------------------------------------------------
gogga's Profile: http://forums.novell.com/member.php?userid=20446
View this thread: http://forums.novell.com/showthread.php?t=424567