zucker reports & excel

[mikesolomon]

If I create a report in zucker reports using create new jasper reports template the report works fine as a pdf but if I choose type excel I get the following error

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.createDraw ingPatriarch()Lorg/apache/poi/hssf/usermodel/HSSFPatriarch;
at net.sf.jasperreports.engine.export.JRXlsExporter.c reateSheet(JRXlsExporter.java:170)
at net.sf.jasperreports.engine.export.JRXlsAbstractEx porter.exportReportToStream(JRXlsAbstractExporter. java:406)
at net.sf.jasperreports.engine.export.JRXlsAbstractEx porter.exportReport(JRXlsAbstractExporter.java:218 )
at at.go_mobile.zuckerreports.JasperBatchMain.main(Ja sperBatchMain.java:135)

Any ideas how to fix this?

[elvispresley99]

Did you ever get a response on this? I get something similar, regardless of which jasper report I try to create (pdf, excel or whatever).

error compiling report FCP Forecast Report.jrxml - cmdline: java -Djava.awt.headless=true -classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/FCP Forecast Report.jasper_files/:modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:modules/ZuckerReports/jasper/bsh-2.0b4.jar:modules/ZuckerReports/jasper/jpa.jar:modules/ZuckerReports/jasper/servlet.jar:modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/zuckerreports-1.0.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:modules/ZuckerReports/jasper/groovy-all-1.0.jar:modules/ZuckerReports/jasper/jfreechart-1.0.0.jar:modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/jaxen-1.1.1.jar:modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar:modules/ZuckerReports/jasper/xml-apis.jar:modules/ZuckerReports/jasper/jxl-2.6.jar:modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar:modules/ZuckerReports/jasper/ant-1.5.1.jar:modules/ZuckerReports/jasper/jasperreports-2.0.1.jar:modules/ZuckerReports/jasper/antlr-2.7.5.jar:modules/ZuckerReports/jasper/xalan.jar:modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/commons-beanutils-1.7.jar:modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/saaj-api-1.3.jar:modules/ZuckerReports/jasper/commons-digester-1.7.jar:modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar:modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar:modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar:" at.go_mobile.zuckerreports.JasperCompileMain /tmp/phpgY5NvD modules/ZuckerReports/resources/FCP Forecast Report.jasper 2>&1
/usr/bin/java: line 67: /tmp/javaw28342: Permission denied
/usr/bin/java: line 67: exec: /tmp/javaw28342: cannot execute: Permission denied


Any ideas on what's causing these problems?


Ver.5.0.e SugarCRM and Zucker 1.8

[mikesolomon]

Did you ever get a response on this? I get something similar, regardless of which jasper report I try to create (pdf, excel or whatever).

error compiling report FCP Forecast Report.jrxml - cmdline: java -Djava.awt.headless=true -classpath "modules/ZuckerReports/resources/:modules/ZuckerReports/resources/FCP Forecast Report.jasper_files/:modules/ZuckerReports/jasper/commons-javaflow-20060411.jar:modules/ZuckerReports/jasper/bsh-2.0b4.jar:modules/ZuckerReports/jasper/jpa.jar:modules/ZuckerReports/jasper/servlet.jar:modules/ZuckerReports/jasper/hibernate3.jar:modules/ZuckerReports/jasper/xercesImpl.jar:modules/ZuckerReports/jasper/zuckerreports-1.0.jar:modules/ZuckerReports/jasper/jcommon-1.0.0.jar:modules/ZuckerReports/jasper/groovy-all-1.0.jar:modules/ZuckerReports/jasper/jfreechart-1.0.0.jar:modules/ZuckerReports/jasper/commons-collections-2.1.jar:modules/ZuckerReports/jasper/jaxen-1.1.1.jar:modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar:modules/ZuckerReports/jasper/xml-apis.jar:modules/ZuckerReports/jasper/jxl-2.6.jar:modules/ZuckerReports/jasper/jdt-compiler-3.1.1.jar:modules/ZuckerReports/jasper/ant-1.5.1.jar:modules/ZuckerReports/jasper/jasperreports-2.0.1.jar:modules/ZuckerReports/jasper/antlr-2.7.5.jar:modules/ZuckerReports/jasper/xalan.jar:modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar:modules/ZuckerReports/jasper/commons-logging-1.0.2.jar:modules/ZuckerReports/jasper/commons-beanutils-1.7.jar:modules/ZuckerReports/jasper/png-encoder-1.5.jar:modules/ZuckerReports/jasper/saaj-api-1.3.jar:modules/ZuckerReports/jasper/commons-digester-1.7.jar:modules/ZuckerReports/jasper/jakarta-bcel-20050813.jar:modules/ZuckerReports/jasper/hsqldb-1.7.1.jar:modules/ZuckerReports/jasper/itext-1.3.1.jar:modules/ZuckerReports/jasper/poi-3.0.1-FINAL-20070705.jar:" at.go_mobile.zuckerreports.JasperCompileMain /tmp/phpgY5NvD modules/ZuckerReports/resources/FCP Forecast Report.jasper 2>&1
/usr/bin/java: line 67: /tmp/javaw28342: Permission denied
/usr/bin/java: line 67: exec: /tmp/javaw28342: cannot execute: Permission denied


Any ideas on what's causing these problems?


Ver.5.0.e SugarCRM and Zucker 1.8

That looks like a permissions problem

I solved my problem by deleting the jasper directory and then restoring it from an old backup