Hi,
Everyday when i login to knowage it is not loading cockpit data ,it is throwing an error as "unable to load data from dataset please check dataset & widget config" .If i refresh it for 2 or 3 times then it is working fine i.e., it is loading data in cockpit.
I checked knowage.log file and i found the below error :
[http-bio-8070-exec-21] 29 Dec 2017 10:42:34,111 ERROR it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persist:1096 - Error while trasferring data from source to cache
[http-bio-8070-exec-21] 29 Dec 2017 10:42:34,188 ERROR it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore:455 - An unexpected error occured while executing method
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)
at it.eng.spagobi.api.DataSetResource.getDataStore(DataSetResource.java:755)
at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:910)
at sun.reflect.GeneratedMethodAccessor967.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
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:745)
Caused by: java.sql.SQLException: Already closed.
at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persist(SQLDBCache.java:1108)
... 37 more
[http-bio-8070-exec-21] 29 Dec 2017 10:42:34,191 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.GeneratedMethodAccessor967.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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)
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)
... 33 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)
... 34 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)
... 35 more
Caused by: java.sql.SQLException: Already closed.
at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.persist(SQLDBCache.java:1108)
... 37 more
Could you tell me what is the problem.
Thanks in Advance.
