페이지 이력
...
** For lower version than V4004.8, please contact with your regional contact point. We recommend fresh installation of V8.
DB Migration 책갈피 dbmigration dbmigration
dbmigration | |
dbmigration |
| 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. | X |
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 update query to 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.
...
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.
책갈피 #flywaytool #flywaytool
Running Flyway tool Manually
#flywaytool | |
#flywaytool |
Flyway is an automatic DB migration tool.
...
if there is still an issue in flyaway execution then you need to update DB manually, see DB Manual Update 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
책갈피 #dbmanualupdate #dbmanualupdate
DB Manual Update
#dbmanualupdate | |
#dbmanualupdate |
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 DB Queries Section and select the files according to the version and DB type (POSTGRES and MSSQL)
...
Run the query files mentioned in DB Queries section one by one. Still if any issue check scenario 2.
...
- Open SQL server Management studio
- Open MagicINFO DB > Tables
- Run Query or verify through UI.
OR
책갈피 #troubleshooting #troubleshooting
Trouble Shooting
#troubleshooting | |
#troubleshooting |
Below are some points to check if upgrade fails:
...
- Delete the folder "[Install Directory]\MagicInfo Premium\tomcat\webapps\MagicInfoWebAuthorClient"
- Restart the MIS service.
- 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. 책갈피 dbqueries dbqueries
dbqueries | |
dbqueries |
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 |
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 |
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 |
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 |
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 |
v6002 | PSQL_6002.0_7000.0.sql PSQL_7100.0_7990.0.sql PSQL_7990.0_20.1000.0.sql |
v7100.2 | PSQL_7100.0_7990.0.sql PSQL_7990.0_20.1000.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 |
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 |
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 |
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 |
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 |
v6002 | MSSQL_6002.0_7000.0.sql MSSQL_7100.0_7990.0.sql MSSQL_7990.0_20.1000.0.sql |
v7100 | MSSQL_7100.0_7990.0.sql MSSQL_7990.0_20.1000.0.sql |