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

Model test was defined but not generated, please contact the system administrator

0 votes
1 view

My database is Sql server 2012 .

I made the connection to the database server via creating datasource

When Open business model in QBE

i got error : Model test was defined but not generated, please contact the system administrator .

How could i fix it ?

Thanks .

Environment Knowage version is 7.1, OS is window 10 , browser is window 10 .
in Business Model by (210 points)
edited by

1 Answer

0 votes

Hi,

You can try this:

  1. create business model and save
  2. edit the model and check Enable Meta Web
  3. click on META WEB
  4. add some business and physical model
  5. save and close
  6. back on Business Models' catalogue page :don't forget to click GENERATE
by (3.2k points)

when i click on META WEB , it got error : "Error while getting structure of data source by id"

How could i fix it ?

Many thanks .

by (210 points)
You should check your data source configuration. Make sure test button returns ok message.

IIRC, I had trouble using QBE with JNDI connection.

You can try using JDBC connection type instead.

Also logs should help ./Knowage-Server-CE/logs/knowage.log
by (3.2k points)
my data source configuration as below :
jdbc:sqlserver://localhost:1433;databaseName=BikeStores;

test button returns nothing .

i also have pasted log file below, kindly help me fix it .

[localhost-startStop-5] 03 Feb 2020 14:34:28,967 ERROR it.eng.spagobi.commons.initializers.caching.CachingInitializer.init:59 - Cannot initialize cache

java.lang.Exception: Cannot configure cache: Data source for writing is not defined. Please select one in the data sources definition panel.

at it.eng.spagobi.tools.dataset.cache.SpagoBICacheConfiguration.getCacheDataSource(SpagoBICacheConfiguration.java:71)

at it.eng.spagobi.tools.dataset.cache.SpagoBICacheConfiguration.getInstance(SpagoBICacheConfiguration.java:55)

at it.eng.spagobi.commons.initializers.caching.CachingInitializer.init(CachingInitializer.java:48)

at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)

at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)

at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1132)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1079)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:973)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4885)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5199)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125)

at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1859)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

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)

[http-nio-8080-exec-7] 03 Feb 2020 14:41:23,251 ERROR it.eng.spagobi.tools.dataset.service.SelfServiceDatasetAction.getParameters:149 - CacheException catched:

java.lang.Exception: Cannot configure cache: Data source for writing is not defined. Please select one in the data sources definition panel.

at it.eng.spagobi.tools.dataset.cache.SpagoBICacheConfiguration.getCacheDataSource(SpagoBICacheConfiguration.java:71)

at it.eng.spagobi.tools.dataset.cache.SpagoBICacheConfiguration.getInstance(SpagoBICacheConfiguration.java:55)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:532)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)

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

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

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

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

at java.lang.Thread.run(Thread.java:748)
by (210 points)

You have to define a cache data source first as stated here: https://knowage-suite.readthedocs.io/en/7.0/installation-guide/manual-installation.html#cache-database-connection

make sure to check use as cache

Hope this helps.

Also when you click TEST in data source config, you should have an ok message.

by (3.2k points)
I used the installer is knowage community edition, I don't see the TOMCAT_HOME folder, can you guide me to fix this CE version .
by (210 points)
https://knowage-suite.readthedocs.io/en/7.0/installation-guide/requirements.html#tomcat-8-5

TOMCAT_HOME usually is your knowage-server-ce base directory (containing folders as bin, conf, logs...)

If you don't want to edit JNDI cache database connection in conf/server.xml, I think you can just create database and create datasource in knowage using JDBC instead.

You'll have to restart knowage CE then.
by (3.2k points)
Powered by Question2Answer
...