ZuckerReports 1.14 SugarCE 5.54 and iReports 4.1.2

[bossmojoman]

Hi all,

I'm having an issue getting a working report from iReport to install on SugarCE 5.54 with ZuckerReports 4.1.2

Things I have tried so far (running on Windows Server and MySql)

I have checked the java path setting in config.php, there are no spaces.

PHP safe mode is off

iReports works (version 4.1.2) and can connect to MySql

Copied jasperreports-4.1.2.jar to modules/zuckerreports/jasper
(while removing jasperreports-4.0.0.jar) same error either way)

Checked to see if each jar file in error list exists (they do)

php1315.tmp does exist in c:/Windows/temp

mysql port is set to default (3036 i think)


Has anyone got the report upload to work with this??? Or can anyone help me? I'm totally stumped.


Error Code
================================================== ===================================

error compiling report report5.jrxml - cmdline: C:\ZuckerReports\javaw -classpath "custom/ZuckerReports/resources/;
custom/ZuckerReports/resources/report5.jasper_files/;
modules/ZuckerReports/jasper/ant-1.7.1.jar;
modules/ZuckerReports/jasper/antlr-2.7.5.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/commons-beanutils-1.8.0.jar;
modules/ZuckerReports/jasper/commons-collections-2.1.1.jar
;modules/ZuckerReports/jasper/commons-digester-1.7.jar;
modules/ZuckerReports/jasper/commons-javaflow-20060411.jar;
modules/ZuckerReports/jasper/commons-logging-1.0.4.jar;
modules/ZuckerReports/jasper/groovy-all-1.7.5.jar;
modules/ZuckerReports/jasper/hibernate3.jar;
modules/ZuckerReports/jasper/hsqldb-1.8.0-10.jar;
modules/ZuckerReports/jasper/iText-2.1.7.jar;
modules/ZuckerReports/jasper/jasperreports-4.1.2.jar;
modules/ZuckerReports/jasper/jasperreports-applet-4.0.0.jar;
modules/ZuckerReports/jasper/jasperreports-fonts-4.0.0.jar;
modules/ZuckerReports/jasper/jasperreports-javaflow-4.0.0.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.0.jar;
modules/ZuckerReports/jasper/jfreechart-1.0.12.jar;
modules/ZuckerReports/jasper/jpa.jar;
modules/ZuckerReports/jasper/jxl-2.6.10.jar;
modules/ZuckerReports/jasper/log4j-1.2.15.jar;
modules/ZuckerReports/jasper/mondrian-3.1.1.12687.jar;
modules/ZuckerReports/jasper/mysql-connector-java-3.1.11-bin.jar;
modules/ZuckerReports/jasper/mysql-connector-java-3.1.14-bin.jar;
modules/ZuckerReports/jasper/png-encoder-1.5.jar;
modules/ZuckerReports/jasper/poi-3.6.jar;
modules/ZuckerReports/jasper/rhino-1.7R1.jar;
modules/ZuckerReports/jasper/saaj-api-1.3.jar;
modules/ZuckerReports/jasper/serializer.jar;
modules/ZuckerReports/jasper/servlet.jar;
modules/ZuckerReports/jasper/spring-beans-2.5.5.jar;
modules/ZuckerReports/jasper/spring-core-2.5.5.jar;
modules/ZuckerReports/jasper/xalan-2.7.1.jar;
modules/ZuckerReports/jasper/xercesImpl-2.7.0.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:\WINDOWS\Temp\php1315.tmp custom/ZuckerReports/resources/report5.jasper 2>&1

[bossmojoman]

bump? Anyone?

[bossmojoman]

So, I figured it out and decided I would post what caused the errors as I've seen the same problem over and over in other threads.

(This is an IIS/PHP intall)

Make sure the IUSR account has read and execute rights to C:\Windows\System32\cmd.exe. If you don't do this Java will throw fits during the report upload. Also set a deny rule to write access on cmd.exe

Next - make sure you have the proper account permissions set up for read/write access to the PBP upload_tmp_dir listed in your PHP.ini file

Finally, there are 2 versions of jfreechart*.jar in the zucker reports install - make sure you only have the newest version installed in \modules\ZuckerReports\jasper\

I hope that helps anyone having the same problem with none of the other solutions found on the forums working for them.

[jlovelace]

What version of Java are you using?

[bossmojoman]

Im using the newest version, 1.7