MIS Migration - Multiple filter values stacking

Owned by Karen Hogan (Unlicensed)
Last updated: Jul 23, 2021
3 min read

If you have recently upgraded your product version from one of our legacy builds you may notice that a few of the filters that were using multiple data values as filters have combined into one value. This occurs because there is a missing migration script within the dashboard from the time when we changed the comma separator to the colon.

In order to fix this issue, you will need to go into your dashboard database and run the following command: UPDATE MIS_VERSION SET V10_VERSION_NUMBER = 1072;

Hyper SQL connection

If you are still using a HyperSQL connection (Data folder), you will need to first make sure you have the sqltool.rc file in the user files of the user you are currently logged in as.

Within this rc file you will see a port that lines up with the repository port of your dashboard, by default this is 9910 but if you have changed this upon install you will need to change the port within this file.

Once this port matches your repository port you should be able to run the sqltool-repos within the data folder and this will connect you to the dashboard repository.

Once connected, run the update command: UPDATE MIS_VERSION SET V10_VERSION_NUMBER = 1072;

You will also need to run a commit to make sure it updates the database.

Once this has been done you will need to restart the dashboard via the admin.exe for the database to pick up the update.

MariaDB connection

If you are using the MariaDB connection (DB) folder then there are two ways to access the dashboard database.

The first way is to go into the DB folder and run the sql_tool.bat which should connect you to the database directly.

From this screen you will need to run the update command: UPDATE MIS_VERSION SET V10_VERSION_NUMBER = 1072;

Alternatively, if this does not automatically connect you may need to connect manually by opening a command prompt, navigating to the bin folder within your install and running the following command: mysql.exe -uroot -p*pi_install.log*.

The password is gathered from the pi_install.log file that is found within the DB folder.

Once this runs, specify ‘use dashboard’ so you connect to the right database.

Once you are connected, you can then run the update script: UPDATE MIS_VERSION SET V10_VERSION_NUMBER = 1072;

You will also need to run a commit to make sure it commits to the database then restart your dashboard.