Installing ZuckerReports 2.x

This article describes the installation of ZuckerReports 2.x.

Getting Started

Before starting installation, choose your deployment model. You either need a server-side Java Developers Kit
Installation, or you will have to apply for a ZuckerReports On-Demand account. Please see the “ZuckerReports2 Hosting Fact Sheet” for details on how to choose the right deployment model for you.

Module Installation

Install ZuckerReports_2.0_module.zip with the SugarCRM Module Loader. This package contains the ZuckerReports main modules.

Install JDK and JasperReports libraries (optional)

If you choose the “Local JDK” deployment option, additionally install a JDK and the ZuckerReports_Jasper-4.0.0_module.zip module. It contains the JasperReports libraries and is pretty large in size. In case you have troubles uploading the package to the SugarCRM Module Loader, increase the “post_max_size” and “upload_max_filesize” in your php.ini, and  starting from SugarCRM 6.4, you will have to increase the “upload_max_size” parameter in your config.php. The instructions for ZuckerReports 1.x contain more information on these steps.

You don’t have to do this step if you have a ZuckerReports On-Demand account!

ZuckerReports Configuration

Have a look at the ZuckerReports configuration screen in the Admin section of SugarCRM.
Make your adaptions or accept the defaults. If you have a ZuckerReports On-Demand account, enter the received details here. The configuration parameters are documented right on the screen. See below for details.

Install Demo Reports

Install the ZuckerReports2_DemoPack.zip module for a set of basic reports to test functionality of ZuckerReports.

ZuckerReports Configuration Settings

The Admin section of SugarCRM contains a “ZuckerReports Configuration” screen. After adapting the settings, don’t forget to press the “Save” button!

ZuckerReports Start Page

Select which View is shown when entering the ZuckerReports module

PHP Script Enabled

set this to yes/no, if you want to enable/disable php scripting for report parameters

Debug Mode Enabled

set this to yes/no, if you want to enable/disable debug output when running a report – this is the first step in troubleshooting

Output Charset

enter your encoding here (f.e. “UTF-8″), if different from sugar default. see here for supported encodings

Deployment Mode (JDK)

If you have a JDK installed locally, choose “Local JDK”. Otherwise you will have to run a ZuckerReports On-Demand Server.

Local JDK Path

Enter the path to your java executable here, if autodetection doesn’t work.

  • Windows Environment Default: “javaw %ARGS% 2>&1″
  • For Java Web Start installations: “javaws %ARGS% 2>&1″
  • Unix Environment Default: “java -Djava.awt.headless=true %ARGS% 2>&1″

You may try to enter the full absolute path here, but avoid pathes with spaces (f.e. “C:/Program Files/…” won’t work).

Make sure that you also include the “%ARGS ….” extension in the path given here. You can test you settings by using the “Test Java” button.

PHP Exec mode

There are several possibilities to run an external command (as Java) in PHP. The default option is “exec”, but as behaviour is inconsistent between PHP and OS versions, it may be worth a try to swicht to “shell_exec” – especially if ZuckerReports doesn’t show detailed error messages on Report Exception or Report compilation.

JDBC URL Extension

if you get the error

“Value ’0000-00-00′ can not be represented as java.sql.Date”

then enter “?zeroDateTimeBehavior=convertToNull” here and it may work (only for “Local JDK” mode)

On-Demand Service Url

The Url of your ZuckerReports On-Demand Server instance (end with “/”)

This Url is provided to you by ZuckerFriends when activating a Demo account or a Live account for ZuckerReports On-Demand.

On-Demand App Secret

The App Secret of your ZuckerReports On-Demand Server instance

This App Secret is provided to you by ZuckerFriends when activating a Demo account or a Live account for ZuckerReports On-Demand.

ZuckerReports Webservice Url

The Url of your ZuckerReports Webservice as seen from your ZuckerReports On-Demand Server instance (if empty, it will point to “<your sugar instance url>/custom/ZuckerReports2/service/v4/rest.php”).

If your Sugar server is accessible from the “outside world” with another IP/Host than used internally, you will have to adapt this value. Your Sugar server has to be accessible from the Amazon EWS cloud. You have to enter the full path to the ZuckerReports Webservice here, for example:

http(s)://<your-external-ip>/<your-path-to-sugar>/custom/ZuckerReports2/service/v4/rest.php

Note: You can use either HTTP or HTTPS here. There is no certificate validation enabled.

Sugar User

This user will be used by ZuckerReports On-Demand to access your ZuckerReports Webservice

 

 

78 Responses to “Installing ZuckerReports 2.x”

  1. fx says:

    hy there.
    i installed this module.
    the local jdk as well.
    now what do i need to do to configure it ?
    what do i need to enter in the admin zucker reports config fields ?
    mostly what should i enter in “Local JDK Path” ?
    when i create a new report i get “Database failure. Please refer to sugarcrm.log for details.” under it after i click save.

    • zuckerfriends says:

      Hi, I will add some posts today for troubleshooting Zuckerreports installation. you fill find some hints what to check then.

  2. fx says:

    When i load a ireport template i get “error compiling report Bugs.jrxml – cmdline: java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Bugs.jasper_files/:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/xalan.jar” at.go_mobile.zuckerreports.JasperCompileMain /tmp/phpRADiYd custom/ZuckerReports2/resources/Bugs.jasper 2>&1 ”
    I have centos with java version “1.7.0_05″.
    In local jdk path i have “java -Djava.awt.headless=true %ARGS% 2>&1″
    In “modules/zr2_Report/jasper” i only have zuckerreports-1.0.jar (from the installation) and xalan.jar (from “Jaspersoft\iReport-4.7.0\ireport\libs\”.

    • zuckerfriends says:

      I think you havnt installed the jasperreports package, please download from the zuckerreports sourceforge page and install – see instructions

      • fx says:

        I reinstalled the lib module (the big zip archive).
        Now i get “error compiling report Bugs.jrxml – cmdline: java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Bugs.jasper_files/:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/xalan.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar” at.go_mobile.zuckerreports.JasperCompileMain /tmp/phptJyFPH custom/ZuckerReports2/resources/Bugs.jasper 2>&1 “

  3. fx says:

    same thing :( error compiling report Bugs.jrxml – cmdline: /usr/java/jdk1.7.0_05/bin/java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Bugs.jasper_files/:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/xalan.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar” at.go_mobile.zuckerreports.JasperCompileMain /tmp/php8qET0E custom/ZuckerReports2/resources/Bugs.jasper 2>&1

  4. [...] you have to enter the full absolute path to java in the ZuckerReports Configuration ? (no space in directory names [...]

  5. error says:

    I am getting different error.

    cmdline: javaw -classpath “custom/ZuckerReports2/resources/;custom/ZuckerReports2/resources/report3.jasper_files/;modules/zr2_Report/jasper/ant-1.7.1.jar;modules/zr2_Report/jasper/antlr-2.7.5.jar;modules/zr2_Report/jasper/barbecue-1.5-beta1.jar;modules/zr2_Report/jasper/barcode4j-2.0.jar;modules/zr2_Report/jasper/batik-anim.jar;modules/zr2_Report/jasper/batik-awt-util.jar;modules/zr2_Report/jasper/batik-bridge.jar;modules/zr2_Report/jasper/batik-css.jar;modules/zr2_Report/jasper/batik-dom.jar;modules/zr2_Report/jasper/batik-ext.jar;modules/zr2_Report/jasper/batik-gvt.jar;modules/zr2_Report/jasper/batik-parser.jar;modules/zr2_Report/jasper/batik-script.jar;modules/zr2_Report/jasper/batik-svg-dom.jar;modules/zr2_Report/jasper/batik-svggen.jar;modules/zr2_Report/jasper/batik-util.jar;modules/zr2_Report/jasper/batik-xml.jar;modules/zr2_Report/jasper/bcel-5.2.jar;modules/zr2_Report/jasper/bsh-2.0b4.jar;modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar;modules/zr2_Report/jasper/commons-collections-2.1.1.jar;modules/zr2_Report/jasper/commons-digester-1.7.jar;modules/zr2_Report/jasper/commons-javaflow-20060411.jar;modules/zr2_Report/jasper/commons-logging-1.0.4.jar;modules/zr2_Report/jasper/groovy-all-1.7.5.jar;modules/zr2_Report/jasper/hibernate3.jar;modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar;modules/zr2_Report/jasper/iText-2.1.7.jar;modules/zr2_Report/jasper/jasperreports-4.0.0.jar;modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar;modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar;modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar;modules/zr2_Report/jasper/jaxen-1.1.1.jar;modules/zr2_Report/jasper/jcommon-1.0.15.jar;modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar;modules/zr2_Report/jasper/jfreechart-1.0.12.jar;modules/zr2_Report/jasper/jpa.jar;modules/zr2_Report/jasper/jxl-2.6.10.jar;modules/zr2_Report/jasper/log4j-1.2.15.jar;modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar;modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar;modules/zr2_Report/jasper/png-encoder-1.5.jar;modules/zr2_Report/jasper/poi-3.6.jar;modules/zr2_Report/jasper/rhino-1.7R1.jar;modules/zr2_Report/jasper/saaj-api-1.3.jar;modules/zr2_Report/jasper/serializer.jar;modules/zr2_Report/jasper/servlet.jar;modules/zr2_Report/jasper/spring-beans-2.5.5.jar;modules/zr2_Report/jasper/spring-core-2.5.5.jar;modules/zr2_Report/jasper/xalan-2.7.1.jar;modules/zr2_Report/jasper/xercesImpl-2.7.0.jar;modules/zr2_Report/jasper/xml-apis-ext.jar;modules/zr2_Report/jasper/xml-apis.jar;modules/zr2_Report/jasper/zuckerreports-1.0.jar” at.go_mobile.zuckerreports.JasperBatchMain custom/ZuckerReports2/temp/85dbdf6b-b5ce-5a97-5e0b-5045cce29c31/cmd.properties 2>&1
    JasperBatchMain :: loading jasper design custom/ZuckerReports2/resources/report3.jasper
    JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
    JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
    JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
    JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
    JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
    JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
    JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
    JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
    JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
    JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
    JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
    JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
    JasperBatchMain :: getParameterValue(SORT_FIELDS, java.util.List) => null
    JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
    JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null
    JasperBatchMain :: exporting report …
    JasperBatchMain :: finished

    • zuckerfriends says:

      This is not an error – it actually means that the report was created successfully. You can disable the Debug mode in the ZuckerReports Admin panel so you won’t see this logging again.

  6. xzyyy says:

    i got the error too, and more, i found if i input “java -Djava.awt.headless=true %ARGS% 2>&1″ in Local JDK Path and click test, it returns me failed. but if i remove “2>&1″ it returns me success. but whether i fill this blank with/without 2>&1, it returns me the same error. i follow your chapter “Check the ZuckerReports command line”, it returns me “-bash: 1java: ambiguous redirect”.
    could you please help me with it?
    thansk a lot

    • xzyyy says:

      sorry, i found i run command line in the wrong directory, i try it again, and this time it returns me:

      JasperBatchMain :: compiling jasper design /var/tmp/phpyWkz4c to custom/ZuckerReports2/resources/Activity.jasper
      JasperBatchMain :: java.io.FileNotFoundException: /var/tmp/phpyWkz4c (No such file or directory)
      net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: /var/tmp/phpyWkz4c (No such file or directory)
      at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:174)
      at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:154)
      at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:146)
      at at.go_mobile.zuckerreports.JasperCompileMain.main(JasperCompileMain.java:17)
      Caused by: java.io.FileNotFoundException: /var/tmp/phpyWkz4c (No such file or directory)
      at gnu.java.nio.channels.FileChannelImpl.open(libgcj.so.10)
      at gnu.java.nio.channels.FileChannelImpl.(libgcj.so.10)
      at gnu.java.nio.channels.FileChannelImpl.create(libgcj.so.10)
      at java.io.FileInputStream.(libgcj.so.10)
      at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:169)
      …3 more
      any suggestion? thanks a lot

      • xzyyy says:

        btw again, because i’m on a virtual host, i can’t run “java…” with sudo, i just run it directly.

      • zuckerfriends says:

        I added an additional hint to the Troubleshooting page – you should replace the temporary path /var/tmp/… with the real path to your JRXML file.

        • xzyyy says:

          now it returns:

          JasperBatchMain :: compiling jasper design cache/upload/Activity.jrxml to custom/ZuckerReports2/resources/Opportunities.jasper
          log4j:WARN No appenders could be found for logger (net.sf.jasperreports.engine.xml.JRXmlDigesterFactory).
          log4j:WARN Please initialize the log4j system properly.

          (.:32738): Gtk-WARNING **: cannot open display:
          does it run well?

          • xzyyy says:

            i’m very strange that why the test button returns failed when i add 2>&1 to the end of the path, do you have any idea?
            thanks a lot

          • xzyyy says:

            btw, i’m translating your mod to chinese now, could you please tell me how to send you the package when i finish it?

          • zuckerfriends says:

            the “cannot open display” error is usually fixed with the adding the “-Djava.awt.headless=true” option to the Java Commandline

          • zuckerfriends says:

            Please send the files to office “at” zuckerfriends.com.
            Thanks.

    • zuckerfriends says:

      The “2>&1″ suffix to the commandline makes the shell redirect the output of the “STDERR” stream of the Java program to “STDOUT” – it actually means that you get better diagnostics information. If you remove it from the commandline, then “java -version” won’t give any result (as it writes to the STDERR stream).

  7. Michael Deng says:

    We followed the instruction to install the JDK – /usr/java/jdk1.5.0_15, Jasperreport 4.0, zuckerreports 2.03, zuckerreports -demo pack.
    when we config zuckerreport, we choosed:
    start page: Report Archieve
    Php Script Enabled: yes
    Debug Mode Enabled: yes
    Output Charset: blank
    Deployment Mode (JDK): Local JDK
    Local JDK path: /usr/java/jdk1.5.0_15/java -Djava.awt.headless=true %ARGS% 2>&1
    or /usr/java/jdk1.5.0_15/bin/java -Djava.awt.headless=true %ARGS% 2>&1
    java -Djava.awt.headless=true %ARGS% 2>&1
    PHP Exec mode: exec and shell_exec (we tried both)

    when try button test java, it’s always failed. We used root to install Java, but SugarCRM is set to default apache.

    More information for this: we granted xr rights to all for all Java files but it still did not work. and we searched all the blogs and forum but can not find out why.

    and after we installed the demo pack, we can not find the related module or button for this package at all.

    we have tried all what we could find but we still can not get it fixed. and the same time, there’s no error show in SugarCRM/ZuckerReports. and we run the command java -Djava.awt.headless=true %ARGS% 2>&1 on our server, it does return the Java version.

    I believe there is something wrong but we can not figure out. Anybody can help? thanks in advance.

    Michael

    • Michael Deng says:

      And I followed xzyyy suggestion to remove ” 2>&1″, and test java again, it shows Success. and our enviroment is similiar with his – on Amazon Virtual host.
      Hope this could help to analysis. thanks

  8. Michael Deng says:

    And I tried few demo reports: when I run it first time, it shows success, but when you run it again, it show error.
    and for the file sent by ZR, it’s blank, no data in – I created data before run the report.

  9. Michael Deng says:

    Here is the error information:
    cmdline: java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/MeetingPrintout.jasper_files/:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:” at.go_mobile.zuckerreports.JasperBatchMain custom/ZuckerReports2/temp/2e47cf84-aeda-8dda-26fe-5046a2c65c0a/cmd.properties
    JasperBatchMain :: loading jasper design custom/ZuckerReports2/resources/MeetingPrintout.jasper
    JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
    JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
    JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
    JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
    JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
    JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
    JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
    JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
    JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
    JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
    JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
    JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
    JasperBatchMain :: getParameterValue(SORT_FIELDS, java.util.List) => null
    JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
    JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null
    JasperBatchMain :: getParameterValue(MEETING_ID, java.lang.String) => 3c64287f-5f94-64a8-63d8-5046a2a75085
    JasperBatchMain :: getSugarDetailsLink(Meetings, 3c64287f-5f94-64a8-63d8-5046a2a75085) => http://dev.verican.ws/sugar0/index.php?module=Meetings&action=DetailView&record=3c64287f-5f94-64a8-63d8-5046a2a75085

    • zuckerfriends says:

      This is not error information, just debug output. Java seems to run the report quite well. Are there any files created in /custom/ZuckerReports2/Temp directory ?

  10. Michael Deng says:

    at last, we made it work.
    1. we re-install the jasperreport;
    2. design ireport again.
    3. remove all uuid element from the jrxml file.
    now it does work now.

  11. xzyyy says:

    i found a very strange thing that when i upload a jrxml file to add a new report, i can’t find it with command “find”. it seems this files isn’t be uploaded well.
    any suggestion?

  12. xzyyy says:

    it returns me:

    error compiling report Opportunities.jrxml – cmdline: java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Opportunities.jasper_files/:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar” at.go_mobile.zuckerreports.JasperCompileMain /var/tmp/phpQrn5sT custom/ZuckerReports2/resources/Opportunities.jasper

    i have checked custom/ZuckerReports2/resources, it’s a empty directory and there isn’t a Opportunities.jasper here.
    is this what the problem is?
    thanks a lot

  13. xzyyy says:

    i add a export “DISPLAY=:0.0″ to add a display in my env vars, and upload a jrxml file manually. now it don’t display the old error, but new error here….

    t
    Exception in thread “main” java.lang.NoClassDefFoundError: at.go_mobile.zuckerreports.JasperCompileMain
    at gnu.java.lang.MainThread.run(libgcj.so.10)
    Caused by: java.lang.ClassNotFoundException: at.go_mobile.zuckerreports.JasperCompileMain not found in gnu.gcj.runtime.SystemClassLoader{urls=[], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
    at java.net.URLClassLoader.findClass(libgcj.so.10)
    at java.lang.ClassLoader.loadClass(libgcj.so.10)
    at java.lang.ClassLoader.loadClass(libgcj.so.10)
    at gnu.java.lang.MainThread.run(libgcj.so.10)

    any suggestion?

    • xzyyy says:

      sorry, this post is wrong because i run it in a wrong directory, the result is:

      (.:32738): Gtk-WARNING **: cannot open display:

      still, my jdk is 1.5 and i don’t know why headless setting don’t become effective, some advice plz.
      thanks a lot.

  14. xzyyy says:

    finally i solve the problem, i use a wrong java verison, it’s gnu gcj on my server, not jdk. it will ignore headless option, i install a sun jdk and it runs well now. btw, please don’t use a ireport 4.6+ with zucker, or you need delete all uuid manually.

  15. Peter says:

    Hi Guys, I am having problem with setting up Zucker to use java, no matter what I do I fail. Thats my java version:

    java version “1.6.0_27″
    Java(TM) SE Runtime Environment (build 1.6.0_27-b07)
    Java HotSpot(TM) 64-Bit Server VM (build 20.2-b06, mixed mode)

    running on Ubuntu 10.04.4 LTS

    The path I set in Zucker settings is:

    /usr/lib/jvm/java-6-openjdk/bin/java -Djava.awt.headless=true %ARGS% 2>&1

    Any help immensely appreciated : )

  16. Lars says:

    I have Installed the following: ZuckerReports2 v.2.03 and ZuckerReports2 – Jasper-4.0.0 to SugarCE 6.5.4.
    ZuckerReports Configuration settings:
    * ZuckerReports Start Page: On-Demand Reporting
    * PHP Script Enabled: Yes
    * Debug Mode Enabled: Yes
    * Output Charset: UTF-8
    * Deployment Mode (JDK): Local JDK
    * Local JDK Path: C:/Java/jdk1.7.0_07/bin/javaw.exe %ARGS% 2>&1
    * PHP Exec mode: exec
    When I do the Test Java it reorts:
    Exec Result: Failed

    On-Demand Service Url: custom/ZuckerReports2/service/v4/rest.php
    ZuckerReports Webservice Url: http://localhost/custom/ZuckerReports2/service/v4/rest.php

    When I then go to ZuckerReports from the menu and select Report Archive Then Archive from the list,
    and use create to make a new one, I get the following warnings:
    Warning: array_key_exists(): The first argument should be either a string or an integer in C:\sugarce\modules\zr2_Report\zr2_Report.php on line 45
    After saving the report and I try to open it again, I get the following Error:
    Warning: array_key_exists(): The first argument should be either a string or an integer in C:\sugarcrm\modules\zr2_Report\zr2_Report.php on line 45 {“content”:”

    What do I do wrong here?

    • zuckerfriends says:

      Hi,
      this is a kind of bug in ZuckerReports. You could just disable warnings in your php.ini file to get rid of this message, it is not critical.

  17. Josh says:

    Hi there, this is what I get when trying to run one of my reports which works just fine under iReport:

    Error while running Report
    cmdline: javajdk -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Tee.jasper_files/:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/batik-xml.jar:” at.go_mobile.zuckerreports.JasperBatchMain custom/ZuckerReports2/temp/6ef30f96-99ff-637f-b89b-506c0fb34b28/cmd.properties
    JasperBatchMain :: loading jasper design custom/ZuckerReports2/resources/Tee.jasper
    JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
    JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
    JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
    JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
    JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
    JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
    JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
    JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
    JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
    JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
    JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
    JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
    JasperBatchMain :: getParameterValue(SORT_FIELDS, java.util.List) => null
    JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
    JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null

    That’s the path to my Java JDK:

    javajdk -Djava.awt.headless=true %ARGS%

    I removed “2>&1″ as I get less information.

    Help please I’ve been stuck on this forever. Thanks

  18. Sohan says:

    Hi all,
    I’m getting the following error message when I press the Test Java button.

    Exec Result: Failed
    cmdline: /usr/java/jdk1.6.0_35/bin/java -Djava.awt.headless=true -version 2>&1

    I would really appreciate any help you can give me!

  19. aristegi says:

    I have installed Zuckerreports 2.03 and when I try to run a reports the system show this error.

    I have installed in debian server java version “1.6.0_18″
    OpenJDK Runtime Environment (IcedTea6 1.8.13) (6b18-1.8.13-0+squeeze2)
    OpenJDK Server VM (build 14.0-b16, mixed mode)

    Error while running Report
    cmdline: java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Opportunities.jasper_files/:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/batik-gvt.jar:” at.go_mobile.zuckerreports.JasperBatchMain custom/ZuckerReports2/temp/35304272-3c09-6cf8-a9ff-5098fe59f042/cmd.properties 2>&1
    JasperBatchMain :: loading jasper design custom/ZuckerReports2/resources/Opportunities.jasper
    JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
    JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
    JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
    JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
    JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
    JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
    JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
    JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
    JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
    JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
    JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
    JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
    JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
    JasperBatchMain :: getParameterValue(SORT_FIELDS, java.util.List) => null
    JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
    JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null
    log4j:WARN No appenders could be found for logger (net.sf.jasperreports.extensions.ExtensionsEnvironment).
    log4j:WARN Please initialize the log4j system properly.
    Exception in thread “main” net.sf.jasperreports.engine.util.JRFontNotFoundException: Font ‘Arial’ is not available to the JVM. See the Javadoc for more details.
    at net.sf.jasperreports.engine.util.JRFontUtil.checkAwtFont(JRFontUtil.java:358)
    at net.sf.jasperreports.engine.util.JRStyledText.getAwtAttributedString(JRStyledText.java:226)
    at net.sf.jasperreports.engine.fill.TextMeasurer.measure(TextMeasurer.java:362)
    at net.sf.jasperreports.engine.fill.JRFillTextElement.chopTextElement(JRFillTextElement.java:1130)
    at net.sf.jasperreports.engine.fill.JRFillStaticText.prepare(JRFillStaticText.java:183)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:329)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:419)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:378)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:328)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:262)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
    at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
    at at.go_mobile.zuckerreports.JasperBatchMain.main(JasperBatchMain.java:126)

    • zuckerfriends says:

      The Arial font is not available on Linux systems by default. You may either remove the font declarations from your report design or try to install the Arial font to your JRE (google gives plenty of information – for example this page).

  20. Keith says:

    I click Run Report and a pop up opens with:
    The requested URL /custom/ZuckerReports2/archive//121129_144312_opportunities.pdf was not found on this server.

    Environment:
    CentOS 5.8
    Sugar 6.5.8
    ZuckerReports2 – Jasper-4.0.0
    ZuckerReports2
    ZuckerReports2 – DemoPack
    ZuckerReports settings:
    Start Page On-Demand
    PHP Script Enabled Yes
    Debug Mode Enabled Yes
    Local JDK
    No path set for Local JDK and “Test Java” = Exec Result: Success
    PHP Exec mode set to exec
    Remaining fields are blank.

    I do see in the web site log file:

    File does not exist: /www/myURL/SugarCRM/custom/ZuckerReports2/archive/121129_144312_opportunities.pdf, referer: http://myURL/index.php?module=zr2_Report&action=ReportOnDemand&run=true&record=62b4c0a9-e95e-c0a3-0b1a-50b792e6978f&format=PDF&parent_module=&parent_id=&parent_name=&parent_category=&send_email=&button=++Run+Report++

    I get same error for html and excel as well
    Any help or nudge would be GREATLY appreciated!
    Thanks!

    • Keith says:

      More information when i forced path for local JDK:

      Output

      Error while running Report
      cmdline: /usr/bin/java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/Opportunities.jasper_files/:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/bsh-2.0b4.jar:modules/zr2_Report/jasper/antlr-2.7.5.jar:modules/zr2_Report/jasper/xercesImpl-2.7.0.jar:modules/zr2_Report/jasper/rhino-1.7R1.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/spring-beans-2.5.5.jar:modules/zr2_Report/jasper/jasperreports-javaflow-4.0.0.jar:modules/zr2_Report/jasper/commons-logging-1.0.4.jar:modules/zr2_Report/jasper/barcode4j-2.0.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/spring-core-2.5.5.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/jasperreports-applet-4.0.0.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.0.0.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/commons-digester-1.7.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.0.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/jasperreports-4.0.0.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/poi-3.6.jar:modules/zr2_Report/jasper/mondrian-3.1.1.12687.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/mysql-connector-java-3.1.11-bin.jar:modules/zr2_Report/jasper/servlet.jar:modules/zr2_Report/jasper/xalan-2.7.1.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/serializer.jar:modules/zr2_Report/jasper/commons-collections-2.1.1.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar” at.go_mobile.zuckerreports.JasperBatchMain custom/ZuckerReports2/temp/ebf2e629-feaf-502a-1f07-50b7d57cea3d/cmd.properties
      JasperBatchMain :: loading jasper design custom/ZuckerReports2/resources/Opportunities.jasper
      JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
      JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
      JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
      JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
      JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
      JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
      JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
      JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
      JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
      JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
      JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
      JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
      JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
      JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
      JasperBatchMain :: getParameterValue(SORT_FIELDS, java.util.List) => null
      JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
      JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null

      • Keith says:

        I’ve gotten further.
        First problem: i specified specified a local JDK path and when i tried to delete it, the save just refreshed it so putting a space in caused it to not run a thing.

        BUT, i copied and pasted the java command to the command line via sudo -u apache and found out i was missing a font, so
        I installed the fonts but still getting an error at run report
        Re-ran from command line and it works! Report generated, just can’t get it to run from the run report webpage.

  21. kwame says:

    Have added this module and using on demand serve but when i run the report it gives a error 7 message cannot connect to host

  22. rodnikosh says:

    i installed zuckerreports as mentioned in the intallation guide.
    i created a report in ireport and a JasperReport template with no errors.

    also the “Test Java” return success although i didn’t put anything in “Local JDK Path” (it must have been autodetected), i get:

    Exec Result: Success

    java version “1.6.0_22″
    OpenJDK Runtime Environment (IcedTea6 1.10.4) (rhel-1.41.1.10.4.el6-i386)
    OpenJDK Server VM (build 20.0-b11, mixed mode)

    now i want to run the report,
    when i get inside “on demand Reporting” and choose my report and push “Run Report”

    i get this error: (it is the same for every demopack report either):

    cmdline: java -Djava.awt.headless=true -classpath “custom/ZuckerReports2/resources/:custom/ZuckerReports2/resources/ClosedDeals.jasper_files/:modules/zr2_Report/jasper/antlr-2.7.6.jar:modules/zr2_Report/jasper/rex-20080421.jar:modules/zr2_Report/jasper/javacup.jar:modules/zr2_Report/jasper/javassist-3.4.GA.jar:modules/zr2_Report/jasper/poi-ooxml-schemas-3.7-20101029.jar:modules/zr2_Report/jasper/hibernate-commons-annotations.jar:modules/zr2_Report/jasper/asm.jar:modules/zr2_Report/jasper/js_saaj-api-1.3.jar:modules/zr2_Report/jasper/eigenbase-resgen-1.3.0.11873.jar:modules/zr2_Report/jasper/js_axis-1.4patched.jar:modules/zr2_Report/jasper/jaxen-1.1.1.jar:modules/zr2_Report/jasper/commons-beanutils-1.8.2.jar:modules/zr2_Report/jasper/batik-awt-util.jar:modules/zr2_Report/jasper/asm-attrs.jar:modules/zr2_Report/jasper/ant-1.7.1.jar:modules/zr2_Report/jasper/jackson-core-2.0.5.jar:modules/zr2_Report/jasper/batik-dom.jar:modules/zr2_Report/jasper/mongo-java-driver-2.7.3.jar:modules/zr2_Report/jasper/batik-ext.jar:modules/zr2_Report/jasper/jasperreports-chart-themes-4.7.0.jar:modules/zr2_Report/jasper/jasperreports-4.8.0.jar:modules/zr2_Report/jasper/olap4j-0.9.7.309-JS.jar:modules/zr2_Report/jasper/ejb3-persistence.jar:modules/zr2_Report/jasper/xbean.jar:modules/zr2_Report/jasper/velocity-1.7-dep.jar:modules/zr2_Report/jasper/bcel-5.2.jar:modules/zr2_Report/jasper/jackson-annotations-2.0.5.jar:modules/zr2_Report/jasper/jasperreports-exprfunctions-0.0.3.jar:modules/zr2_Report/jasper/swingx-2007_10_07.jar:modules/zr2_Report/jasper/batik-svggen.jar:modules/zr2_Report/jasper/poi-3.7-20101029.jar:modules/zr2_Report/jasper/slf4j-log4j12-1.5.8.jar:modules/zr2_Report/jasper/batik-svg-dom.jar:modules/zr2_Report/jasper/jfreechart-1.0.12.jar:modules/zr2_Report/jasper/zuckerreports-1.0.jar:modules/zr2_Report/jasper/iText-2.1.7.js1.jar:modules/zr2_Report/jasper/batik-gvt.jar:modules/zr2_Report/jasper/jasperreports-htmlcomponent-4.7.1.jar:modules/zr2_Report/jasper/png-encoder-1.5.jar:modules/zr2_Report/jasper/batik-xml.jar:modules/zr2_Report/jasper/hibernate3.jar:modules/zr2_Report/jasper/commons-vfs-1.0.jar:modules/zr2_Report/jasper/commons-logging-1.1.jar:modules/zr2_Report/jasper/batik-parser.jar:modules/zr2_Report/jasper/commons-digester-2.1.jar:modules/zr2_Report/jasper/barcode4j-2.1.jar:modules/zr2_Report/jasper/hive-service-0.8.1.jar:modules/zr2_Report/jasper/hive-common-0.8.1.jar:modules/zr2_Report/jasper/dom4j-1.6.jar:modules/zr2_Report/jasper/hsqldb-1.8.0-10.jar:modules/zr2_Report/jasper/castor-1.2.jar:modules/zr2_Report/jasper/hibernate-annotations.jar:modules/zr2_Report/jasper/js-mongodb-datasource-1.0.0.jar:modules/zr2_Report/jasper/jasperreports-fonts-4.5.0.jar:modules/zr2_Report/jasper/eigenbase-xom-1.3.0.11999.jar:modules/zr2_Report/jasper/ehcache-1.1.jar:modules/zr2_Report/jasper/eigenbase-properties-1.1.0.10924.jar:modules/zr2_Report/jasper/commons-javaflow-20060411.jar:modules/zr2_Report/jasper/js_mail-1.4.jar:modules/zr2_Report/jasper/jdt-compiler-3.1.1.jar:modules/zr2_Report/jasper/jpa.jar:modules/zr2_Report/jasper/js_activation-1.1.jar:modules/zr2_Report/jasper/cincom-jr-xmla.jar:modules/zr2_Report/jasper/js_commons-httpclient-3.1.jar:modules/zr2_Report/jasper/jasperreports-jtidy-r938.jar:modules/zr2_Report/jasper/iTextAsian.jar:modules/zr2_Report/jasper/sqleonardo-2009.03.rc1.jar:modules/zr2_Report/jasper/jcommon-1.0.15.jar:modules/zr2_Report/jasper/jta.jar:modules/zr2_Report/jasper/commons-math-1.0.jar:modules/zr2_Report/jasper/iText-2.1.7.jar:modules/zr2_Report/jasper/jasperreports-core-renderer.jar:modules/zr2_Report/jasper/jasperreports-extensions-3.5.3.jar:modules/zr2_Report/jasper/rex-0.8.1.jar:modules/zr2_Report/jasper/js_jasperserver-common-ws-4.7.1.jar:modules/zr2_Report/jasper/rhino-1.7R3.jar:modules/zr2_Report/jasper/hive-jdbc-0.8.1.jar:modules/zr2_Report/jasper/poi-ooxml-3.7-20101029.jar:modules/zr2_Report/jasper/js-hive-datasource-1.0.4.jar:modules/zr2_Report/jasper/cglib-2.1.jar:modules/zr2_Report/jasper/groovy-all-1.7.5.jar:modules/zr2_Report/jasper/jackson-databind-2.0.5.jar:modules/zr2_Report/jasper/barbecue-1.5-beta1.jar:modules/zr2_Report/jasper/xml-apis.jar:modules/zr2_Report/jasper/js_jaxrpc.jar:modules/zr2_Report/jasper/commons-dbcp-1.2.2.jar:modules/zr2_Report/jasper/js_commons-codec-1.3.jar:modules/zr2_Report/jasper/batik-bridge.jar:modules/zr2_Report/jasper/slf4j-api-1.5.8.jar:modules/zr2_Report/jasper/xml-apis-ext.jar:modules/zr2_Report/jasper/jasperreports-expressions-0.0.3.jar:modules/zr2_Report/jasper/joda-time-2.1.jar:modules/zr2_Report/jasper/hive-exec-0.8.1.jar:modules/zr2_Report/jasper/batik-css.jar:modules/zr2_Report/jasper/batik-util.jar:modules/zr2_Report/jasper/jxl-2.6.10.jar:modules/zr2_Report/jasper/bsh-2.1b5.jar:modules/zr2_Report/jasper/commons-collections-3.2.1.jar:modules/zr2_Report/jasper/saaj-api-1.3.jar:modules/zr2_Report/jasper/batik-script.jar:modules/zr2_Report/jasper/mondrian-3.2.0-13661-JS.jar:modules/zr2_Report/jasper/js_wsdl4j-1.5.1.jar:modules/zr2_Report/jasper/log4j-1.2.15.jar:modules/zr2_Report/jasper/js_commons-discovery-0.2.jar:modules/zr2_Report/jasper/batik-anim.jar:modules/zr2_Report/jasper/commons-pool-1.3.jar:modules/zr2_Report/jasper/spring.jar:modules/zr2_Report/jasper/jasperreports-json.jar:modules/zr2_Report/jasper/commons-pool-1.6.jar:modules/zr2_Report/jasper/hive-metastore-0.8.1.jar:modules/zr2_Report/jasper/hadoop-core-1.0.1.jar:modules/zr2_Report/jasper/libfb303-0.7.0.jar” at.go_mobile.zuckerreports.JasperBatchMain custom/ZuckerReports2/temp/e54b6091-02d2-f9d4-7f2a-50bf102615aa/cmd.properties 2>&1
    JasperBatchMain :: com.mysql.jdbc.Driver
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:186)
    at at.go_mobile.zuckerreports.JasperBatchMain.getConnection(JasperBatchMain.java:215)
    at at.go_mobile.zuckerreports.JasperBatchMain.main(JasperBatchMain.java:91)

  23. rodnikosh says:

    The versions are:

    SugarCRM CE 6.5.5
    ZuckerReport 2.0 with 2.3 and 4.0 and 4.0 corrected
    IReport 4.8.0

  24. helen says:

    I installed and used zuckerreport 2.0 in sugarcrm 6.5.5 with a much success. i create my reports in Ireport and run them in zuckerreports and everything works fine.

    But when trying to make zuckerreport execute a report with Hebrew language characters (UTF-8) , I get a blank report.

    For example, a report i created with this simple query doesn’t work on zuckerreport although it runs great in Ireport and mySQL database:

    SELECT
    COUNT(leads.`lead_source`) AS Count_of_sources,
    leads.`primary_address_city` AS leads_primary_address_city,
    leads.`lead_source` AS leads_lead_source
    FROM
    `leads` leads
    WHERE
    primary_address_city = “תל אביב” and Deleted=0
    GROUP BY
    leads_lead_source

    when running this report on zuckerreport i get a blank report in any situation where Hebrew Is in the query.

    Please do not ignore this email , I really need some kind of help on this,
    any tip will help,

    Thank you,

    • helen says:

      i can see this problem in the row in the report debug details. the hebrew is sent to as ?????????:

      JasperBatchMain :: loading jasper design custom/ZuckerReports2/resources/Hebrew report with text parameter.jasper
      JasperBatchMain :: getParameterValue(REPORT_CONTEXT, net.sf.jasperreports.engine.ReportContext) => null
      JasperBatchMain :: getParameterValue(REPORT_PARAMETERS_MAP, java.util.Map) => null
      JasperBatchMain :: getParameterValue(JASPER_REPORT, net.sf.jasperreports.engine.JasperReport) => null
      JasperBatchMain :: getParameterValue(REPORT_CONNECTION, java.sql.Connection) => null
      JasperBatchMain :: getParameterValue(REPORT_MAX_COUNT, java.lang.Integer) => null
      JasperBatchMain :: getParameterValue(REPORT_DATA_SOURCE, net.sf.jasperreports.engine.JRDataSource) => null
      JasperBatchMain :: getParameterValue(REPORT_SCRIPTLET, net.sf.jasperreports.engine.JRAbstractScriptlet) => null
      JasperBatchMain :: getParameterValue(REPORT_LOCALE, java.util.Locale) => null
      JasperBatchMain :: getParameterValue(REPORT_RESOURCE_BUNDLE, java.util.ResourceBundle) => null
      JasperBatchMain :: getParameterValue(REPORT_TIME_ZONE, java.util.TimeZone) => null
      JasperBatchMain :: getParameterValue(REPORT_FORMAT_FACTORY, net.sf.jasperreports.engine.util.FormatFactory) => null
      JasperBatchMain :: getParameterValue(REPORT_CLASS_LOADER, java.lang.ClassLoader) => null
      JasperBatchMain :: getParameterValue(REPORT_URL_HANDLER_FACTORY, java.net.URLStreamHandlerFactory) => null
      JasperBatchMain :: getParameterValue(REPORT_FILE_RESOLVER, net.sf.jasperreports.engine.util.FileResolver) => null
      JasperBatchMain :: getParameterValue(REPORT_TEMPLATES, java.util.Collection) => null
      JasperBatchMain :: getParameterValue(SORT_FIELDS, java.util.List) => null
      JasperBatchMain :: getParameterValue(FILTER, net.sf.jasperreports.engine.DatasetFilter) => null
      JasperBatchMain :: getParameterValue(REPORT_VIRTUALIZER, net.sf.jasperreports.engine.JRVirtualizer) => null
      JasperBatchMain :: getParameterValue(IS_IGNORE_PAGINATION, java.lang.Boolean) => null
      JasperBatchMain :: getParameterValue(CITY, java.lang.String) => ?????? ??????????
      2013-01-01 16:11:48,774 main INFO [beans.factory.xml.XmlBeanDefinitionReader] Loading XML bean definitions from URL [jar:file:/var/www/html/sugarcrmheb/modules/zr2_Report/jasper/jasperreports-chart-themes-4.7.0.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartThemesBeans.xml]

      ..

      How can i prevent the hebrew characters turn to ????

    • Sunil says:

      Hi Helen,
      Would you be able to guide me on the steps required to successfully install and use Zucker Reports 2.0 on Sugar CRM 6.5.??
      Thank you

  25. Hi to All,
    You can change the default port of MySQL to which the module tries to connect?
    In addition, the module works with MS SQL Server?

    Thank you,
    Antonio M.

  26. Hi,
    I solved the connection to the database by specifying the port on the MySQL configuration Sugar. Now running one of the reports included in the Report Pack, I get the following error:
    JasperBatchMain :: java.io.FileNotFoundException: custom/ZuckerReports2/resources/Opportunities.jasper

    Indeed, the file does not exist, why?

    Thx,
    Antonio Musarra.

  27. Hi,
    I checked for the support of MS SQL Server sifting through the source code, and it seems that the properties file is correctly written to connect to SQL. The only thing would be the JDBC driver to install.

    Thx,
    Antonio M.

  28. David says:

    Hello,

    During the installation of the ZuckerReports module I get the following SQL error:
    [4075][1][FATAL] Error creating table: zr2_reportcontainer_zr2_report_c Query Failed: CREATE TABLE zr2_reportcontainer_zr2_report_c (id varchar NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT ’0′ NULL ,zr2_reportcontainer_zr2_reportzr2_reportcontainer_ida varchar NULL ,zr2_reportcontainer_zr2_reportzr2_report_idb varchar NULL , PRIMARY KEY (id), KEY zr2_reportcontainer_zr2_report_ida1 (zr2_reportcontainer_zr2_reportzr2_reportcontainer_ida), KEY zr2_reportcontainer_zr2_report_alt (zr2_reportcontainer_zr2_reportzr2_report_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT ’0′ NULL ,zr2_repo’ at line 1

    The error occurs with version 2.04 and 2.1.1.

    Any help is appreciated.

  29. Ivan says:

    Hi.
    I upgraded my SugarCRM Community Edition version 6.2.0 with ZuckerReports version 1.15 to SugarCRM version 6.5.10. Now I want to update/upgrade also ZuckerReports to version 2.1.1 and I have few questions:

    1 – What are the differences between ZuckerReports version 1.15 and ZuckerReports version 2.1.1?
    2- There is ad upgrade procedure to “transform” my ZuckerReports 1.15 to ZuckerReports 2.1.1?

    Thanks in advance.
    Regards.
    Ivan

  30. eliasestradamx says:

    In version 2.1.1, is it still possible to assign reports to a team?

  31. Igor says:

    Hi Florian,

    it would be great to have short guidelines for setting up the Dashlet based on query template.

    Many thanks for great module,
    Igor

    • Igor says:

      I was digging into zr2 code and I found possible reasons why dashlets are not working out of the box.
      On some places, mainly in zr2_QueryTemplate you are using double zr2 strings i.e. zr2_zr2_Something.

      Try searching for all “zr2_zr2″ strings in complete package and you will probably see such lines.

      Thanks,
      Igor

  32. John Yesberg says:

    I have SugarCRM CE 6.5.5, and have just installed ZuckerReports 2.1.1, ZuckerReports2 Jasper 4.0.0, and ZuckerReports2 DemoPack.

    I have jdk 1.7u21 installed, and it tests ok on the Zucker administration page.

    I can see the ZuckerReports top level menu (On-Demand, Report Archive, JasperReports Templates, New JasperReports Template, Query Templates, New Query Template, Report and Query Parameters, etc).

    The JasperReports Templates show several templates: Opportunities by Industry, Activity, Pipeline By Sales, Opportunities, Meeting Printout, Closed Deals, Opportunity History Detail.

    I want to run one of these reports, but can’t see any “run” button on any of the sugarcrm pages. What am I missing?

  33. Alpha says:

    Hi,

    I have installed ZuckerReports_2.0_module.zip, and pass the local java checking.
    Then I installed ZuckerReports2_DemoPack.zip module, but I do not know how could I test functionality of ZuckerReports.I really need to confirm my previous installations.

    Thanks,
    Alpha

Leave a Reply

Dansette