durdisoft

If I create the same report from scratch, than it works. What is going wrong during export/import? Is this the right way to export the reports from JasperServer 4.1.0 and then import it on JasperServer 5.0.0? Which scenario is recommended for update from JasperServer 4.1.0 to 5.0.0? Thanks, Marijan

A web client retrieve reports from JasperReports Server 4.1.0 via the SOAP web service interface. The reports contains text and chart elements and this works fine. We retrieve jasperprint objects from jasperserver and handle the export to html, pdf and xls on client side. Now, I have installed JasperReports Server 5.0 and import some previous reports for testing. On the Web Client side I use the following jar's: axis-1.4patched.jar com-jaspersoft-ireport.jar com-jaspersoft-ireport-jasperserver.jar commons-discovery-0.2.jar groovy-all-2.0.1.jar iText-2.1.7.jar jasperreports-5.0.0.jar jasperserver-common-ws-5.0.0.jar jaxrpc.jar jcommon-1.0.17.jar jfreechart-1.0.12.jar log4j-1.2.15.jar org-openide-util.jar wsdl4j-1.5.2.jar xerces-2.8.0.jar The JasperReports Server 5.0 supported SOAP and REST web service to retrieve reports. If I retrieve an report that contains a chart I get the following error on client side (no error is present in the jasperserver.log): SCHWERWIEGEND: java.lang.Exception: 2 - "/reports/ArgusB/vergleich_eiweiss_harnstoff" ist kein gültiger Bericht. SCHWERWIEGEND: at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) SCHWERWIEGEND: at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) SCHWERWIEGEND: at ch.braunvieh.argus_core.report.JReportWSRenderer.encodeEnd(JReportWSRenderer.java:434) SCHWERWIEGEND: at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:861) SCHWERWIEGEND: at com.icesoft.faces.renderkit.dom_html_basic.DomBasicRenderer.encodeParentAndChildren(DomBasicRenderer.java:369) SCHWERWIEGEND: at com.icesoft.faces.renderkit.dom_html_basic.DomBasicRenderer.encodeParentAndChildren(DomBasicRenderer.java:364) SCHWERWIEGEND: at com.icesoft.faces.renderkit.dom_html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:95) SCHWERWIEGEND: at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:490) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) SCHWERWIEGEND: at com.icesoft.faces.facelets.D2DFaceletViewHandler.renderResponse(D2DFaceletViewHandler.java:281) SCHWERWIEGEND: at com.icesoft.faces.application.D2DViewHandler.renderView(D2DViewHandler.java:155) SCHWERWIEGEND: at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110) SCHWERWIEGEND: at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) SCHWERWIEGEND: at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:51) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.renderCycle(ReceiveSendUpdates.java:171) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.service(ReceiveSendUpdates.java:112) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.core.RequestVerifier.service(RequestVerifier.java:65) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.servlet.BasicAdaptingServlet.service(BasicAdaptingServlet.java:48) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.servlet.SessionVerifier.service(SessionVerifier.java:58) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:55) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:77) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:55) SCHWERWIEGEND: at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:192) SCHWERWIEGEND: at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) SCHWERWIEGEND: at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:67) SCHWERWIEGEND: at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431) SCHWERWIEGEND: at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:462) SCHWERWIEGEND: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139) SCHWERWIEGEND: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657) SCHWERWIEGEND: at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96) SCHWERWIEGEND: at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98) SCHWERWIEGEND: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651) SCHWERWIEGEND: at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030) SCHWERWIEGEND: at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657) SCHWERWIEGEND: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651) SCHWERWIEGEND: at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030) SCHWERWIEGEND: at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325) SCHWERWIEGEND: at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:242) SCHWERWIEGEND: at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180) SCHWERWIEGEND: at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:633) SCHWERWIEGEND: at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:570) SCHWERWIEGEND: at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:827) SCHWERWIEGEND: at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152) SCHWERWIEGEND: at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71) SCHWERWIEGEND: at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103) SCHWERWIEGEND: at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89) SCHWERWIEGEND: at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76) SCHWERWIEGEND: at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67) SCHWERWIEGEND: at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56) SCHWERWIEGEND: at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325) SCHWERWIEGEND: at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184) SCHWERWIEGEND: Fehler während Report Generierung: 2 - "/reports/ArgusB/vergleich_eiweiss_harnstoff" ist kein gültiger Bericht. java.lang.Exception: 2 - "/reports/ArgusB/vergleich_eiweiss_harnstoff" ist kein gültiger Bericht. at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at ch.braunvieh.argus_core.report.JReportWSRenderer.encodeEnd(JReportWSRenderer.java:434) at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:861) at com.icesoft.faces.renderkit.dom_html_basic.DomBasicRenderer.encodeParentAndChildren(DomBasicRenderer.java:369) at com.icesoft.faces.renderkit.dom_html_basic.DomBasicRenderer.encodeParentAndChildren(DomBasicRenderer.java:364) at com.icesoft.faces.renderkit.dom_html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:95) at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:490) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.application.D2DViewHandler.renderResponse(D2DViewHandler.java:495) at com.icesoft.faces.facelets.D2DFaceletViewHandler.renderResponse(D2DFaceletViewHandler.java:281) at com.icesoft.faces.application.D2DViewHandler.renderView(D2DViewHandler.java:155) at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139) at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:51) at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.renderCycle(ReceiveSendUpdates.java:171) at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.service(ReceiveSendUpdates.java:112) at com.icesoft.faces.webapp.http.core.RequestVerifier.service(RequestVerifier.java:65) at com.icesoft.faces.webapp.http.servlet.BasicAdaptingServlet.service(BasicAdaptingServlet.java:48) at com.icesoft.faces.webapp.http.servlet.SessionVerifier.service(SessionVerifier.java:58) at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:55) at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:77) at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:55) at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:192) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:67) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:431) at org.apache.catalina.core.StandardWrapperValve.preInvoke(StandardWrapperValve.java:462) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:139) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:186) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96) at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:142) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:719) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:657) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:651) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1030) at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:242) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:180) at com.sun.grizzly.http.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:633) at com.sun.grizzly.http.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:570) at com.sun.grizzly.http.DefaultProcessorTask.process(DefaultProcessorTask.java:827) at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:152) at com.sun.enterprise.v3.services.impl.GlassfishProtocolChain.executeProtocolFilter(GlassfishProtocolChain.java:71) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:103) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:89) at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76) at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:67) at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:56) at com.sun.grizzly.util.WorkerThreadImpl.processTask(WorkerThreadImpl.java:325) at com.sun.grizzly.util.WorkerThreadImpl.run(WorkerThreadImpl.java:184) AM FEINSTEN: JReportWSRenderer: 21.05.2013 11.00.20.508: Reportgenerierung ende... Can somebody help me to fix the problem or find more details about this issue. Thanks, Marijan

This would be a nice thing. I have also requirements to this issue. We have a jasper server with reports installed. An java ee web application runs reports on jasper server and get the result e.g. in pdf format. For that I use the rest - report web service (rest_v2/reports/). Until now ours reports use an sql statement to get the data for report filling. In the future I would like to assign a Datasource with the web service call. How do I do that? Is there an parameter for this?

This is an very useful feature and would save lots of time.

Hi all In JasperReports Server CP 4.1, there is no js-import prepend-path option. Is there any equivalent option available? In JasperServer 3.7 this option was a geat feature. Regards durdi

My script problem is resolved. I modified the first line of the scripts js-import.sh and js-import-export.sh from #!/bin/sh to #!/usr/bin/bash and it work's fine. Regards durdi

I assume that JasperServer uses a cache to store compiled reports at runtime. Is there a possibility to control adding and removing reports from cache? Maybe via properties or custom components? I would like control the removing reports process from cache, e.g. an complex report can't be removed from cache at runtime. Regards durdi

Logfiles are available under .../tomcat6/webapps/jasperserver/WEB-INF/logs/jasperserver.log and .../tomcat6/webapps/logs/catalina.ou, but I can't see any entry for this issue. Has anybody an idee with settings I can made in "Manage -> Log Settings"? Maybe I can define the right object/library to print messages during I test the jdbc connection. Regards durdi

Now I used bash explicitly, the command is: -bash-3.00$ bash -version GNU bash, version 3.00.16(1)-release (sparc-sun-solaris2.10) Copyright © 2004 Free Software Foundation, Inc. -bash-3.00$ bash js-import.sh --help Using CE setup ./bin/js-import-export.sh CONFIG_DIR=./conf_source/ieCE: is not an identifier -bash-3.00$ What that mean, "Using CE setup"? Regards durdi

I also tryed the 2 various syntax's for the connection string, but without success. Regards durdi

I there maybe an difference between JS 3.7 and JS 4.0? Because the same definition works on JS 3.7. I have put the jar into .../tomcat6/lib directory too, but it still doesn't work. Have you an idea how I can debug the issue? Regards durdi

Hello, I have installed JasperReports Server CP 4.0 on Solaris with separate MySQL and Tomcat Server. For an report I add an JDBC Data Source for Oracle DB, but the function "Test Connection" returns "Connection failed". Data Source definition: Driver: oracle.jdbc.pool.OracleDataSource URL: jdbc:oracle:thin:@[servername]:1521:[DB] The same definition works on JasperServer 3.7. The driver is located .../tomcat6/webapps/jasperserver/WEB-INF/lib/ojdbc.jar. I can't se any error message in .../tomcat6/webapps/jasperserver/WEB-INF/logs/jasperserver.log or .../tomcat6/webapps/logs/catalina.out Have anybody an idea how to debug or fix the problem? Regards durdi

Hello, In the meantime I installed a separate MySQL Server 5.1.56 and Apache Tomcat 6.0.32 on Solaris 10. Then install Jasperserver 4.0 from the WAR file distribution and after some troubleshooting it works. Only the import-export scripts doesn't work properly. For example: ../buildomatic$ sh js-import.sh --help js-import.sh: syntax error at line 6: 'BASEDIR=$' unexpected The script look's like: #!/bin/sh # # script to run import command # BASEDIR=$(dirname $0);export BASEDIR JS_EXP_CMD_CLASS=com.jaspersoft.jasperserver.export.ImportCommand export JS_EXP_CMD_CLASS JS_CMD_NAME=$0 export JS_EXP_CMD_CLASS $BASEDIR/bin/js-import-export.sh $* Has anybody an idea? Regards durdi

Hello, Exists an facility to add reports to JasperReports Server 4.0 from compiled files, e.g. *.jasper? Typically, we create reports with iReport and save it in a jrxml file. This file we then add to the JasperReports Server. When the report is running, JasperReports Server compile the report and fill it. In an comples report, the compile time can be an performace issue. Thanks for any advice. Regards durdi

Hello, Today I had an similar problem. I started the olap view "Foodmart Sample Analysis View". After this I get no responce from JasperReport Server. Restart Tomcat and MySQL has no effect. After an reboot of the OS JasperReport Server work proper. Regards durdi