This is how to guide for updating MagicInfo Server to V8 ( 20.1010.7) which is the latest at the moment (2020 Nov)

** If your current version is V4 or V6, you don't need to hop on V7 in order to end up V8. Just update straight to V8 from your version. 

** For lower version than V4004.8, please contact with your regional contact point. We recommend fresh installation of V8. 


DB Migration


 WAS & DB on Same Machine 

 DB is installed separately.

flyway (migration tool behavior)

Flyway handles DB update.

User can retry using flyway command when it fails with MIS installation package. Check Flyway section for more details.

DB manual query

In irregular (fault) behavior of flyway, due to customer specific environment,

--> can run DB update manually, see DB Manual Update Section for more details.

 DB manual query.

→ Need to provide dbqueriesto the customer. (Attached)


WAS and DB is on separate machine

WAS will be updated using MagicINFO Server install package.

For DB update, you need to run the query or queries manually according to the MIS version.

See DB Manual Update section for more details.


WAS and DB is on Same machine

WAS and DB will be updated automatically by MagicINFO Server install package. Follow the below guide to update.

Step-by-step guide


1.Select the language of installation.


2. Press the “Yes” button to continue the update.


3.Press the “Yes” button. This process will check whether the MagicInfo Server and Server PC are ready to be updated or not.


4. When everything is OK. Test result will be PASS.



5. If status checking process Pass. It is good to continue updating.


6. a) When there is a problem, Total Result is FAIL.


6. b) Status Checking Process will show the Fail item and guide you to fix the issue.


In case you face issue, mostly it will be related to DB only, so please check DB migration section.

*For other issues check trouble shooting section.

Running Flyway tool Manually

Flyway is an automatic DB migration tool.

This will run automatically when you install WAS and DB on the same machine,

but when you have error during DB upgrade this is how to check the log and re-run the migrate. 

**The version of official released MIS is first coming in SQL file's name, and if there is additional changes then the number comes after the next "." (ex. 4005.7.1) 

** If the original DB had problem on table so that the DB update failed during Flyway update, then we need to fix the problem on DB first and then re-execute updating using "migrate" command. ( The reason/problem line will be shown on flywaylog.txt)

** If upgraded to V8, only then you can see the Flyway folder at following path

[Install Directory]\MagicInfo Premium\flyway

Screenshot below shows SQL files for postgres when upgraded to V8


To check whether DB upgrade is successful or not, Run the bat file using following command, it will show whether all scripts are executed properly or not:

(Below is the sample snapshot after running following command for upgrading v7 to v8)

mis.bat info 


If update had failed, then that *.sql file's update state will be shown "Pending" and the excuted query before that line on that sql file will be REVERTED.

Meaning we need re-excute sql from which hadn't been applied. Updae state is also written in DB table (flyway_schema_history)

Run the following command to re-run the flyway:

mis.bat migrate


You can find the log & status on log file ([Install Directory]\MagicInfo Premium\flywaylog.txt) and db table (flyway_schema_history), check below snapshot. 


if there is still an issue in flyaway execution then you need to update DB manually, see dbmanualupdate section. However after flyaway if you are doing manual updating then ,"flyway_schema_history" table has to be deleted totally (drop table) so that next version update won't have problem or stuck during updating


DB Manual Update

For updating DB manually, you need to run the query or queries manually according to the current MIS version to Upgraded version.

For queries check dbqueries Section and select the files according to the version and DB type (POSTGRES and MSSQL) 

There could be following scenarios.

Scenario 1: When WAS and DB is on separate machine, then you need to upgrade DB manually

Run the query files mentioned in dbqueries section one by one. Still if any issue check scenario 2.

Scenario 2: When WAS and DB is on same machine and DB did not update properly (DB tables/columns error) after upgrade MIS. (verify using WSRM.log files).

In this scenario customer need to run queries one by one from all related files as it seems some query are executed nd some are not, so running full file would not be helpful.

** while running queries one by one, you need to mind the insert queries as if they executed again they can create issue. Therefore before running the insert queries check the values in DB first.

Query Verification

For verification check the table in DB which you altered or updated to make sure query is executed properly.

For Postgres:

  1. Open pgAdmin
  2. Open MagicINFO DB > Schema > tables
  3. If you have add some column A in table X then you can either use query tool and run query like (select A from table X) or check the same from pgAdmin UI.
     OR

For SQL Server (MSSQL):

  1. Open SQL server Management studio
  2. Open MagicINFO DB > Tables
  3. Run Query or verify through UI.
      OR


Trouble Shooting 

Below are some points to check if upgrade fails:

  1. Automatic update fails, check following log files (Path: [Install Directory]/MagicInfo Premium/)
    • MyInstallLog_20.1010.7.txt : update result file
       => [ERROR][MagicInfoServiceStop] stop MagicInfoPremium Service
      Meaning the mis service didn't stop. You have to stop the server, then update the server and "start" the service.

    • MISInformation.txt

    • verification.txt : result of "status checking process" before the actual update. 


 2. Maybe WAS/ DB were installed separately first, then DB has restored to same machine

Check the registry (Path will be Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Samsung\MagicInfo-i\Server\Premium) . See below snapshot for reference.

if bComplete ==1, means DB and WAS installed on same machine.

if bDBPostgresSQL ==1, means DB only installation

if bWAS ==1, means WAS only installation.

if bWAS is set 1 , do the manual db update. And change to bComplete = 1 for next version update or remember to do manual db update next time. 


3. Web Author component failure

org.apache.catalina.core.ContainerBase.startInternal A child container failed during start java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/MagicInfoWebAuthorClient]]

=> if this log appears on wsrm log, then do replace the web author client by following way:

  1. Delete the folder "[Install Directory]\MagicInfo Premium\tomcat\webapps\MagicInfoWebAuthorClient"
  2. Restart the MIS service.
  3. If still issue exists then replace the [Install Directory]\MagicInfo Premium\webauthorMagicInfoWebAuthorClient.war with latest one according to MIS version, then repeat first 2 steps.


DB Queries.

These queries should be executed one - by - one in order


MIS Update DB Query (2020 Dec).zip

< Postgresql >

 Current Version

Sql files to update

V4004.8

PSQL_4004.8_4005.7.sql

PSQL_4005.7_additional.sql

PSQL_4005.7_4100.0.sql

PSQL_4100.0_4101.8.sql

PSQL_3106.1_additional.sql

PSQL_4101.8_6000.0.sql

PSQL_6000.0_6001.0.sql

PSQL_6001.0_6002.0.sql

PSQL_6002.0_7000.0.sql

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

V4005.7

PSQL_4005.7_4100.0.sql

PSQL_4100.0_4101.8.sql

PSQL_3106.1_additional.sql

PSQL_4101.8_6000.0.sql

PSQL_6000.0_6001.0.sql

PSQL_6001.0_6002.0.sql

PSQL_6002.0_7000.0.sql

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

V4101.8

PSQL_4101.8_6000.0.sql

PSQL_6000.0_6001.0.sql

PSQL_6001.0_6002.0.sql

PSQL_6002.0_7000.0.sql

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

 v6000

PSQL_6000.0_6001.0.sql

PSQL_6001.0_6002.0.sql

PSQL_6002.0_7000.0.sql

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

 v6001

PSQL_6001.0_6002.0.sql

PSQL_6002.0_7000.0.sql

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

 v6002

PSQL_6002.0_7000.0.sql

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

 v7100.2

PSQL_7100.0_7990.0.sql

PSQL_7990.0_20.1000.0.sql

PSQL_20.1000.0_20.1010.0.sql

  V8 First Release(20.1000.14)PSQL_20.1000.0_20.1010.0.sql


< MSSQL > 

 Current Version

Sql files to update

V4004.8

MSSQL_4004.8_4005.7.sql

MSSQL_4005.7_additional.sql

MSSQL_4005.7_4100.0.sql

MSSQL_4100.0_4101.8.sql

MSSQL_3106.1_additional.sql

MSSQL_4101.8_6000.0.sql

MSSQL_6000.0_6001.0.sql

MSSQL_6001.0_6002.0.sql

MSSQL_6002.0_7000.0.sql

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

V4005.7

MSSQL_4005.7_4100.0.sql

MSSQL_4100.0_4101.8.sql

MSSQL_3106.1_additional.sql

MSSQL_4101.8_6000.0.sql

MSSQL_6000.0_6001.0.sql

MSSQL_6001.0_6002.0.sql

MSSQL_6002.0_7000.0.sql

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

V4101.8

MSSQL_4101.8_6000.0.sql

MSSQL_6000.0_6001.0.sql

MSSQL_6001.0_6002.0.sql

MSSQL_6002.0_7000.0.sql

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

 v6000

MSSQL_6000.0_6001.0.sql

MSSQL_6001.0_6002.0.sql

MSSQL_6002.0_7000.0.sql

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

 v6001

MSSQL_6001.0_6002.0.sql

MSSQL_6002.0_7000.0.sql

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

 v6002

MSSQL_6002.0_7000.0.sql

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

 v7100

MSSQL_7100.0_7990.0.sql

MSSQL_7990.0_20.1000.0.sql

MSSQL_20.1000.0_20.1010.0.sql

 V8 First Release(20.1000.14) MSSQL_20.1000.0_20.1010.0.sql