v7.0.0

Update Information

What's New

• Sync HAP SaaS Edition v12.0.0 & v12.0.1

Issues Fixing

• [Application] When importing to create an app, custom actions are missing.
• [Application] After importing an upgrade package, subprocess and PBP are automatically disabled.
• [Worksheet] Amount-in-words (uppercase currency) conversion is incorrect.
• [Worksheet] Cascading select field cannot find data after configuring the search field.
• [Worksheet] When using a member field to set the default value of a department field, the department path cannot be displayed.
• [Worksheet] Creating a worksheet from an Excel file fails when the file size exceeds 10 MB.
• [Worksheet] Standard roles cannot inline-edit fields inside tab pages in the grid view.
• [Worksheet] Column width settings in views revert automatically.
• [Worksheet] Filtering by department field does not work when searching within the filter list.
• [Worksheet] Editing related records in grid view results in an error.
• [Worksheet] Error log recorded when uploading attachments during batch edit.
• [Worksheet] On the mobile web, filtering conditions configured for related-record fields do not take effect when adding a new record.
• [Worksheet] On the mobile web, record details page lacks a print feature.
• [Workflow] In the “Update External User Info” node, the “Increase” option actually behaves as “Set To”.
• [Workflow] In fill-in-link forms, enabling “Editable” or “Required” for fields in tab pages does not take effect.
• [Workflow] When calling a PBP, extremely small numeric results (with many decimal places) cannot be retrieved.
• [Charts] The values shown in numeric charts differ from the underlying raw data displayed when clicked.
• [Org Admin] “View More” in reporting relationships fails to load additional data.
• [Attachment] Cannot be previewed or downloaded when it is embedded in IFrame.

Upgrade Instruction

Attention

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

Standalone Mode

• Data Backup

• If MongoDB connection authentication is enabled, you need to manually create the mdwfai database. Please refer to how to create a new MongoDB database

• if using external file object storage, refer to the custom file object storage to reinitialize the preset file

• Update MongoDB preset data to 7.0.0. Refer to this (Can be executed in the running state of the original version of the service)

• Upgrade microservices to version 7.0.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(Departments and organization roles support the addition of fields related to deactivation functions)

     If the username and password have been customized, please modify the corresponding parameter values

     mysql -h sc -P 3306 -uroot -p123456 --default-character-set=utf8 -N < /init/mysql/7.0.0/DDL.sql

Cluster Mode

• Backup data storage related servers.

• If MongoDB connection authentication is enabled, you need to manually create the mdwfai database. Please refer to how to create a new MongoDB database

• Update MongoDB preset data to 7.0.0. Refer to this (Can be executed in the running state of the original version of the service)

• Add ai and mcp service configuration in microservice application service.yaml (default: /data/mingdao/script/Kubernetes/service.yaml).

  The default configuration is as follows, and the parameter values can be adjusted according to actual needs:

  apiVersion: apps/v1
  kind: Deployment
  metadata:
    name: ai
    namespace: default
  spec:
    replicas: 1
    selector:
      matchLabels:
        app: ai
    template:
      metadata:
        labels:
          app: ai
        annotations:
          md-update: "20240123163208"
      spec:
        containers:
        - name: ai
          image: registry.cn-hangzhou.aliyuncs.com/mdpublic/mingdaoyun-community:7.0.0
          env:
          - name: ENV_SERVERID
            value: "single:ai"
          resources:
            limits:
              cpu: "4"
              memory: 8096Mi
            requests:
              cpu: "0.01"
              memory: 64Mi
          readinessProbe:
            tcpSocket:
              port: 8066
            initialDelaySeconds: 10
            periodSeconds: 10
          livenessProbe:
            tcpSocket:
              port: 8066
            initialDelaySeconds: 180
            periodSeconds: 10
  
  ---
  
  apiVersion: v1
  kind: Service
  metadata:
    name: ai
    namespace: default
  spec:
    selector:
      app: ai
    ports:
      - name: http-ai
        port: 8066
        targetPort: 8066
  
  ---
  
  apiVersion: apps/v1
  kind: Deployment
  metadata:
    name: mcp
    namespace: default
  spec:
    replicas: 1
    selector:
      matchLabels:
        app: mcp
    template:
      metadata:
        labels:
          app: mcp
        annotations:
          md-update: "20240123163208"
      spec:
        containers:
        - name: mcp
          image: registry.cn-hangzhou.aliyuncs.com/mdpublic/mingdaoyun-community:7.0.0
          env:
          - name: ENV_SERVERID
            value: "single:mcp"
          resources:
            limits:
              cpu: "4"
              memory: 8096Mi
            requests:
              cpu: "0.01"
              memory: 64Mi
          readinessProbe:
            tcpSocket:
              port: 8165
            initialDelaySeconds: 10
            periodSeconds: 10
          livenessProbe:
            tcpSocket:
              port: 8165
            initialDelaySeconds: 180
            periodSeconds: 10
  
  ---
  
  apiVersion: v1
  kind: Service
  metadata:
    name: mcp
    namespace: default
  spec:
    selector:
      app: mcp
    ports:
      - name: http-mcp
        port: 8165
        targetPort: 8165
  
  ---

• Upgrade microservices to version 7.0.0. Refer to this

• Enter the config Pod of the control node and execute the following commands, as shown below:

  1. Enter config Pod (note to change the default to the actual namespace)

     kubectl exec -it $(kubectl get pod -n default | 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-cluster.sh && fileInit

     Execute MySQL script(Departments and organization roles support the addition of fields related to deactivation functions)

     mysql -h $ENV_MYSQL_HOST -P $ENV_MYSQL_PORT -u$ENV_MYSQL_USERNAME -p$ENV_MYSQL_PASSWORD --default-character-set=utf8 -N < /init/mysql/6.5.0/DDL.sql

  3. Execute MongoDB script (add index)

     source /entrypoint.sh && mongodbExecute mdapps /init/mongodb/7.0.0/mdapps/DDL.txt
     source /entrypoint.sh && mongodbExecute mdpayment /init/mongodb/7.0.0/mdpayment/DDL.txt
     source /entrypoint.sh && mongodbExecute mdworksheet /init/mongodb/7.0.0/mdworksheet/DDL.txt
     source /entrypoint.sh && mongodbExecute mdworkweixin /init/mongodb/7.0.0/mdworkweixin/DDL.txt