error compiling report our_jasper_template.jrxml

[a1techno]

hello,
I am new to this forum, actually i have integrated sugar crm module i my web application, I am facing problem in zucker report section that is while uploading jrxml file for report generation i get the following error:

error compiling report our_jasper_template.jrxml - cmdline: java -Djava.awt.headless=true
-classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/our_jasper_template.jasper_files/
:modules/ZuckerReports/jasper/log4j-1.2.8.jar:modules/ZuckerReports/jasper/commons-beanutils-1.5.jar:
modules/ZuckerReports/jasper/commons-digester-1.7.jar:
modules/ZuckerReports/jasper/ehcache-1.1.jar:
modules/ZuckerReports/jasper/bsh-1.3.0.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar:
modules/ZuckerReports/jasper/dom4j-1.6.jar:modules/ZuckerReports/jasper/jxl.jar:
modules/ZuckerReports/jasper/barbecue-1.1.jar:modules/ZuckerReports/jasper/nsisant-1.1.jar:
modules/ZuckerReports/jasper/looks-2.0-rc.jar:modules/ZuckerReports/jasper/poi-2.0-final-20040126.jar:
modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/jta.jar:
modules/ZuckerReports/jasper/toniclf.jar:modules/ZuckerReports/jasper/jcmdline-1.0.2.jar:
modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:
modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/xalan.jar:
modules/ZuckerReports/jasper/jasperreports-1.2.2.jar:modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar:
modules/ZuckerReports/jasper/zuckerreports-1.0.jar:modules/ZuckerReports/jasper/groovy-all-1.0-beta-10.jar:
modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/tinylaf.jar:
modules/ZuckerReports/jasper/jdt-compiler.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:
modules/ZuckerReports/jasper/jr-bsh-compiler.jar:modules/ZuckerReports/jasper/cglib-2.1.jar:
modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/asm.jar:
modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar:
modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/antlr-2.7.5H3.jar:
modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/asm-attrs.jar:
modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/xml-apis.jar:
modules/ZuckerReports/jasper/jfreechart-1.0.0.jar"
at.go_mobile.zuckerreports.JasperCompileMain /tmp/phpQ7YjNQ
modules/ZuckerReports/resources/our_jasper_template.jasper 2>&1
/usr/bin/java: line 67: /tmp/javae12482: Permission denied
/usr/bin/java: line 67: /tmp/javae12482: Success

i am using following tools:
» Operating system type and version (i.e. WindowsXP)
» Sugar Suite version SugarOS-4.5.0f
» Webserver type and version:1.3.37 (Unix)
» PHP version:5.0.5
» MySQL server version : 4.1.21


plz, solve this problem as soon as possible
Regards,
Rakesh Kumar

[tamhd_vn88]

I met the same problem.Please help me.

[agcopley]

hello,
I am new to this forum, actually i have integrated sugar crm module i my web application, I am facing problem in zucker report section that is while uploading jrxml file for report generation i get the following error:

error compiling report our_jasper_template.jrxml - cmdline: java -Djava.awt.headless=true
-classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/our_jasper_template.jasper_files/
:modules/ZuckerReports/jasper/log4j-1.2.8.jar:modules/ZuckerReports/jasper/commons-beanutils-1.5.jar:
modules/ZuckerReports/jasper/commons-digester-1.7.jar:
modules/ZuckerReports/jasper/ehcache-1.1.jar:
modules/ZuckerReports/jasper/bsh-1.3.0.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar:
modules/ZuckerReports/jasper/dom4j-1.6.jar:modules/ZuckerReports/jasper/jxl.jar:
modules/ZuckerReports/jasper/barbecue-1.1.jar:modules/ZuckerReports/jasper/nsisant-1.1.jar:
modules/ZuckerReports/jasper/looks-2.0-rc.jar:modules/ZuckerReports/jasper/poi-2.0-final-20040126.jar:
modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/jta.jar:
modules/ZuckerReports/jasper/toniclf.jar:modules/ZuckerReports/jasper/jcmdline-1.0.2.jar:
modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:
modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/xalan.jar:
modules/ZuckerReports/jasper/jasperreports-1.2.2.jar:modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar:
modules/ZuckerReports/jasper/zuckerreports-1.0.jar:modules/ZuckerReports/jasper/groovy-all-1.0-beta-10.jar:
modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/tinylaf.jar:
modules/ZuckerReports/jasper/jdt-compiler.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:
modules/ZuckerReports/jasper/jr-bsh-compiler.jar:modules/ZuckerReports/jasper/cglib-2.1.jar:
modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/asm.jar:
modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar:
modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/antlr-2.7.5H3.jar:
modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/asm-attrs.jar:
modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/xml-apis.jar:
modules/ZuckerReports/jasper/jfreechart-1.0.0.jar"
at.go_mobile.zuckerreports.JasperCompileMain /tmp/phpQ7YjNQ
modules/ZuckerReports/resources/our_jasper_template.jasper 2>&1
/usr/bin/java: line 67: /tmp/javae12482: Permission denied
/usr/bin/java: line 67: /tmp/javae12482: Success

i am using following tools:
» Operating system type and version (i.e. WindowsXP)
» Sugar Suite version SugarOS-4.5.0f
» Webserver type and version:1.3.37 (Unix)
» PHP version:5.0.5
» MySQL server version : 4.1.21


plz, solve this problem as soon as possible
Regards,
Rakesh Kumar

You need to give your webserver account permissions on cmd.exe in Windows/system32 directory.

[tamhd_vn88]

while uploading jrxml file for report generation i get the following error

error compiling report r2agency.jrxml - cmdline: javaw -classpath "custom/ZuckerReports/resources/;custom/ZuckerReports/resources/r2agency.jasper_files/;modules/ZuckerReports/jasper/ant-1.7.1.jar;modules/ZuckerReports/jasper/antlr-2.7.6.jar;modules/ZuckerReports/jasper/asm-attrs.jar;modules/ZuckerReports/jasper/asm.jar;modules/ZuckerReports/jasper/barbecue-1.5-beta1.jar;modules/ZuckerReports/jasper/barcode4j-2.0.jar;modules/ZuckerReports/jasper/batik-anim.jar;modules/ZuckerReports/jasper/batik-awt-util.jar;modules/ZuckerReports/jasper/batik-bridge.jar;modules/ZuckerReports/jasper/batik-css.jar;modules/ZuckerReports/jasper/batik-dom.jar;modules/ZuckerReports/jasper/batik-ext.jar;modules/ZuckerReports/jasper/batik-gvt.jar;modules/ZuckerReports/jasper/batik-parser.jar;modules/ZuckerReports/jasper/batik-script.jar;modules/ZuckerReports/jasper/batik-svg-dom.jar;modules/ZuckerReports/jasper/batik-svggen.jar;modules/ZuckerReports/jasper/batik-util.jar;modules/ZuckerReports/jasper/batik-xml.jar;modules/ZuckerReports/jasper/bcel-5.2.jar;modules/ZuckerReports/jasper/bsh-2.0b4.jar;modules/ZuckerReports/jasper/castor-1.2.jar;modules/ZuckerReports/jasper/cglib-2.1.jar;modules/ZuckerReports/jasper/cincom-jr-xmla.jar;modules/ZuckerReports/jasper/commons-beanutils-1.8.2.jar;modules/ZuckerReports/jasper/commons-collections-3.2.1.jar;modules/ZuckerReports/jasper/commons-dbcp-1.2.2.jar;modules/ZuckerReports/jasper/commons-digester-1.7.jar;modules/ZuckerReports/jasper/commons-javaflow-20060411.jar;modules/ZuckerReports/jasper/commons-logging-1.1.jar;modules/ZuckerReports/jasper/commons-math-1.0.jar;modules/ZuckerReports/jasper/commons-pool-1.3.jar;modules/ZuckerReports/jasper/commons-vfs-1.0.jar;modules/ZuckerReports/jasper/dom4j-1.6.jar;modules/ZuckerReports/jasper/ehcache-1.1.jar;modules/ZuckerReports/jasper/eigenbase-properties-1.1.0.10924.jar;modules/ZuckerReports/jasper/eigenbase-resgen-1.3.0.11873.jar;modules/ZuckerReports/jasper/eigenbase-xom-1.3.0.11999.jar;modules/ZuckerReports/jasper/ejb3-persistence.jar;modules/ZuckerReports/jasper/groovy-all-1.5.5.jar;modules/ZuckerReports/jasper/hibernate-annotations.jar;modules/ZuckerReports/jasper/hibernate-commons-annotations.jar;modules/ZuckerReports/jasper/hibernate3.jar;modules/ZuckerReports/jasper/hsqldb-1.8.0-10.jar;modules/ZuckerReports/jasper/iText-2.1.0.jar;modules/ZuckerReports/jasper/iTextAsian.jar;modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar;modules/ZuckerReports/jasper/jasperreports-3.7.1.jar;modules/ZuckerReports/jasper/jasperreports-chart-themes-3.6.2.jar;modules/ZuckerReports/jasper/jasperreports-extensions-3.5.3.jar;modules/ZuckerReports/jasper/jasperreports-fonts-3.6.1.jar;modules/ZuckerReports/jasper/javacup.jar;modules/ZuckerReports/jasper/javassist-3.4.GA.jar;modules/ZuckerReports/jasper/jaxen-1.1.1.jar;modules/ZuckerReports/jasper/jcommon-1.0.15.jar;modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar;modules/ZuckerReports/jasper/jfreechart-1.0.12.jar;modules/ZuckerReports/jasper/jpa.jar;modules/ZuckerReports/jasper/js_activation-1.1.jar;modules/ZuckerReports/jasper/js_axis-1.4patched.jar;modules/ZuckerReports/jasper/js_commons-codec-1.3.jar;modules/ZuckerReports/jasper/js_commons-discovery-0.2.jar;modules/ZuckerReports/jasper/js_commons-httpclient-3.1.jar;modules/ZuckerReports/jasper/js_jasperserver-common-ws-3.5.0.jar;modules/ZuckerReports/jasper/js_jaxrpc.jar;modules/ZuckerReports/jasper/js_mail-1.4.jar;modules/ZuckerReports/jasper/js_saaj-api-1.3.jar;modules/ZuckerReports/jasper/js_wsdl4j-1.5.1.jar;modules/ZuckerReports/jasper/jta.jar;modules/ZuckerReports/jasper/jxl-2.6.jar;modules/ZuckerReports/jasper/log4j-1.2.15.jar;modules/ZuckerReports/jasper/mondrian-3.1.1.12687-Jaspersoft.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.11-bin.jar;modules/ZuckerReports/jasper/olap4j-0.9.7.145.jar;modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-3.2-FINAL-20081019.jar;modules/ZuckerReports/jasper/rex-20080421.jar;modules/ZuckerReports/jasper/rhino-1.7R1.jar;modules/ZuckerReports/jasper/saaj-api-1.3.jar;modules/ZuckerReports/jasper/slf4j-api.jar;modules/ZuckerReports/jasper/slf4j-log4j12.jar;modules/ZuckerReports/jasper/spring.jar;modules/ZuckerReports/jasper/sqleonardo-2007.03.jar;modules/ZuckerReports/jasper/swingx-2007_10_07.jar;modules/ZuckerReports/jasper/xml-apis-ext.jar;modules/ZuckerReports/jasper/xml-apis.jar;modules/ZuckerReports/jasper/zuckerreports-1.0.jar" at.go_mobile.zuckerreports.JasperCompileMain C:\Program Files\sugarcrm-5.5.2\php\tmp\php53C.tmp custom/ZuckerReports/resources/r2agency.jasper 2>&1
JasperBatchMain :: compiling jasper design C:\Program to Files\sugarcrm-5.5.2\php\tmp\php53C.tmp
JasperBatchMain :: java.io.FileNotFoundException: C:\Program (The system cannot find the file specified)
net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: C:\Program (The system cannot find the file specified)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:168)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:148)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:146)
at at.go_mobile.zuckerreports.JasperCompileMain.main( JasperCompileMain.java:17)
Caused by: java.io.FileNotFoundException: C:\Program (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:163)
... 3 more

please help me edit this error.
I use :
-ZuckerReports 1.12
-Ireport 3.7.3
-SugarCRM CE Version 5.5.2

[blitz2190]

tamhd_vn88 I think this is the same problem i had a while ago, if you are using a newer version of ireports than that of the ones used by zucker reports you will need to copy the files from your ireports program folder to the ones in the zucker folder on the server, although i cannot seen to remember which ones, if you do this make sure to test on copy of install and never test on live server

[tamhd_vn88]

tamhd_vn88 I think this is the same problem i had a while ago, if you are using a newer version of ireports than that of the ones used by zucker reports you will need to copy the files from your ireports program folder to the ones in the zucker folder on the server, although i cannot seen to remember which ones, if you do this make sure to test on copy of install and never test on live server

thank blitz!
But i dont know what file i have to copy and location
have any diffrent way to solve this problem ??

[ivit]

In this case (tamhd_vn88) problem is not in version incompatibility, but in "Program files" path:

JasperBatchMain :: java.io.FileNotFoundException: C:\Program (The system cannot find the file specified)
net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: C:\Program (The system cannot find the file specified)

You will need to install sugarcrm in the path which does not include space e.g. C:\sugarcrm