While trying to install Knowage with exisitng Maria DB installaed already getting error

Question

While trying to install Knowage 7.4 in linux environment with exisitng Maria DB installaed already getting error. Maria DB was installed already before starting knowage installation. Any suggestions on how to resolve this.

Exception:

java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.install4j.runtime.installer.helper.Install4jClassLoader$CustomCodeInvoker.invoke(Install4jClassLoader.java:165)
        at com.install4j.runtime.installer.helper.Install4jClassLoader.invokeInCustomClassLoader(Install4jClassLoader.java:156)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.createConnection(AbstractJdbcAction.java:139)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withConnection(AbstractJdbcAction.java:201)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withStatement(AbstractJdbcAction.java:176)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withResultSet(AbstractJdbcAction.java:153)
        at com.install4j.runtime.beans.actions.jdbc.CheckJdbcConnectionAction.executeJdbcCall(CheckJdbcConnectionAction.java:32)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.execute(AbstractJdbcAction.java:95)
        at com.install4j.runtime.beans.actions.SystemInstallOrUninstallAction.install(SystemInstallOrUninstallAction.java:29)
        at com.install4j.runtime.installer.ContextImpl$7.executeAction(ContextImpl.java:1668)
        at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1659)
        at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1656)
        at com.install4j.runtime.installer.helper.comm.actions.FetchObjectAction.execute(FetchObjectAction.java:14)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionDirect(HelperCommunication.java:274)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionInt(HelperCommunication.java:249)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionChecked(HelperCommunication.java:187)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.fetchObjectChecked(HelperCommunication.java:170)
        at com.install4j.runtime.installer.ContextImpl.performActionIntStatic(ContextImpl.java:1656)
        at com.install4j.runtime.installer.InstallerContextImpl.performActionInt(InstallerContextImpl.java:151)
        at com.install4j.runtime.installer.ContextImpl.performAction(ContextImpl.java:1103)
        at com.install4j.runtime.installer.controller.Controller.executeAction(Controller.java:368)
        at com.install4j.runtime.installer.controller.Controller.executeActions(Controller.java:334)
        at com.install4j.runtime.installer.controller.Controller.handleCommand(Controller.java:195)
        at com.install4j.runtime.installer.controller.Controller.start(Controller.java:94)
        at com.install4j.runtime.installer.Installer.runInProcess(Installer.java:59)
        at com.install4j.runtime.installer.Installer.main(Installer.java:46)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)
        at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57)

Answer 1

Dear chakrag1,

this issue could be related to a duplicate of hsqldb.jar in installer classpath. A user named kholls reported this workaround:

Workaround:

1. Run installer as normal
2. Right before config RDBMS steps. 
Database Management System Configuration
Use an already installed DBMS [1, Enter]
1
Select DBMS for metadata:
MariaDB [1, Enter]
MySQL [2]

3. Delete hsqldb.jar in temporary extracted installer dir (in my case: /home/apps/Knowage-7_2_0-CE-Installer-Unix-20200730.sh.14611.dir)

rm /home/apps/Knowage-7_2_0-CE-Installer-Unix-20200730.sh.14611.dir/user/hsqldb.jar

4. Continue installation

Let me know if this helps you, in that case we will add a note on official documentation.

Regards

Matteo