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

persisting cockpit error

0 votes
1 view

Hi guys, I successfully create a document then suddenly knowage throws the below persisting error after a few hours!

Looks like knowage fails to create a table in my database?? please help!

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

I will appreciate any ideas. Its really starting to annoy!

This is the exception from the knowage logs file

[http-bio-8080-exec-7] 11 Apr 2018 10:05:32,139 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponseFromGenericException:73 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: generic.error
        at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:712)
        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: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)

Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing service
        at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.testDatabaseSchema(SQLDBCache.java:1542)
        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.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:398)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while executing statement: SELECT * FROM SbiTest17
        at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:126)
        at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.loadData(ConfigurableDataSet.java:153)
        at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:521)
        at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:505)
        at it.eng.spagobi.tools.dataset.cache.impl.sqldbcache.SQLDBCache.testDatabaseSchema(SQLDBCache.java:1540)
Caused by: java.sql.SQLSyntaxErrorException: (conn=9) Table 'test_table.SbiTest17' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:177)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
        at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:332)
        at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:502)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:123)
Caused by: java.sql.SQLException: Table 'test_table.SbiTest17' doesn't exist
Query is: SELECT * FROM SbiTest17
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:119)

Environment knowage 6.1.1, OS centos 7.2
in Data Set by (400 points)
edited by
Hey... I have an observation.  This error occurs when I create documents then shutdown knowage and put it on again.
by (400 points)

1 Answer

0 votes

I would suggest to check the datasource configuration, and verify that there is one datasource set as cache (aka write-default)

by (15.2k points)
Hi aportosa.. yes the datasource is set to 'write default' and I still get the error!
by (400 points)
Please restart tomcat also, if you haven't done this yet
by (15.2k points)
I installed knowage using the Linux installer and I understand I don't need to have pre-installed tomcat since it ships with knowage. Or how do I go about that?.. below is another log error that indicates the document path was not found!

[http-bio-8080-exec-5] 18 Apr 2018 11:47:23,993 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponseFromGenericException:73 - Catched service error:
javax.ws.rs.NotFoundException: RESTEASY003210: Could not find resource for full path: http://10.66.110.7:8080/knowage/restful-services/1.0/documents/Division/Rank%20Report
        at org.jboss.resteasy.core.registry.SegmentNode.match(SegmentNode.java:135)
        at org.jboss.resteasy.core.registry.RootNode.match(RootNode.java:43)
        at org.jboss.resteasy.core.registry.RootClassNode.match(RootClassNode.java:48)
        at org.jboss.resteasy.core.ResourceMethodRegistry.getResourceInvoker(ResourceMethodRegistry.java:445)
        at org.jboss.resteasy.core.SynchronousDispatcher.getInvoker(SynchronousDispatcher.java:260)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:197)
        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:313)
        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)
by (400 points)
edited by
Hey, just a quick one. I still get this same error over and over and have keep re-installing knowage if I have to create any report. Was thinking maybe if I used the knowage API to channel the documents to a different application? maybe that might be consistent?? just an idea..

how do I use the knowage API by the way. I will be embedding the reports to a php application.

thanks in advance.
by (400 points)
Powered by Question2Answer
...