Re: [Ground-user] Error generating PDF reports using GR 1.5

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Ouray,

The generateReport.bat file that I have (from the git repository) does
not have the hash character in it. I will need to check the
distribution packaged files, thats for the heads up.

The line that you are talking about (containing saxon9.jar) should not
be commented out.

here is the content of my generateReport.bat file which is from version 1.5

'''
@echo OFF

SETLOCAL

FOR /F "tokens=* skip=15" %%i IN (../etc/environment.properties) DO set %%i

set GROUNDREPORT_BIN_DIR=%GROUNDREPORT_HOME%/bin
set GROUNDREPORT_CONFIG_DIR=%GROUNDREPORT_HOME%/etc
set GROUNDREPORT_LIB_DIR=%GROUNDREPORT_HOME%/lib
set GROUNDREPORT_MAIN_BIN=groundReport.py
set GROUNDREPORT_DB_BIN=databaseInterface.py
set GROUNDREPORT_MAIN_PROPERTIES=groundReport.properties
set GROUNDREPORT_DATA_PROPERTIES=data.properties
set GROUNDREPORT_DATABASE_PROPERTIES=database.properties
set GROUNDREPORT_ENV_PROPERTIES=environment.properties
set GROUNDREPORT_RESOURCE_PROPERTIES=resource.properties

set CLASSPATH=%JYTHON_HOME%/jython.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/jfreechart-1.0.13.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/jcommon-1.0.16.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/postgresql-8.2-508.jdbc3.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/saxon9.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/fop.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/fop-hyph.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/avalon-framework-4.2.0.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/batik-all-1.6.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/commons-io-1.3.1.jar
set CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/commons-logging-1.0.4.jar

set JYTHON_CLASS=org.python.util.jython
set JYTHON_JAVA_ARGS=-Dpython.home=%JYTHON_HOME%
-Dpython.cachedir=%GROUNDREPORT_HOME%/var/cache
set JYTHON_CMD=%JYTHON_JAVA_ARGS% %JYTHON_CLASS%

set JAVA_BIN_DIR=%JAVA_HOME%/bin
set JAVA_BIN=java.exe
set JAVA_ARGS=-cp
set JAVA_CMD="%JAVA_BIN_DIR%/%JAVA_BIN%" %JAVA_ARGS% %CLASSPATH% %JAVA_MEM_ARGS%

set GROUNDREPORT_CMD=%GROUNDREPORT_LIB_DIR%/%GROUNDREPORT_MAIN_BIN%
%GROUNDREPORT_CONFIG_DIR%/%GROUNDREPORT_ENV_PROPERTIES%
%GROUNDREPORT_CONFIG_DIR%/%GROUNDREPORT_DATABASE_PROPERTIES%
%GROUNDREPORT_CONFIG_DIR%/%GROUNDREPORT_DATA_PROPERTIES%
%GROUNDREPORT_CONFIG_DIR%/%GROUNDREPORT_RESOURCE_PROPERTIES%
%GROUNDREPORT_CONFIG_DIR%/%GROUNDREPORT_MAIN_PROPERTIES%

call %JAVA_CMD% %JYTHON_CMD% %GROUNDREPORT_CMD%

ENDLOCAL
''''

The main output type of the ground report is pdf so it should be
working. Please can you set the output type to 'xml' and send me a
copy (you may need to compress it). Also please can you send me a copy
of your current groundReport.properties file.

The error is occurring at the point where it is transforming the xml
produced into fop to produce the pdf file. Having a look at the xml
will show us it it is producing correctly formed xml.

Cheers
Cal

On 12 April 2011 15:47, Ouray Viney <ou...@vi...> wrote:
> Steps:
> 1) load data into db
> 2) generate pdf report -> exception generated report generation failed
>  GRAPH CREATION
> ________________
>
>  Generating Graphs
>  Time Taken = 00 Hours 00 Minutes 02 Seconds
>
>  REPORT CREATION
> _________________
>
>  Summary Article Information:
>
>   Generating Graphs
>    Time Taken = 00 Hours 00 Minutes 04 Seconds
>   Generating Article
>    Time Taken = 00 Hours 00 Minutes 00 Seconds
>   Post-Processing Article
> Error on line 1856 of pagesetup.xsl:
>   SXCH0003: java.lang.NumberFormatException: For input string: "4:"
>   at xsl:apply-templates
> (file:/E:/Headwall_Software/Projects/Innovapost/development/ground_report-1.5/style/xsl/docbook
> -xsl-ns-1.75.0/fo/component.xsl#688)
>      processing /article
>   at xsl:apply-templates
> (file:///E:/Headwall_Software/Projects/Innovapost/development/ground_report-1.5/style/xsl/docbo
> ok-xsl-ns-1.75.0/fo/docbook.xsl#310)
>      processing /article
>   in built-in template rule
>   at xsl:apply-templates
> (file:///E:/Headwall_Software/Projects/Innovapost/development/ground_report-1.5/style/xsl/docbo
> ok-xsl-ns-1.75.0/fo/docbook.xsl#222)
>      processing /
> Traceback (most recent call last):
>   File
> "E:/Headwall_Software/Projects/Innovapost/development/ground_report-1.5/lib/groundReport.py",
> line 351, in <modul
> e>
>     eval(articleType)()
>   File
> "E:/Headwall_Software/Projects/Innovapost/development/ground_report-1.5/lib/groundReport.py",
> line 351, in <modul
> e>
>     eval(articleType)()
>   File
> "E:\Headwall_Software\Projects\Innovapost\development\ground_report-1.5\lib\articleFactory.py",
> line 462, in crea
> teSummaryArticle
>     self.postProcessArticle(output, fullChartList, filename)
>   File
> "E:\Headwall_Software\Projects\Innovapost\development\ground_report-1.5\lib\articleFactory.py",
> line 76, in postP
> rocessArticle
>     xt.articleFOPTransform()
>   File
> "E:\Headwall_Software\Projects\Innovapost\development\ground_report-1.5\lib\xmlUtilities.py",
> line 94, in article
> FOPTransform
>     transformer.transform(source, result)
> net.sf.saxon.trans.XPathException: java.lang.NumberFormatException: For
> input string: "4:"
>         at
> net.sf.saxon.event.ContentHandlerProxy.handleSAXException(ContentHandlerProxy.java:521)
>         at
> net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:375)
>         at
> net.sf.saxon.event.NamespaceReducer.startContent(NamespaceReducer.java:197)
>         at
> net.sf.saxon.event.ComplexContentOutputter.startContent(ComplexContentOutputter.java:550)
>         at
> net.sf.saxon.event.ComplexContentOutputter.startElement(ComplexContentOutputter.java:174)
>         at
> net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:289)
>         at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:556)
>         at
> net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:549)
>         at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:556)
>         at
> net.sf.saxon.instruct.Template.applyLeavingTail(Template.java:203)
>         at
> net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:345)
>         at
> net.sf.saxon.instruct.ApplyTemplates.apply(ApplyTemplates.java:210)
>         at
> net.sf.saxon.instruct.ApplyTemplates.processLeavingTail(ApplyTemplates.java:174)
>         at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:556)
>         at net.sf.saxon.instruct.Instruction.process(Instruction.java:93)
>         at
> net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:296)
>         at
> net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:549)
>         at
> net.sf.saxon.instruct.Template.applyLeavingTail(Template.java:203)
>         at
> net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:345)
>         at
> net.sf.saxon.instruct.ApplyTemplates.apply(ApplyTemplates.java:210)
>         at
> net.sf.saxon.instruct.ApplyTemplates.processLeavingTail(ApplyTemplates.java:174)
>         at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:556)
>         at net.sf.saxon.instruct.Instruction.process(Instruction.java:93)
>         at
> net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:296)
>         at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:556)
>         at
> net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:549)
>         at
> net.sf.saxon.instruct.Template.applyLeavingTail(Template.java:203)
>         at
> net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:345)
>         at
> net.sf.saxon.instruct.ApplyTemplates.defaultAction(ApplyTemplates.java:378)
>         at
> net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:333)
>         at
> net.sf.saxon.instruct.ApplyTemplates$ApplyTemplatesPackage.processLeavingTail(ApplyTemplates.java:527)
>         at net.sf.saxon.Controller.transformDocument(Controller.java:1812)
>         at net.sf.saxon.Controller.transform(Controller.java:1621)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
> net.sf.saxon.trans.XPathException: net.sf.saxon.trans.XPathException:
> java.lang.NumberFormatException: For input string:
>  "4:"
> Has anyone been able to successfully generate PDFs?
> With the same settings, I change the output format to 'rff' and things work
> fine.
> Note:
> - there is a typo in the generateReport.bat file (#set
> CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/saxon9.jar), should not use '#'
> in a bat file.
> - uncomment that line and the error above is seen.
> - comment out the line above and the error below is seen (REM set
> CLASSPATH=%CLASSPATH%;%GROUNDREPORT_LIB_DIR%/saxon9.jar):
>  GRAPH CREATION
> ________________
>
>  Generating Graphs
>  Time Taken = 00 Hours 00 Minutes 02 Seconds
>
>  REPORT CREATION
> _________________
>
>  Summary Article Information:
>
>   Generating Graphs
>    Time Taken = 00 Hours 00 Minutes 05 Seconds
>   Generating Article
>    Time Taken = 00 Hours 00 Minutes 00 Seconds
>   Post-Processing Article
> Apr 12, 2011 10:47:13 AM org.apache.fop.fo.FOTreeBuilder$MainFOHandler
> endElement
> WARNING: Mismatch: root (http://www.w3.org/1999/XSL/Format) vs.
> page-sequence (http://www.w3.org/1999/XSL/Format)
> Apr 12, 2011 10:47:13 AM org.apache.fop.fo.FOTreeBuilder fatalError
> SEVERE: javax.xml.transform.TransformerException:
> java.lang.IllegalStateException: endElement() called for fo:root where
>  there is no current element.
> file:///E:/Headwall_Software/Projects/Innovapost/development/ground_report-1.5/style/xsl/docbook-xsl-ns-1.75.0/fo/docboo
> k.xsl; Line #222; Column #59; java.lang.IllegalStateException: endElement()
> called for fo:root where there is no current
>  element.
>    Time Taken = 00 Hours 00 Minutes 05 Seconds
>
> Thanks,
> Ouray
> ------------------------------------------------------------------------------
> Forrester Wave Report - Recovery time is now measured in hours and minutes
> not days. Key insights are discussed in the 2010 Forrester Wave Report as
> part of an in-depth evaluation of disaster recovery service providers.
> Forrester found the best-in-class provider in terms of services and vision.
> Read this report now!  http://p.sf.net/sfu/ibm-webcastpromo
> _______________________________________________
> Ground-user mailing list
> Gro...@li...
> https://lists.sourceforge.net/lists/listinfo/ground-user
>
>