unable to open http://localhost:8080/knowage in browser

Question

Hi,

2018-07-30 10:33:03 12816 [ERROR] InnoDB: Cannot open datafile for read-only: '.\knowage_ce\sbi_whatif_workflow.ibd' OS error: 203
2018-07-30 10:33:03 12816 [ERROR] InnoDB: Could not find a valid tablespace file for `knowage_ce/sbi_whatif_workflow`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2018-07-30 10:33:03 12816 [Warning] InnoDB: Ignoring tablespace for `knowage_ce`.`sbi_whatif_workflow` because it could not be opened.
2018-07-30 10:33:03 12816 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2018-07-30 10:33:03 12816 [ERROR] InnoDB: The error means the system cannot find the path specified.
2018-07-30 10:33:03 12816 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2018-07-30 10:33:03 12816 [ERROR] InnoDB: Cannot open datafile for read-only: '.\knowage_ce\sbi_ws_event.ibd' OS error: 203
2018-07-30 10:33:03 12816 [ERROR] InnoDB: Could not find a valid tablespace file for `knowage_ce/sbi_ws_event`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2018-07-30 10:33:03 12816 [Warning] InnoDB: Ignoring tablespace for `knowage_ce`.`sbi_ws_event` because it could not be opened.
2018-07-30 10:33:03 12816 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-07-30 10:33:03 12816 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-30 10:33:03 12816 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-30 10:33:03 12816 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-30 10:33:03 12816 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-07-30 10:33:03 12816 [Note] InnoDB: 5.7.20 started; log sequence number 681559592
2018-07-30 10:33:03 13092 [Note] InnoDB: Loading buffer pool(s) from C:\KNOWAGE\MariaDB\data\ib_buffer_pool
2018-07-30 10:33:03 12816 [Note] Plugin 'FEEDBACK' is disabled.
2018-07-30 10:33:03 12816 [Note] Recovering after a crash using mysql-bin
2018-07-30 10:33:03 12816 [Note] Starting crash recovery...
2018-07-30 10:33:03 12816 [Note] Crash recovery finished.
2018-07-30 10:33:03 12816 [Note] Server socket created on IP: '::'.
2018-07-30 10:33:03 12816 [Note] Reading of all Master_info entries succeded
2018-07-30 10:33:03 12816 [Note] Added new Master_info '' to hash table
2018-07-30 10:33:03 12816 [Note] mysqld: ready for connections.
Version: '10.2.11-MariaDB-log'  socket: ''  port: 3303  mariadb.org binary distribution
2018-07-30 10:33:04 13092 [Note] InnoDB: Buffer pool(s) load completed at 180730 10:33:04

Kind Regards,

pratap Dash

PD

Comments

Hi
First of all I strongly suggest to use Knowage 6.2.
Could you better describe what are you doing, ?
Info needed: OS, DBMS, JDK...
Best Regards
Angelo

Answer 1

From you logs, seems like to be a database error caused by the fact than the 'sbi_whatif_workflow' table is missing.

This table should have been created by the SQL script. If it's indeed the case, just create it by downloading the last script and the create the table within the metadata dadabase (default name is 'knowage_ce').