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

I'm trying to start the knowage server from its repository and after all the configuration required to change the dialect (to postgreql) I have the following error when I start apache tomcat. The database is empty and I cant get in into the system because there is no users registered in the database.

The first error is : Cannot configure cache: Data source for writing is not defined. Please select one in the data sources definition panel.

An the second one: An unexpected error occurred while initializieng default  users

Is there any way to force the default registration? I cant find the scripts that makes the registration of the default users.

__________________________________________________________________________________________________________________________

[localhost-startStop-1] 02 dic 2019 09:43:14,381 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:1228)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1066)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5449)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5747)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1018)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:994)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1296)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2038)
    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)
[localhost-startStop-1] 02 dic 2019 09:43:14,485 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initUsers:230 - An unexpected error occurred while initializieng default users
it.eng.spagobi.commons.dao.SpagoBIDAOException: Error while loading user by idbiadmin
    at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.loadSbiUserByUserId(SbiUserDAOHibImpl.java:312)
    at it.eng.spagobi.security.init.InternalSecurityInitializer.initUsers(InternalSecurityInitializer.java:208)
    at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:83)
    at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
    at it.eng.spagobi.security.init.SecurityInitializer.init(SecurityInitializer.java:62)
    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:1228)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1066)
    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5449)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5747)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1018)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:994)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1296)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2038)
    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)

__________________________________________________________________________________________________________________________

Environment knoeage-server-6-4, debian stetch, apache-tomcat-7, postgresql, openjdk-8
in Installer by (930 points)

Please log in or register to answer this question.

...