Skip to main content

v6.3.0

Update Information
Upgrade Instruction

What's New

Support multi version deployment mode for web front-end
Support MySQL MGR cluster mode
Single sign-on supports login with microsoft account
Add log records for value-added service key binding
Sync HAP SaaS Edition v6.3.0

Issues Fixing

Worksheet query record field, selecting a single record and printing it through the template resulted in an error.
The associated record of the worksheet is set to not be opened, but it can still be viewed by logging in the operation log.
The intermediate option fields in the worksheet draft box have not been filtered according to the set range.
The business rules in the worksheet draft box cannot be correctly verified.
When the required fields in the worksheet sub table are empty, they can still be submitted in some cases.
Differences in user permissions for worksheet sub table fields can cause column width misalignment.
The calculation of worksheet formula field functions is invalid when displayed as a percentage.
Creating a record from the draft box and triggering the workflow, interface push is invalid.
When values are rounded to 0 or 1 decimal place in a pivot table, the total value will be rounded twice.
There is a watermark when previewing the image, but there is no watermark when downloading.
After modifying the system access address, custom icons under organizational application management cannot be displayed.
On the mobile web, worksheet association record set to allow opening is invalid.

Attention

Please ensure that the MongoDB version is 4.4 or above before upgrading to 6.0.0+.

Standalone Mode

Data Backup
Upgrade microservices to version 6.3.0. Refer to this
After the image upgrade is completed, execute the script in the microservice application container. The steps are as follows:
1. Entering the container: docker exec -it $(docker ps | grep community | awk '{print $1}') bash
2. Execute the following command (If the username and password have been customized, please modify the corresponding parameter values), add DisplayOrder field to Project_DepartmentAccount table
```
mysql -h sc -P 3306 -uroot -p123456 --default-character-set=utf8 < /init/mysql/6.3.0/DDL.sql
```
3. Execute MongoDB scripts to synchronize pre-set regions and translation content
```
source /entrypoint.sh && mongodbResetRegion
source /entrypoint.sh && mongodbResetTemplateMessage
```

Cluster Mode

Backup data storage related servers.
Upgrade microservices to version 6.3.0. Refer to this
Enter the config Pod of the control node and execute the following commands, as shown below:
1. Enter the config Pod: kubectl exec -it $(kubectl get pod | grep config | awk '{print $1}') bash
2. Execute the following script
  
  Update the preset file (if using external file object storage, this command does not need to be executed, refer to the custom file object storage to reinitialize the preset file)
```
source /entrypoint.sh && fileInit
```
  Execute MySQL script, add DisplayOrder field to Project_DepartmentAccount table
```
mysql -h $ENV_MYSQL_HOST -P $ENV_MYSQL_PORT -u$ENV_MYSQL_USERNAME -p$ENV_MYSQL_PASSWORD --default-character-set=utf8 < /init/mysql/6.3.0/DDL.sql
```
  Execute MongoDB scripts to synchronize pre-set regions and translation content
```
source /entrypoint.sh && mongodbResetRegion
source /entrypoint.sh && mongodbResetTemplateMessage
source /entrypoint.sh && mongodbExecute mdapps /init/mongodb/6.3.0/mdapps/DDL.txt
```