Error: Unable to load data from dataset. Please check dataset & widget config

Question

We have generated several reports and its not getting load in the cockpit, but we are getting the actual preview content while creating the Dataset. Could you please help us on this

Note: Modified the DB to PostgreSQL

Error Log as follows,

[http-bio-8070-exec-6] 21 Nov 2017 11:34:30,545 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponseFromGenericException:97 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: generic.error
    at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:912)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    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:167)
    at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
    at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    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:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    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.DataSetResource.getDataStore(DataSetResource.java:771)
    at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:910)
    ... 34 more
Caused by: java.lang.RuntimeException: An unexpected error occured while executing method
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:456)
    at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:755)
    ... 35 more
Caused by: it.eng.spagobi.tools.dataset.cache.CacheException: An unexpected error occured while persisting store in cache
    at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persist(SQLDBCache.java:1115)
    at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.put(SQLDBCache.java:1028)
    at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:425)
    ... 36 more
Caused by: org.postgresql.util.PSQLException: ERROR: length for type varchar cannot exceed 10485760
  Position: 121
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
    at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.executeStatement(PersistedTableManager.java:595)
    at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.createTable(PersistedTableManager.java:814)
    at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persist(SQLDBCache.java:1073)
    ... 38 more

Comments

Team,

We fixed this issue but reports are loading only in http . We are getting blank pages when we try to load in https . Do we need to change any configuration in order to load the reports in https://192.*.*.*:8443/knowage. Please advise.

---

Are you change the server.conf file with the new url?, like this:

---

Same error. I tried uploading few simple CSV file dataset and created cockpit and few bar graphs the cockpit is not opening and throwing generic error.

Tried to install higher version (6.1.1) none of the war files are getting deployed successfully. Tried using the installer for windows 6.1.1 CE after installing getting HTTP 404 error

Answer 1

A bug has been already found on Knowage 6.1.x regarding caching mechanism with Postgresql.

Please stay in touch to get the latest version which will contains a fix for this.

Comments

Which version fixed this bug ?

version6.1.1 a  error occured on linux ,but it's ok on win7.

"Unable to load data from dataset xxx Please check dataset & widget config" 

I used 6.2.0-RC, but create dataset failed by this：

“Error这个 org.postgresql.jdbc4.Jdbc4Connection.isValid(int) 方法尚未被实作。”

An unexpected error occured while executing dataset: 这个 org.postgresql.jdbc4.Jdbc4Connection.isValid(int) 方法尚未被实作。
Query statement: [SELECT p.project_set_code as pset, count(*) as count from dw_or_data.project_info_tmp p GROUP BY p.project_set_code;]
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.getDatasetTestResultList(ManageDataSetsForREST.java:1563)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.getDataSetResultsAsJSON(ManageDataSetsForREST.java:1514)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.datatsetTest(ManageDataSetsForREST.java:1479)
        at it.eng.spagobi.tools.dataset.service.ManageDataSetsForREST.previewDataset(ManageDataSetsForREST.java:128)
        at it.eng.spagobi.api.DataSetResource.previewDataSet(DataSetResource.java:817)