Skip to content

FAQ

This secition contains answers to the most asked questions.

For more information, refer to DHI Developers - FAQ or DHI Developers - Troubleshooting

Selecting a Database Server for the MIKE OPERATIONS Database

There are no clear recommendations for selecting the database server type for MIKE OPERATIONS databases.

Selecting the optimal database server for a MIKE OPERATIONS installation depends on various parameters for each installation:

MIKE OPERATIONS support the following range of database server types:

  • PostgreSQL: PostgreSQL databases support storing and displaying spatial data.

  • SQLite: For SQLite, GIS vector data can be stored and displayed. Raster data are not supported.
    SQLite is not recommended in a multiuser environment as SQLite locks the entire database when writing to it. SQLite is intended for use with our free license, either to demo MIKE OPERATIONS or for single-user desktop applications.

  • MSSQL Server: For MS SQL Server, GIS vector data can be stored and displayed. Raster data are not supported.

Warning

SQLite is not recommended in a multi-user environment as SQLite locks the entire database when writing to it.

DHI does not recommend specific database server types but recommends clients to consider the following when selecting a database type:

  • Existing database server: Are there any existing database servers available that are preferred?

  • Database server experience: When choosing a database server, in-house database server experience for certain types of databases will ease configuration and maintenance of the database server(s).

  • Pricing: Some database servers are free while others have license costs.

  • Support from vendor: When installing and maintaining a database server, support from the vendor of the databases servers could be required.

  • Amount of data: How much data is the database expected to contain when it comes to, e.g., time series and GIS data? Vendors of database servers have various recommendations for how to handle different kinds of data.

  • Types of data to store: When selecting a database server type for the MIKE OPERATIONS database it is important to be aware of the limitations of some of the database server types when it comes to what features MIKE OPERATIONS supports (in particular, raster data).

Active users are not shown in the in the Database Manager Utility

How to list the login user in MIKE OPERATIONS Database Manager Utility when someone is logged into the system?

  1. Open System Manager in MIKE Workbench, select the workspace and open workspace setting.

  1. Add a new setting for "KeepAliveFrequency" and specify the number of seconds between each update of the online users table (see below image) and restart application.

  1. Open MIKE OPERATIONS Database Manager Utility, select the menu: Online users, then you can see the user list.

Error creating a new database

When using PostgreSQL database servers where a security patch released by the PostgreSQL team has not been applied, an error “relation master.workspace does not exist” can be shown when creating a database.

To fix this, install the latest build of the version of PostgreSQL being used, or apply the hotfix from the PostgreSQL team. Please find the hotfix here:
https://www.postgresql.org/about/news/1834/

Find latest builds of PostgreSQL database servers supported by the PostgreSQL team here:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Before installing, note the versions supported by the version of MIKE OPERATIONS being used in the installation guide or in the file “DssDatabases.cfg.xml”.
The file can be found in the installation folder of MIKE OPERATIONS.

./JobManager/image3.png