Today, I took an Ubuntu instance on Azure Cloud and followed below steps for setting up Knowage but getting DB errors given below.
Please guide what am I doing wrong? Why are some tables does not exists in DB? Or do we need to create missing tables manually?
This is delaying our POC which we need to show our prospective clients and management.
Kindly help.
Install MySQL
1.
sudo apt-get install mysql-server
2.
Modified /etc/mysql/mysql.conf.d/mysqld.cnf and changed
from
bind-address = 127.0.0.1
to
bind-address = *
3.
mysql -u root -p
ALTER USER 'root'@'%' IDENTIFIED BY ''mypswd ';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY ''mypswd';
FLUSH PRIVILEGES;
select version();
5.7.22-0ubuntu0.16.04.1
exit;
service mysql restart
Install Java
sudo update-java-alternatives -l
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer
sudo apt-get install oracle-java8-set-default
export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export PATH=$JAVA_HOME/bin:$PATH
java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
Install Knowage
1. Download Knowage
wget http://download.forge.ow2.org/knowage/Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip
unzip Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip
2. Create Swap Memory (https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04)
sudo swapon --show
free -h
df -h
sudo fallocate -l 4G /swapfile
ls -lh /swapfile
sudo chmod 600 /swapfile
ls -lh /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile
sudo swapon --show
free -h
3. Setup Knowage
sh Knowage-6_2_0-RC-CE-Installer-Unix-20180509.sh -c
Used existing MySQL DB and it created knowage_ce with following tables.
[cid:image007.png at 01D3F454.61A06C50]
4. Add Database Source in conf/server.xml
<Resource name="jdbc/knowage" auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/knowage_ce"
username="root"
password="mypswd"
maxActive="20" maxIdle="10"
maxWait="-1"/>
5. Download MySQL Connector and copy to lib dir
cp mysql-connector-java-5.1.46.jar /home/babbarkrishan/knowage/Knowage-Server-CE/lib/
6. start the knowage server in /bin
sh startup.sh
Now getting following errors in knowage.log file
[localhost-startStop-1] 25 May 2018 12:35:37,244 ERROR it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters:77 - HibernateException during query
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:66)
at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
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.deployWAR(HostConfig.java:1074)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1858)
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)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_CONFIG' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 39 more
[localhost-startStop-1] 25 May 2018 12:35:37,257 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:82)
at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
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.deployWAR(HostConfig.java:1074)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1858)
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)
[localhost-startStop-1] 25 May 2018 12:35:44,229 ERROR it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init:87 - An unexpected error occured while initializing metadata
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Ab unexpected error occured while initializing Product Types
at it.eng.spagobi.commons.initializers.metadata.ProductTypesInitializer.init(ProductTypesInitializer.java:64)
at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:82)
at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:66)
at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
…
.
.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_PRODUCT_TYPE' doesn't exist
.
.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_DATA_SOURCE' doesn't exist
And many more…..
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html <http://www.techmahindra.com/Disclaimer.html> externally http://tim.techmahindra.com/tim/disclaimer.html <http://tim.techmahindra.com/tim/disclaimer.html> internally within TechMahindra.
============================================================================================================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180525/1f4371ae/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 12595 bytes
Desc: image007.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180525/1f4371ae/attachment-0001.png>
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy