exception getting dataset from cache

[cyma]

any one know what is this mean?   "exception getting dataset from cache"

first, i created  a data sources. then, i use this data source to create a domain. 

then, during i lunching the domain desinger, my web browser stopped for a long while, then, shows "exception getting dataset from cache"...

 

any idea?

[swood]

Sounds like your session timed out. If you log in again, what happens?

 

Sherman

Jaspersoft

[klennon]

I received this error while adding fields to a report.  I added a field when I went to add another field i am getting the box with the spinning dial and "Retrieving ..." displayed.   Attached both screenshots  - adding the Assignment Type took literally no time.

[zozor]

Hi,

I have exactly the same problem.

Have you resolved-it ?

Thanks

[sebif]

 I ran into exactly this issue today. Could this be related to the size of data in the table? I think it worked fine with less data.

Anyone has a solution?

[Guest]

I had the same problem.

In my case it helped to remove the "ORDER BY"-part in the sql-statement of the domain.

[joftingson]

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

[mdahlman]

Joefer,

Hello!

Could you take a look at WEB-INF/logs/jasperserver.log and let us know if there's anything in there that might give a clue about what's going wrong?

Regards,
Matt

[nandu_bc]

Even we're getting same exception with the following query.

 

SELECT

col1, col2, count(col3)

FROM

table1, table2

WHERE

(condition...)

GROUP BY

col1, col2

ORDER BY

1, 2

 

We tried this without order by clause also.

 

Request your help on this issue.

 

Thanks

[mdahlman]

nandu_bc,

I think you'll need to start a new thread with more details. I don't understand what you have tried so far.

Regards,
Matt

[waalp]

Hello,

 

Does anyone have a sollution already. I got a query based on a postgresql function wich was working fine all day long. But now It had the error: 

AdhocAjaxController,http-8080-2:651 - ad hoc controller exception
java.lang.RuntimeException: exception getting dataset from cache
 

I already tried to restart the server, logging out and in again... but nothing seems to work. The report worked fine for most of the day tough.

I attached the error log for the query i'm trying to run.

 

Any ideas ?

Regards,

Peter

Post Edited by waalp at 08/10/2011 16:20

[alea2]

 Hello, 

I am also experiencing this issue while using Ad Hoc Reports. This seems to be an issue with large datasets as I can run the report for 1 or 2 weeks but as soon as I set the input control to 1 month I get the below errors:

Your help with this issue would be appreciated as the tool is more or less useless at this time. 

 

java.lang.IllegalArgumentException: error getting datarator

at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:1883)

at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.execute(AdhocEngineServiceImpl.java:1815)

at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:113)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:422)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231)

at org.quartz.core.JobRunShell.run(JobRunShell.java:195)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

Caused by: java.lang.RuntimeException: exception getting dataset from cache

at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:154)

at com.jaspersoft.ji.adhoc.strategy.NewClassicDataStrategy.getWorkingDataSet(NewClassicDataStrategy.java:113)

at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:897)

at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1036)

at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(AdhocEngineServiceImpl.java:405)

at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:1881)

... 6 more

Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache

at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getFromCache(CommonDomainDataStrategy.java:982)

at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getFromCache(CommonDomainDataStrategy.java:962)

at com.jaspersoft.ji.adhoc.strategy.NewClassicDataStrategy$1.getFromCache(NewClassicDataStrategy.java:107)

at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:72)

... 11 more

Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data

at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:150)

at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getFromCache(CommonDomainDataStrategy.java:979)

... 14 more

Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next()

at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:282)

at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:117)

... 15 more

Caused by: com.jaspersoft.commons.util.QueryExecutionTimeoutException: jsexception.QueryExecutionTimeoutException

at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:139)

at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.getJRDataSource(JRQueryDataSet.java:178)

at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.access$100(JRQueryDataSet.java:49)

at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:280)

... 16 more

 

[alcor]

Same error for me.

Jasperserver 4.1 connected to Oracle DataSource.

It is a random error. Some times in ad Hoc report when i try to drop a column i recive:

exception getting dataset from cache.

In catalina.out i find at the end of the stach the error:

java.sql.SQLException: ORA-00904: "EUMOFA_DWH_FMODWH_DIM_PRODUCT"."DESC_COUNTRY": invalid identifier

The identifier is invalid because the table name used to access data is not the correct one.

Is should be used EUMOFA_DWH.FMODWH_DIM_PRODUCT"."DESC_COUNTRY".

I think that there is a problem with table alias generation.

Other times all works fine because he query the DB with correct alias.

Any solution/workaround ?

 

 

 

 

[joftingson]

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