0 votes
1 view
ERROR it.eng.spagobi.commons.initializers.caching.CachingInitializer.init:59 - Cannot initialize cache
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An error occurred while creating connection
        at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:103)
        at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.loadData(ConfigurableDataSet.java:149)
        at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:573)
        at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:552)
        at it.eng.spagobi.tools.datasource.bo.DataSource.executeStatement(DataSource.java:541)
        at it.eng.spagobi.tools.dataset.persist.PersistedTableManager.dropTablesWithPrefix(PersistedTableManager.java:1116)
        at it.eng.spagobi.commons.initializers.caching.CachingInitializer.init(CachingInitializer.java:56)
        at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
        at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
        at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
        at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:170)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:123)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1120)
        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.access$000(ContainerBase.java:129)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:150)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:140)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:717)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        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: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Cannot get connection to datasource
        at it.eng.spagobi.tools.datasource.bo.DataSource.getConnectionByUserProfile(DataSource.java:203)
        at it.eng.spagobi.tools.datasource.bo.DataSource.getConnection(DataSource.java:190)
        at it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load(JDBCDataProxy.java:101)
        ... 38 more
Caused by: java.sql.SQLException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
        at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2156)
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2050)
        at org.apache.commons.dbcp2.BasicDataSource$PaGetConnection.run(BasicDataSource.java:2442)
        at org.apache.commons.dbcp2.BasicDataSource$PaGetConnection.run(BasicDataSource.java:2438)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1524)
        at it.eng.spagobi.tools.datasource.DataSourceManager.getConnection(DataSourceManager.java:46)
        at it.eng.spagobi.tools.datasource.bo.DataSource.getDirectConnection(DataSource.java:280)
        at it.eng.spagobi.tools.datasource.bo.DataSource.getConnectionByUserProfile(DataSource.java:200)
        ... 40 more
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1360)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1182)
        at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2147)
        ... 48 more
[localhost-startStop-5] 16 Nov 2021 17:03:01,743 ERROR it.eng.spagobi.security.PasswordEncrypterHolder.getKeyBytes:78 - Unable to find file for security initialization. Please, read the documentation https://knowage-suite.readthedocs.io/en/7.4/installation-guide/manual-installation.html?highlight=server.xml#environment-variables-definition
[localhost-startStop-5] 16 Nov 2021 17:03:01,743 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.readUsers:300 - An unexpected error occurred while reading defualt users
java.lang.Error: Unable to find file for security initialization.
Environment Centos7
asked Nov 16, 2021 in Upgrade by m1993 (120 points) | 1 view

1 Answer

0 votes

Hello,
from the logs (Caused by: java.sql.SQLException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver') it looks like you are missing the Oracle JDBC driver.
You have to put it inside TOMCAT_HOME/lib folder.

Hope this helps,
Marco

answered Nov 17, 2021 by mbalestri (9,250 points)
1,553 questions
1,017 answers
2,037 comments
2,567 users