Error: Jasper report upload

[bhawin13]

Hello,

I have tried to create r1.jrxml file through ireport and run in ireport it gives perfect output.

But when i try to upload to zucker report using create new jasper report template it gives follwing error

=========================
error compiling report r1.jrxml - cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/r1.jasper_files/;modules/ZuckerReports/jasper/antlr-2.7.5H3.jar;modules/ZuckerReports/jasper/asm-attrs.jar;modules/ZuckerReports/jasper/asm.jar;modules/ZuckerReports/jasper/barbecue-1.1.jar;modules/ZuckerReports/jasper/bsh-1.3.0.jar;modules/ZuckerReports/jasper/cglib-2.1.jar;modules/ZuckerReports/jasper/commons-beanutils-1.5.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/dom4j-1.6.jar;modules/ZuckerReports/jasper/ehcache-1.1.jar;modules/ZuckerReports/jasper/groovy-all-1.0-beta-10.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/jasperreports-1.2.2.jar;modules/ZuckerReports/jasper/jcmdline-1.0.2.jar;modules/ZuckerReports/jasper/jcommon-1.0.0.jar;modules/ZuckerReports/jasper/jdt-compiler.jar;modules/ZuckerReports/jasper/jfreechart-1.0.0.jar;modules/ZuckerReports/jasper/jr-bsh-compiler.jar;modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar;modules/ZuckerReports/jasper/jta.jar;modules/ZuckerReports/jasper/jxl.jar;modules/ZuckerReports/jasper/log4j-1.2.8.jar;modules/ZuckerReports/jasper/looks-2.0-rc.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar;modules/ZuckerReports/jasper/nsisant-1.1.jar;modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-2.0-final-20040126.jar;modules/ZuckerReports/jasper/tinylaf.jar;modules/ZuckerReports/jasper/toniclf.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 d:\Program\ Files\xampp\tmp1\php2C7.tmp modules/ZuckerReports/resources/r1.jasper 2>&1
JasperBatchMain :: compiling jasper design d:\Program\ to Files\xampp\tmp1\php2C7.tmp
JasperBatchMain :: d:\Program (The system cannot find the file specified)
java.io.FileNotFoundException: d:\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:166)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:151)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:142)
at at.go_mobile.zuckerreports.JasperCompileMain.main( JasperCompileMain.java:17)

NESTED BY :
java.io.FileNotFoundException: d:\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:166)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:151)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:142)
at at.go_mobile.zuckerreports.JasperCompileMain.main( JasperCompileMain.java:17)

NESTED BY :
net.sf.jasperreports.engine.JRException: d:\Program (The system cannot find the file specified)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:171)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:151)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:142)
at at.go_mobile.zuckerreports.JasperCompileMain.main( JasperCompileMain.java:17)
Caused by: java.io.FileNotFoundException: d:\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:166)
... 3 more
=========================
I tried to check uploaded file but uploaded file not found in tmp1 dir.

tmp1 dir is set in php.ini for upload_tmp_dir

Can anybody please guide me what is problem and how to solve it.


I am using
zucker report 1.6g
sugar 4.5f
windows xp pro
apache 2.2
php 5.x
mysql 5.x
java 1.4.2

Thanks

[mance.harmon]

I solved this problem by:

1) Open the php.ini
2) Comment out the following line:

;upload_tmp_dir = "C:\Program Files\sugarcrm-4.5.1e/php/tmp"

I am using 4.5.1e on Windows XP.

[enrikm]

I have tried this approach and I'm still getting similar results. Any other suggestions?

[charitha]

I solved it as well, although it involved a couple of things from other forums/topics. Not sure which one solved it though, will be looking into it.

1. Added a classes.jar file.
Read http://www.sugarcrm.com/forums/showt...=zuckerreports
File is available from: http://www.javalobby.org/java/forums/t52073.html

2. Commented the 'upload_tmp_dir ... ' in the PHP.ini file.

[BadAssFlip]

guys, im having the same problem. i commented out that one line and downloaded the classes.jar file and save it in the surgarCRM/php/ directory, but the same error still pops up! any ideas?

[BadAssFlip]

i fixed the problem with the above changes + changing the port number to match mysql from your root\modules\ZuckerReportTemplate\ReportTemplate.p hp (it was default as 3306, and i changed it to 8070). I was able to create a report from ireport and have it uploaded to jasper report.

but, somehow two days later, all my settings got reset back to default. I tried to do the same thing again, but the same error keeps coming back

[BadAssFlip]

Could someone please post the .jar files that should be included in the CLASSPATH?

[kaymenji]

I am using the SugarCRM 5.0.0b. And I encountered the same problem. And I solved it by modifyig the php.ini to change
upload_tmp_dir = "C:/Programs Files/Sugarcrm/php/tmp" to upload_tmp_dir = "D:/test" (some paths which doesn't contain space), and it works for me. Hope it could help you.

[adamlee]

Hi I am using both 5.0.0f and 4.5.1h version. The solution below work fine for 5.0.0f version but not 4.5.5h.

In 4.5.1h version, once i uploaded the jrxml file, the page keep loading and loading without any result or error.
I also try to uninstall all ZuckerReports so that I can re-install, unfortunately, the same thing happend, the page keep loading when uninstalling.

Can any one help plsease.

Thanks in advance.

I am using the SugarCRM 5.0.0b. And I encountered the same problem. And I solved it by modifyig the php.ini to change
upload_tmp_dir = "C:/Programs Files/Sugarcrm/php/tmp" to upload_tmp_dir = "D:/test" (some paths which doesn't contain space), and it works for me. Hope it could help you.