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

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

+1 vote
1 view

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.

Environment Windows Server 2012, Knowage 8_0_5, Mysql 8.0.28
in Installation by (480 points)
Show 6 previous comments
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
by (6.8k points)

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

by (480 points)

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

by (6.8k points)

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

by (480 points)
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
by (480 points)

Please log in or register to answer this question.

Powered by Question2Answer
...