Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Dataset limit 5000 rows in cache

0 votes
1 view

The problem is that my Qbe gets more than 5000 rows and I need that data to be used without cache.
I disable the cache in the cockpit report, but the row limit is my problem now when I run the report.
How can I increase the row limit?
PD: sorry for my English

knowage.log

[http-bio-8081-exec-11] 06 feb 2018 14:42:55,669 ERROR it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore:449 - An unexpected error occured while executing method
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Impossible to return data: the dataStore is [null], or it returns more than [5000] rows: it cannot be processed as near realtime dataset.
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.queryNearRealtimeDataset(DatasetManagementAPI.java:1349)
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:392)
    at it.eng.spagobi.api.common.DataSetResourceAbstractResource.getDataStore(DataSetResourceAbstractResource.java:209)
    at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:710)
    at sun.reflect.GeneratedMethodAccessor816.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing service
    at it.eng.spagobi.api.common.DataSetResourceAbstractResource.getDataStore(DataSetResourceAbstractResource.java:225)
    at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:710)
    ... 32 more
Caused by: java.lang.RuntimeException: An unexpected error occured while executing method
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:450)
    at it.eng.spagobi.api.common.DataSetResourceAbstractResource.getDataStore(DataSetResourceAbstractResource.java:209)
    ... 33 more
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Impossible to return data: the dataStore is [null], or it returns more than [5000] rows: it cannot be processed as near realtime dataset.
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.queryNearRealtimeDataset(DatasetManagementAPI.java:1349)
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:392)
    ... 34 more
Environment Knowage 6.1.1, CentOS, tomcat, Mozilla - Chrome
in Caching by (280 points)
edited by

1 Answer

+1 vote
 
Best answer
Hi,

    you can increase value of constant METAMODEL_LIMIT in class it.eng.spagobi.tools.dataset.DatasetManagementAPI.

Please note that you may affect performance and memory usage, due to current implementation of Apache MetaModel library.

Best regards,

Francesco
by (3.8k points)
selected by
Powered by Question2Answer
...