Error while using .jrxml file from iReport

**jjprabhu** · 2008-05-21, 08:06 AM

Hi,

i have created a report in iReport.. Its working fine over there.
But when i want to use it in SugarCrm using Use Jasper Reports Template, i get the following error:

error compiling report UsersReport1.jrxml - cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/UsersReport1.jasper_files/;modules/ZuckerReports/jasper/ant-1.5.1.jar;modules/ZuckerReports/jasper/antlr-2.7.5.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.0.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-2.0.1.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/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.jar;modules/ZuckerReports/jasper/zuckerreports-1.0.jar" at.go_mobile.zuckerreports.JasperCompileMain C:\Program Files\sugarcrm-5.0.0b/php/tmp\php5EB.tmp modules/ZuckerReports/resources/UsersReport1.jasper 2>&1
JasperBatchMain :: compiling jasper design C:\Program to Files\sugarcrm-5.0.0b/php/tmp\php5EB.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:172)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:152)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:151)
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:167)
... 3 more

can anyone plz tell me how to solve this thing

Thanks and regards
jjprabhu

**tomcdonnell** · 2010-05-04, 11:50 PM

I have the same situation and what I think is the same problem. Below is my error message as copied directly from the output of the ZuckerReports module after attempting to save a .jrxml file. The .jrxml file works correctly in iReport running on the same server.

error compiling report contacts_count_by_first_name.jrxml - cmdline: javaw -classpath "custom/ZuckerReports/resources/;custom/ZuckerReports/resources/contacts_count_by_first_name.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.1\php\tmp\php28.tmp custom/ZuckerReports/resources/contacts_count_by_first_name.jasper 2>&1
JasperBatchMain :: compiling jasper design C:\Program to Files\sugarcrm-5.5.1\php\tmp\php28.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.(FileInputStream.java:106)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:163)
... 3 more

My operating system is Windows XP. I do not think it is a PATH problem, at least not with the javaw.exe file. Both java.exe and javaw.exe can be executed from the command-line from directories other than that in which those files reside.

Earlier after installing the JDK I removed java.exe and javaw.exe from the WINDOWS\system32 directory to solve a file-shadowing problem where due to the order in which directories were listed in the PATH the WINDOWS\system32 files would execute rather than the JDK versions.

From the error message "JasperBatchMain :: java.io.FileNotFoundException: C:\Program (The system cannot find the file specified)" it appears that the problem may be related to the presence of a space in the 'Program Files' directory. I have however installed SugarCRM and ZuckerReports successfully on another Windows server with the same directory structure. In both the working server and the one with the problem, JDK is installed at 'C:\Program Files\Java\jdk1.6.0_20'. I removed the java executables from WINDOWS\system32 on the working server also. The ZuckerReports file installed on both servers is ZuckerReports_1.12_module.zip.

Any help would be much appreciated.

**tomcdonnell** · 2010-05-05, 12:30 AM

Solved. In the file 'php.ini' I commented out the line 'upload_tmp_dir = "C:\Program Files\sugarcrm-5.5.1/php/tmp"', then restarted Apache. The edit caused the system default TEMP directory to be used instead of the one previously specified. The system default TEMP directory was 'C:\WINDOWS\TEMP', which does not contain a space, and so the file could be found and the exception was no longer generated. Any other directory without a space would have presumably worked also.