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

Can't start Knowage - Error 500

0 votes
1 view

Hi,

I have searched the forum and checked the answers similar to my problem, unsuccesfully.

I can't start Knowage after the installation, I get the HTTP Status 500.

I have installed Knowage version 7.1.5 on macOS, with JDK 1.8 and MYSQL 5.7.30. Tomcat is running and JAVA_HOME is set to "/Library/Java/JavaVirtualMachines/jdk1.8.0_251.jdk/Contents/Home". PATH is set to $JAVA_HOME:$PATH.

This is what I get when I run the Start Command, it seems correct:

I don't know what else to check, can someone help me, please?

Thank you.

Kind regards.

Environment version 7.1.5, macOS 10.15.5, on Safari and Chrome
in General Configuration by (120 points)

Hi selkia,

Is your MySQL Server up and running? Do you have errors in log files?

Best regards,

Andrijana

by (500 points)

Hello, Andrijana, 

I don't know what logs to check but everything seems fine. 

MySQL is running, as well as Tomcat:

Do you know what else could/should I check?

Thank  you,

Kind regards

by (120 points)

Hi selkia,

Inside your tomcat installation folder there is a folder named logs. There you can find knowage.log file and check if there are any errors.

Best regards,

Andrijana

by (500 points)
Hi Adrijana,

I have checked the log and indeed there are errors. I have assumed they are caused by MySQL so I logged into MySQL and did a query. It asked me to change the root password, so I did. I re-started mySQL and Knowage and still the same error and result. Here is part of the log. I have no experience in configuring these tools or working with mySQL so I really hope you can help me.

[localhost-startStop-2] 18 jul 2020 22:19:53,106 ERROR it.eng.spagobi.commons.utilities.HibernateSessionManager.determineDialect:139 - Error determining Hibernate's dialect
javax.naming.NamingException: Excepción inesperada resolviendo referencia [Root exception is java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)]
    at org.apache.naming.NamingContext.lookup(NamingContext.java:856)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:159)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:827)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:173)
    at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:152)
    at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:839)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:159)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:827)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:159)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:827)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:159)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:827)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:173)
    at org.apache.naming.SelectorContext.lookup(SelectorContext.java:163)
    at javax.naming.InitialContext.lookup(InitialContext.java:417)
    at it.eng.spagobi.commons.utilities.HibernateSessionManager.determineDialect(HibernateSessionManager.java:119)
    at it.eng.spagobi.commons.utilities.HibernateSessionManager.initSessionFactory(HibernateSessionManager.java:97)
    at it.eng.spagobi.commons.utilities.HibernateSessionManager.getSessionFactory(HibernateSessionManager.java:153)
    at it.eng.spagobi.commons.utilities.HibernateSessionManager.getCurrentSession(HibernateSessionManager.java:164)
    at it.eng.spagobi.commons.dao.AbstractHibernateDAO.getSession(AbstractHibernateDAO.java:132)
    at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:62)
    at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at java.lang.Class.newInstance(Class.java:442)
    at it.eng.spagobi.commons.SingletonConfig.<init>(SingletonConfig.java:53)
    at it.eng.spagobi.commons.SingletonConfig.getInstance(SingletonConfig.java:43)
    at it.eng.spago.dbaccess.Configurator.<init>(Configurator.java:104)
    at it.eng.spago.dbaccess.Configurator.getInstance(Configurator.java:117)
    at it.eng.spago.dbaccess.DataConnectionManager.<init>(DataConnectionManager.java:74)
    at it.eng.spago.dbaccess.DataConnectionManager.getInstance(DataConnectionManager.java:192)
    at it.eng.spago.dbaccess.DataAccessInitializer.init(DataAccessInitializer.java:42)
    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)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    [......]
    ... 52 more
[localhost-startStop-2] 18 jul 2020 22:19:54,374 ERROR it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters:77 - HibernateException during query
org.hibernate.HibernateException: Could not find datasource
    at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:79)
    [.......]
    at java.lang.Thread.run(Thread.java:748)
Caused by: javax.naming.NamingException: Excepción inesperada resolviendo referencia [Root exception is java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)]
    at org.apache.naming.NamingContext.lookup(NamingContext.java:856)
    [........]
    at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:75)
    ... 43 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    [.........]
    ... 59 more
[localhost-startStop-2] 18 jul 2020 22:19:54,380 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:57 - Impossible to load configuration for report engine
it.eng.spago.error.EMFUserError: severity [ERROR] description [100]
    at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:82)
    [.......]

Thanks a lot.

Kind regards,

Elena.
by (120 points)
Hi,

anyone got an idea that can help me? I am stucked at this point.

thanks!
by (120 points)
Problem fixed by un-installing Knowage and installing it again but using the Console mode instead.

Regards
by (120 points)

Please log in or register to answer this question.

Powered by Question2Answer
...