ZuckerReports/Jasper Reports problem

[john.luat]

Hi, im using SugarCRM 5.0.0d and i've installed ZuckerReports CE version 1.9 successfully, but when i tried generating jasper reports, it generates an error, i think its the java configuration but i'am not sure what to replace in the config.php...

here is the error...

cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/_files/;modules/ZuckerReports/jasper/ant-1.5.1.jar;modules/ZuckerReports/jasper/antlr-2.7.5.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/bsh-2.0b4.jar;modules/ZuckerReports/jasper/commons-beanutils-1.7.jar;modules/ZuckerReports/jasper/commons-collections-2.1.jar;modules/ZuckerReports/jasper/commons-digester-1.7.jar;modules/ZuckerReports/jasper/commons-javaflow-20060411.jar;modules/ZuckerReports/jasper/commons-logging-1.0.2.jar;modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar;modules/ZuckerReports/jasper/groovy-all-1.5.5.jar;modules/ZuckerReports/jasper/hibernate3.jar;modules/ZuckerReports/jasper/hsqldb-1.7.1.jar;modules/ZuckerReports/jasper/itext-1.3.1.jar;modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar;modules/ZuckerReports/jasper/jasperreports-3.0.0.jar;modules/ZuckerReports/jasper/jaxen-1.1.1.jar;modules/ZuckerReports/jasper/jcommon-1.0.0.jar;modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar;modules/ZuckerReports/jasper/jfreechart-1.0.0.jar;modules/ZuckerReports/jasper/jpa.jar;modules/ZuckerReports/jasper/jxl-2.6.jar;modules/ZuckerReports/jasper/mondrian-2.3.2.8944.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar;modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar;modules/ZuckerReports/jasper/saaj-api-1.3.jar;modules/ZuckerReports/jasper/servlet.jar;modules/ZuckerReports/jasper/xalan.jar;modules/ZuckerReports/jasper/xercesImpl.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.JasperBatchMain modules/ZuckerReports/temp/bf16ebba-2be6-a215-2873-48c17f1a360a/cmd.properties 2>&1
JasperBatchMain :: compiling jasper design modules/ZuckerReports/resources/
JasperBatchMain :: java.io.FileNotFoundException: modules\ZuckerReports\resources (Access is denied)
net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: modules\ZuckerReports\resources (Access is denied)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:172)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:152)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:150)
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:111)
Caused by: java.io.FileNotFoundException: modules\ZuckerReports\resources (Access is denied)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:167)
... 3 more

Please guys help me... Thanks in advance...

[alearr]

Unistall 1.9 and try with the 1.8 version, is designed for Sugar 5.0

[thelma]

Hey you have to do is change the config.php file (modules / ZuckerReports / config.php) in this part:

// Enter the path to your java executable here, if autodetection doesn't work
//Windows Environment Default
"java_cmdline" => "C:\java.exe",

verifies that the path does not contain special characters like this ("C:/Program File/Java/jdk1.6.0_07/bin/java.exe")

[waz664]

In case anyone else runs across the same issue. I found it was actaully a directory permission issue. I added "everyone" with Full Permission to "modules\ZuckerReports\resources" and it works great. Of course adding "everyone" is very bad practice so the next step is to assign specific rights to the IUSR account, but this does identify the exact problem and a path to the solution.

[luis@acm.org]

In case it helps someone else; I came into a situation in which reports wouldn't run even after compiling properly when loading them. This was due to blank spaces in the .jrmxl file:

My report.jrxml would compile and not execute, while
My_report.jrxml executes fine

This under Windows, error report states the .jasper file is not found.