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

Hi,

Whenever I am trying to access the workspace, I am receiving an error "An unexpected error occured while initializing cache" as a popup with blank screen in the background.

If someone can help me to solve this issue, it would be a great help.

Thanks.

LOGS:

[http-bio-8080-exec-10] 07 Nov 2018 16:25:27,390 ERROR it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.testDatabaseSchema:1511 - Error persisting dataset

it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error persisting the dataset into table

at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.persistDataset(PersistedTableManager.java:248)

at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.testDatabaseSchema(SQLDBCache.java:1509)

at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.<init>(SQLDBCache.java:124)

at it.eng.spagobi.tools.dataset.cache.CacheFactory.getCache(CacheFactory.java:32)

at it.eng.spagobi.tools.dataset.cache.SpagoBICacheManager.initializeCache(SpagoBICacheManager.java:62)

at it.eng.spagobi.tools.dataset.cache.SpagoBICacheManager.getCache(SpagoBICacheManager.java:44)

at it.eng.spagobi.tools.dataset.service.SelfServiceDatasetAction.buildQbeEditFromFederationServiceUrl(SelfServiceDatasetAction.java:328)

at it.eng.spagobi.tools.dataset.service.SelfServiceDatasetAction.getParameters(SelfServiceDatasetAction.java:109)

at org.apache.jsp.WEB_002dINF.jsp.tools.workspace.workspaceManagement_jsp._jspService(workspaceManagement_jsp.java:392)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:743)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:485)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)

at it.eng.spago.dispatching.httpchannel.Router.route(Router.java:144)

at it.eng.spago.presentation.rendering.AbstractServletModelRenderer.render(AbstractServletModelRenderer.java:91)

at it.eng.spago.dispatching.httpchannel.AdapterHTTP.render(AdapterHTTP.java:574)

at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:470)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:436)

at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:177)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at it.eng.spagobi.utilities.filters.AntiInjectionFilter.doFilter(AntiInjectionFilter.java:45)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:148)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

[http-bio-8080-exec-10] 07 Nov 2018 16:25:29,405 ERROR it.eng.spagobi.tools.dataset.service.SelfServiceDatasetStartAction.getParameters:153 - it.eng.spagobi.tools.dataset.cache.CacheException: An unexpected error occured while initializing cache

Environment Knowage 6.0, Windows server
in Workspace by (490 points)
edited by
Did you set one datasource with the option "use as cache" ? What kind of DBMS is it?

1 Answer

0 votes
I am currently receiving the same  error, have you had any luck in getting this error resolved?

Thanks,

Chris
by (340 points)
Hi Chris,

Yes, there was a database connection problem.

You need to check that whether your database is connected and running or not. In my case, I changed my PATH variable, due to which HSQL database was not starting at the time of startup. However, when I updated that variable, everything was running fine.

Hope this helps.

Thanks,

Pritesh
Hi Pritesh,

Where is the PATH variable that you are referring to?

Thanks,

Chris
In System Variables

In Windows: My Computer - Property - Advanced system settings - Environment Variables - System Variable - you will find PATH variable here.
Thanks for your help Pritesh!
...