---
# System prepended metadata

title: FeMS V5.10 (1.7.0) Deploy Steps
tags: [Release]

---

![Static Badge](https://img.shields.io/badge/FeMS-V5.10%20(1.7.0)-limegreen)

## v5.10 (1.7.0)  - October 18th, 2024
Angular CLI version 9.1.15.
## Steps
1. **IMPORTANT!!!!**:
    - **BACKUP DB Elicon_Voyage**. In case of error happened during upgrade, we can restore DB to previous state.
    - **Archive/Zip the whole directory `C:\inetpub\wwwroot` as a BACKUP**. In case of error happened during upgrade, we can restore web files to previous state.
    - Make sure all users saved their work and log out from Elicon FeMS.
3. Updating files in `ExcelTemplate` to
    - `C:\EliconUpload\1\ExcelTemplate`
4. Copy the folder `IMPA Images` to
    - `C:\`
5. Execute all scripts in folder `Scripts`
    - Please execute scripts in **SEQUENCE**
7. **Elicon_Sync.exe, init and create triggers for new tables.**
        - Run C:\Elicon\Elicon_Tool.exe
        - `Quickly`, click the word Init after exe is opened. You should see the **Success** information box.
        ![image](https://hackmd.io/_uploads/BJhMO1WfR.png)
5. Execute below scripts, make sure you get **`6668`** records returned
```
USE [Elicon_Voyage]
GO
SELECT COUNT(1)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('SYNC_CODE','FlowGroupId')
AND TABLE_NAME NOT IN ('sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet','__EFMigrationsHistory','__WorkFlowEFMigrationHistory')
AND TABLE_NAME NOT LIKE '%WorkFlow%'
```
5. Execute below scripts, make sure you get **`1167`** records returned
```
USE [Elicon_Voyage]
GO
SELECT COUNT(1) FROM ExcelFormMapping WHERE template NOT LIKE 'ntu%'
```
6. Execute below scripts:
   - Make sure you get **`414`** records returned
    ```
    USE [Elicon_Sync]
    GO
    SELECT COUNT(1) FROM Definition
    ```
   - For sites which are using Sync, for example TVL, Cetus, Tairong, Jinhui, make sure you get **`0`** records returned
    ```
    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.triggers WHERE is_disabled = 1
    ```
   - For sites which are **NOT** using Sync, for example CLSICO, make sure you get **`0`** records returned
    ```
    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.triggers WHERE is_disabled = 0
    ```
7. Execute below scripts:
    - For sites which are using Sync, for example TVL, Cetus, Tairong, Jinhui, make sure you get **`0`** records returned
    ```
    USE [Elicon_Voyage]
    GO
    SELECT COUNT(1) FROM sys.tables
    WHERE object_id NOT IN (SELECT parent_id FROM sys.triggers WHERE  is_disabled = 0)
    AND name NOT IN ('UserRefreshTokens','sysdiagrams','EliconDataDesign','EliconDataGroupDesign','EliconDataSet','TableDefinition','SystemConfig','Sheet1','IMPA_IMPORT','IMPA8_IMPORT','LoginLog','SystemKeyGenerator')
    ```
    - If you do not get **`0`** records returned, do the following
        - Run C:\Elicon\Elicon_Tool.exe
        - `Quickly`, click the word Init after exe is opened. You should see the **Success** information box.
        ![image](https://hackmd.io/_uploads/BJhMO1WfR.png)

8. Execute below sripts for IMPA checking, by right you should get **`53507`**, **`51708`**, **`51708`**
    ```
    USE [Elicon_Voyage]
    GO
    SELECT count(1) FROM IMPA8_IMPORT
    SELECT count(1) FROM IMPA8_IMPORT WHERE INFORMATION NOT IN ('DELETE','NEW. SKIP BECAUSE IT IS DUPLICATE')
    SELECT count(1) FROM StockType WHERE IMPA = 1 AND StatusIndicator = 1 AND DeleteFlag = 0
    ```

9. Updating webpage files in directory`C:\inetpub\wwwroot`:
    - C:\inetpub\wwwroot\FeMS-Frontend
        - Delete all files, **EXCEPT** the file web.config.
        ![image](https://hackmd.io/_uploads/B1ki5AJlke.png)
    - C:\inetpub\wwwroot\Qms
        - Delete all files in this directory.
    - Copy web folders from Release package to `C:\inetpub\wwwroot`, and REPLACE!!
        - ![image](https://hackmd.io/_uploads/B11Ci0kekg.png)
    - if encountered error, for example: when updating the folder `pms`:
    - This means someone is using FeMS.
    ![image](https://hackmd.io/_uploads/H1O-KnoFa.png)
    - In IIS, select the site `pms` and Stop, 
    ![image](https://hackmd.io/_uploads/SJavrhiF6.png)
    - Do file replacement (paste) again.
    - Start IIS service.
    ![image](https://hackmd.io/_uploads/rJXyq2sYT.png)
9. Open Browser and test Elicon FeMS.