joftingson

Hi, I would like to know what this error means "Only a type can be imported. com.jaspsoft.ji.adhoc.service.AdhocEngineServiceImpl resolves to a package" This happened when we tried to open an Adhoc report in iReport. Thanks, Joefer

Hi Matt, I encountered the same issue again. Currently I am using Jasper Report Server version 4.7. The message "Exception getting dataset from cache" is being thrown every time I drag a field into the ad-hoc report designer. Below are the log messages: 2012-07-11 10:11:46,509 INFO command,Thread-1:75 - Starting the upgrade process for AdhocReportUnit objects. This process may be very time-consuming, depending on the number of Ad Hoc reports in your repository. 2012-07-11 10:11:46,538 INFO command,Thread-1:75 - Number of AdhocReportUnits found: 0 2012-07-11 10:11:46,539 INFO command,Thread-1:75 - Upgrade process for AdhocReportUnit objects completed successfully. 2012-07-11 10:15:18,986 ERROR AdhocAjaxController,http-9020- 7:842 - ad hoc controller exception java.lang.RuntimeException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:178) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1023) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:995) at com.jaspersoft.ji.adhoc.strategy.BaseWrappingDataStrategy.getWorkingDataSet(BaseWrappingDataStrategy.java:113) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:292) at com.jaspersoft.ji.adhoc.InteractiveOLAPCrosstabEngine.initWorkingDataSet(InteractiveOLAPCrosstabEngine.java:1373) at com.jaspersoft.ji.adhoc.InteractiveOLAPCrosstabEngine.initDimensionDataSet(InteractiveOLAPCrosstabEngine.java:1360) at com.jaspersoft.ji.adhoc.InteractiveOLAPCrosstabEngine.generateViewModel(InteractiveOLAPCrosstabEngine.java:315) at com.jaspersoft.ji.adhoc.InteractiveOLAPCrosstabEngine.getInteractiveReport(InteractiveOLAPCrosstabEngine.java:142) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.generateReport(AdhocAjaxController.java:1841) at com.jaspersoft.ji.adhoc.action.AdhocCrosstabAjaxController.insertDimensionInAxisWithChild(AdhocCrosstabAjaxController.java:857) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.handleRequest(AdhocAjaxController.java:213) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:108) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:66) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:185) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:185) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:141) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:94) ... 96 more Caused by: com.jaspersoft.jasperserver.api.JSException: ADH_1009_SQL_GENERATE_ERROR at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy$CacheListener.stateChanged(CommonDomainDataStrategy.java:1069) at com.jaspersoft.commons.datarator.CachedData.setState(CachedData.java:181) at com.jaspersoft.commons.datarator.CachedData.setThrowable(CachedData.java:193) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:163) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:138) ... 97 more Thanks, Joefer

Hi, I would like to ask for your help on how to create a report that will use Charts Pro and have a multi series combination. I am having a hard time on how to do this. I have attached a screen shot. Thanks, Joefer

Hi, I created a report in iReport 4.2.1. Then I unchecked the following Document Permission in the Export Options for PDF: 1. Allow Printing 2. Allow Modify Contents 3. Allow Copy When I exported the report to PDF, the print and copy options are still enabled. I would like to seek some help on how to make this work. This is also happening when I deployed the report in Jasper Report Server. Thanks, Joefer

Hi, I have two Flash Chart Report The first one is a bar graph that displays the total sales for each country and the second one is a bar graph that shows the sales by cities. What I wanted to achieve is to make each bars on the first bar graph as a hyperlink so that it will show the second report and display the total sales of each cities for a specific city. How can I do this in iReport? Thanks, Joefer

I am having the same error when I tried to drag a field in the ad-hoc editor. It says "exception getting dataset from cache". I am using TEIID as may datasource. I was able to create the domain successfully and I also tried creating a report in iReport and used TEIID as the datasource then I deployed the report in JasperServer. The reason why I used TEIID is because the data for report will come from two different database. One of the requirement is to use a Virtual Database instead of using a staging table that will combine the data from Oracle 10g and SFDC. Do you have any suggestion on how to solve this problem? Thanks, Joefer

Hi, We are having problems with our JasperETL Jobs since we enabled the SSL in our MySQL database. Since our MySQL database is SSL enabled, we did the following. 1. Copied the certificate and key on our local machine 2. Added the following JDBC properties on our tMysqlConnection component: a. useSSL = true b. requireSSL = true c. verifyServerCertificate = true d. clientCertificateKeyStoreUrl = I would like to ask if anyone of you has done this before? Thank you, Joefer

Hi, We are having problems with our JasperETL Jobs since we enabled the SSL in our MySQL database. Since our MySQL database is SSL enabled, we did the following. 1. Copied the certificate and key on our local machine 2. Added the following JDBC properties on our tMysqlConnection component: a. useSSL = true b. requireSSL = true c. verifyServerCertificate = true d. clientCertificateKeyStoreUrl = file:///c:/tmp/certs/mycert.cert I would like to ask if anyone of you has done this before? Thank you, Joefer

Hi, Is it possible in JasperServer 3.7.1 Pro to generate a report where datasource is from salesforce.com? Thanks, Joefer

Hi, I am having a problem using the Audit Domain in creating an adhoc report. I am always getting "NullPointerException". I already enabled the auding by changing the following property in the applicationContext-audit.xml. <entry key="com.jaspersoft.jasperserver.api.logging.audit.domain.AuditEvent" value="true"/>.After setting the value from "false" to "true", I restarted JasperServer. I deployed JasperServer on a machine that uses Tomcat and on a machine that is using Glassfish. In Tomcat the audit feature is working but on Glassfish it's not working. I would like to know if there are some properties that I need to configure on Glassfish before I can use the Audit Domain? Thanks,  Post Edited by joftingson at 10/07/2010 03:40

Thanks for the solution. Its working. In addition, is there a way to hide the username and the password?

Hi, I would like to know if the solution you posted will work with JasperServer 3.7? Thanks, Joefer

Hi Marcel, Yes, I've used this patch and it works with XML. Joefer

Hi Sherman, Can I also use the patch for the Professional edition of JasperServer? Thanks, Joefer

Hello everyone, I am new to using JasperReports and JasperServer. I have created a report using XML as the datasource and it's working. Now my problem is that when I go to JasperServer to load the report, I am having a problem on creating an XML Datasource. I would like to ask for your help on how to go about it. Thanks, Joefer