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

Login page is blank

0 votes
1 view
Hello,

We are using Windows Server 2012 R2. After installing Knowage and opening https://localhost:8080/knowage the page is completely blank - no text, no options for login.

Please help me fix this issue.
Environment Knowage - 6.1.1 // Windows Server 2012 R2 // IE 11, Chrome, Edge
in Standard by (220 points)
reopened by
Dear, can you give us more informations ?

- Are you using jdk 1.8 ?

- check knowage.log file in order to verify some errors

Let me know

Angelo
by (20.7k points)
Good morning and sorry for my late reply.

Yes, I am using jdk 1.8.0_151. This is the output in the log file:

[localhost-startStop-5] 18 Dec 2017 10:09:09,431 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

[localhost-startStop-5] 18 Dec 2017 10:09:09,431 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

[localhost-startStop-5] 18 Dec 2017 10:09:09,431 ERROR it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters:79 - HibernateException during query

org.hibernate.exception.GenericJDBCException: Cannot open connection

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)

at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)

at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)

at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:63)

at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

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

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

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

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

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

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

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

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

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

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

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

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

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

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

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

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

... 36 more

Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1702)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1547)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)

... 40 more

[localhost-startStop-5] 18 Dec 2017 10:09:09,446 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:48 - 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:84)

at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

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

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

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

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

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

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

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

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

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

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

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

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

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

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

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

Can you please help me with some solution because I am not familiar with this type of software.
by (220 points)

1 Answer

0 votes
Dear

The MySQL driver JDBC is missing... You should found it inside <tomcat_home>/lib.

"Cannot load JDBC driver class 'com.mysql.jdbc.Driver'"

Best Regards

Angelo
by (20.7k points)
Because I am not sure which is the tomcat home directory, I downloaded MySQL JDBC Driver from oracle.com and put it in ...\Knowage\Knowage-Server-CE\lib

The filename is mysql-connector-java-5.1.45-bin and is executable JAR file.

Now the error in the log is:

[localhost-startStop-5] 18 Dec 2017 15:01:31,337 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mariadb://localhost:3303/knowage_ce'
[localhost-startStop-5] 18 Dec 2017 15:01:31,337 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mariadb://localhost:3303/knowage_ce'
[localhost-startStop-5] 18 Dec 2017 15:01:31,353 ERROR it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters:79 - HibernateException during query
org.hibernate.exception.GenericJDBCException: Cannot open connection

I am not sure that this is the right file and is in the right folder. Can you point me to the right settings?
by (220 points)
After several reinstalls the problem is solved.
by (220 points)
Dear

I don't understand why the error is about MySql... because If you've installed knowage using installer you are using MariaDB and not MySql.

can you send me <tomcat_home>/conf/server. xml ?

Best regards

A.
by (20.7k points)
Powered by Question2Answer
...