Once i login with any of the users, http://localhost:8080/knowage-vue/ just keep loading for hours and never opens.

Question

Hi, I installed knowage 8_0_5 on windows server 2012 with and I am using a mysql database on port 3307.  I have no idea what i have done wrong as i used the Knowage CE Installer.

Comments

I have checked the log files, and cant seem to locate any error, can anyone help please?

---

Hello Ifeoluwa,

could you please send me the Knowage.log so I can check it out?

Also, could you check if TOMCAT_HOME/conf/server.xml file is configured correctly to reach your database?

Thank you

Greetings

Alberto

---

Thanks Alberto,

My knowage.log file was empty till i stopped Knowage again. And this is what I got.

[pool-29-thread-1] 14 Feb 2022 12:07:47,812 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:308 - javax.naming.NameNotFoundException: Name [java:comp/env/resource_path] is not bound in this Context. Unable to find [java:comp].
[pool-29-thread-1] 14 Feb 2022 12:07:47,812 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:308 - javax.naming.NameNotFoundException: Name [java:comp/env/resource_path] is not bound in this Context. Unable to find [java:comp].

I think the server.xml file is configured correctly but since I am not so sure, this is it. I edited out my HMAC string value and my mysql password is password. Thank you once again.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<Server port="8005" shutdown="SHUTDOWN">

  <Listener className="org.apache.catalina.startup.VersionLoggerListener"/>

 

  <Listener SSLEngine="on" className="org.apache.catalina.core.AprLifecycleListener"/>

  <Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener"/>

  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>

  <Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener"/>

    <GlobalNamingResources>

      <Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>

  

<Environment name="resource_path" type="java.lang.String" value="C:\Users\Documents\Knowage-Server-CE\resources"/>

<Environment name="service_url" type="java.lang.String" value="http://localhost:8080/knowage"/>

<Environment name="sso_class" type="java.lang.String" value="it.eng.spagobi.services.common.JWTSsoService"/>

<Environment description="HMAC key" name="hmacKey" type="java.lang.String" value="*****"/>

<Environment description="File for security encryption location" name="password_encryption_secret" type="java.lang.String" value="C:\Users\Documents\Knowage-Server-CE/conf/passwordEncryptionSecret"/>

   

<Resource auth="Container" factory="de.myfoo.commonj.work.FooWorkManagerFactory" maxThreads="5" name="wm/SpagoWorkManager" type="commonj.work.WorkManager"/>

<Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" logAbandoned="true" maxIdle="15" maxTotal="20" maxWait="-1" minEvictableIdleTimeMillis="60000" minIdle="10" name="jdbc/knowage" password="password" removeAbandoned="true" removeAbandonedTimeout="3600" testOnReturn="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3307/knowage_ce" username="Ife"/>

<Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" logAbandoned="true" maxIdle="15" maxTotal="20" maxWait="-1" minEvictableIdleTimeMillis="60000" minIdle="10" name="jdbc/ds_cache" password="password" removeAbandoned="true" removeAbandonedTimeout="3600" testOnReturn="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3307/ds_cache" username="Ife"/>

</GlobalNamingResources>

  <Service name="Catalina">

 

    <Connector connectionTimeout="20000" port="8080" protocol="HTTP/1.1" redirectPort="8443"/>

 

 

    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" secretRequired="false"/>

 

 

    <Engine defaultHost="localhost" name="Catalina" startStopThreads="0">

 

      <Realm className="org.apache.catalina.realm.LockOutRealm">

     

        <Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/>

      </Realm>

      <Host appBase="webapps" autoDeploy="true" name="localhost" startStopThreads="0" unpackWARs="true">

 

       

     

        <Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" pattern="%h %l %u %t &quot;%r&quot; %s %b" prefix="localhost_access_log" suffix=".txt"/>

      </Host>

    </Engine>

  </Service>

</Server>

 

---

Hi Ifeoluwa,

I noticed that the path set for the resource_path variable is missing from the user's folder (eg C:\Users\<user>\Documents\Knowage-Server-CE\resources). Can you check if that is the correct path?

Can you also check if there is any call in the browser that remains pending or if there are errors in the console?

Greetings
Alberto

---

Hi Alberto,

Thank you for your response,  I deleted the user from the text I sent but in the server.xml itself, the path is specified exactly how you wrote it. In my resources folder, I've got "DEFAULT_TENANT and lic" folders in there. I couldn't find any call in the browser that remained pending.

In the console, there are no errors, but the following Warnings and failed are shown.

log4j:WARN No appenders could be found for logger <org.springframework.jndi.JndiTemplate>.

log4j:WARN Please initilize the log4j system properly.

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation <NOP> logger implementation.

INFO [Catalina-utility-2] org.apache.jasper.serverlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs.

Thanks.

---

Hi Alberto,

I still need help with this please. Can you kindly check it out once more please. It will be very helpful to my work.

Cheers,

Ife

---

Hi Ifeoluwa,

It seems that something went wrong during the installation. Could you try to uninstall Knowage and reinstall it using the latest version of the installer?

Greetings
Alberto

---

Hello Alberto,

Thank you for your response, I want to apologise for my late response, I was assigned other more urgent projects so I had to postpone my Visualisation and reporting project with Knowage. 

As you suggested I uninstalled knowage and I tried to install it  based on our system architecture, I installed knowage 8_0_8 CE on a server and now I am using mysql 5.6.31 that is on another server. After fixing all initial errors, I am back in the same position of Knowage-vue loading without opening when I log in with biadmin or biuser. The error log shows 

[DefaultQuartzScheduler_Worker-1] 01 Jun 2022 12:02:54,026 ERROR it.eng.spagobi.commons.MetadataDatabaseConfigurationRetriever.loadConfigurations:88 - The table sbi_config is EMPTY

Can you kindly suggest what to do now?

Regards,

Ife

---

Hi Ifeoluwa,

Something seems to have gone wrong while initializing the SBI_CONFIG table. I tried on my local env but didn't reproduce the problem. Did you create the database using database scripts on GitHub?

Could you please check if there are any other errors before the one you posted?

As a last option, you can try to start Knowage using a brand new database configuration created with the necessary Knowage tables (https://github.com/KnowageLabs/Knowage-Server/tree/v8.0.8/knowagedatabasescripts).

Greetings,

Alberto

---

Hi Alberto,

No, I did not create the database using database scripts on GitHub. That might have been the origin of my issue. There were no other errors before that last error. I downgraded Knowage to version 7.4 and it seems to be working properly for now. I will take your advice and upgrade my mysql database for Knowage 8_0  and check if it will work now. Thank you for your constant help.

Regards,

Ife

---

Hi Alberto,

I have now fixed the error, I needed to give my user on the mysql database more permission. I can now access Knowage8_0_8 by going to Knowage through the domain name outside my server instead of localhost. Thanks for all your help.

Kind Regards,

Ife