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

Hello,

I just installed 6.1.1 Version of Knowage (SPAGOBI).  However, i am not able to run the application, below are the Configuration and log, kindly help me.

<Server.xml>

<Environment name="spagobi_resource_path" type="java.lang.String" value="$(catalina.base)/resources"/> <Environment name="spagobi-sso-class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService"/> 

<Environment name="spagobi-service-url" type="java.lang.String" value="http://192.168.103.63:8080/knowage"/> 

<Environment name="spagobi-host-url" type="java.lang.String" value="http://192.168.103.63:8080"/> 

<Resource name="jdbc/spagobi" auth="Container"  

          type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"  

          url="jdbc:mysql://192.168.103.63:3306/spagometadata"  

          username="root" password="root" maxActive="20" maxIdle="10"  

          maxWait="-1"/> 

Hibernate.cfg

  <hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password">root</property>
        <property name="hibernate.connection.url">jdbc:mysql://192.168.103.63:3306/knowage</property>
        <property name="hibernate.connection.username">root</property>
    </session-factory>
</hibernate-configuration>

hypernate.config.xml

<property name="hibernate.connection.datasource">java:/comp/env/jdbc/SpagoBI</property>

Quortz.properties

org.quartz.dataSource.quartz.jndiURL=java:comp/env/jdbc/knowage

org.quartz.dataSource.quartz.driver = com.mysql.jdbc.driver
org.quartz.dataSource.quartz.URL = jdbc:mysql://192.168.103.63:3306/spagometadata 
org.quartz.dataSource.quartz.user = root
org.quartz.dataSource.quartz.password = root
org.quartz.dataSource.quartz.maxConnections = 5

Erros log.

[localhost-startStop-2] 12 Feb 2018 13:33:07,611 ERROR org.quartz.utils.JNDIConnectionProvider.init:129 - Error looking up datasource: Name [SpagoBI] is not bound in this Context. Unable to find [SpagoBI].

javax.naming.NameNotFoundException: Name [SpagoBI] is not bound in this Context. Unable to find [SpagoBI].

at org.apache.naming.NamingContext.lookup(NamingContext.java:825)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:836)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:836)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:836)

at org.apache.naming.NamingContext.lookup(NamingContext.java:173)

at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)

at javax.naming.InitialContext.lookup(Unknown Source)

at org.quartz.utils.JNDIConnectionProvider.init(JNDIConnectionProvider.java:127)

at org.quartz.utils.JNDIConnectionProvider.<init>(JNDIConnectionProvider.java:105)

at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:930)

at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1371)

at org.quartz.impl.StdSchedulerFactory.getDefaultScheduler(StdSchedulerFactory.java:1387)

at it.eng.spagobi.tools.scheduler.listeners.SchedulerContextListener.contextDestroyed(SchedulerContextListener.java:42)

at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5156)

at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5829)

at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:221)

at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1716)

at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1705)

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)

------------------Quortz lo

localhost-startStop-2] 12 Feb 2018 13:33:07,611 ERROR org.quartz.utils.JNDIConnectionProvider.init:129 - Error looking up datasource: Name [SpagoBI] is not bound in this Context. Unable to find [SpagoBI].

javax.naming.NameNotFoundException: Name [SpagoBI] is not bound in this Context. Unable to find [SpagoBI].

at org.apache.naming.NamingContext.lookup(NamingContext.java:825)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:836)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:836)

at org.apache.naming.NamingContext.lookup(NamingContext.java:159)

at org.apache.naming.NamingContext.lookup(NamingContext.java:836)

at org.apache.naming.NamingContext.lookup(NamingContext.java:173)

at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)

at javax.naming.InitialContext.lookup(Unknown Source)

at org.quartz.utils.JNDIConnectionProvider.init(JNDIConnectionProvider.java:127)

at org.quartz.utils.JNDIConnectionProvider.<init>(JNDIConnectionProvider.java:105)

at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:930)

at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1371)

at org.quartz.impl.StdSchedulerFactory.getDefaultScheduler(StdSchedulerFactory.java:1387)

at it.eng.spagobi.tools.scheduler.listeners.SchedulerContextListener.contextDestroyed(SchedulerContextListener.java:42)

at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5156)

at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5829)

at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:221)

at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1716)

at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1705)

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)

Please help me.

Environment Windows 7 64 Bit
in Standard by (200 points)

1 Answer

0 votes

It seems that you are using a wrong server configuration. I see many references to SpagoBI. Last but not least, the error is pretty clear.

If you really want to configure Knowage by yourself, you could use the following server.xml as starting point: https://raw.githubusercontent.com/KnowageLabs/Knowage-Server-Docker/master/server.xml

Otherwise, please consider another deployment option:

by (15.2k points)
...