Highlighted
Absent Member.
Absent Member.
475 views

QueryParseException when previewing report


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.LuceneEventQueryExecutorFactory*as*Query*Executer*Factory*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*event_name,*****dun*AS*targetusername,*****sun*AS*initusername,*****rv45*AS*target_user_domain,*****dhn*AS*target_host_name,*****dip*AS*target_ip,*****ei*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*Specification
user.dir=/home/jkotze/iReport-3.0.0/bin
org.xml.sax.driver=org.apache.xerces.parsers.SAXParser
java.runtime.version=1.6.0_21-b06
java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
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*Specification
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:*admin
com.novell.reports.jasper.data.event.QueryParseException:*Error*parsing*OVER*clause:*SELECT*******dt*AS*event_parse_time,*****evt*AS*event_name,*****dun*AS*targetusername,*****sun*AS*initusername,*****rv45*AS*target_user_domain,*****dhn*AS*target_host_name,*****dip*AS*target_ip,*****ei*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*,
****at*com.novell.reports.jasper.data.event.QueryParser.parse(QueryParser.java:210)
****at*com.novell.reports.jasper.data.event.LuceneEventQueryExecutor.createDatasource(LuceneEventQueryExecutor.java:74)
****at*net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:656)
****at*net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588)
****at*net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1196)
****at*net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:833)
****at*net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123)
****at*net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420)
****at*net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256)
****at*it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1053)
****at*java.lang.Thread.run(Thread.java:619)
Caused*by:*java.text.ParseException:*Unparseable*date:*""
****at*java.text.DateFormat.parse(DateFormat.java:337)
****at*com.novell.reports.jasper.data.event.QueryParser.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

0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

Re: QueryParseException when previewing report


Hi there,

Well, this isn't really a Java problem. The error looks pretty clear:
there's a problem with your report query. Can you paste the query here?
You can edit the jrxml directly to extract it, or you can use iReport's
query editor...

Based on the error message, it looks like your query is something like:
SELECT ...WHERE ... OVER, but you haven't actually specified a timerange
over which the report should run. The default template uses the
parameters FromDate and ToDate to provide that info to the report, and
when you preview you should be prompted for values.


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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.