Failed to upgrade the data warehouse during the Engineering Lifecycle Management instance upgrade

When you upgrade the Engineering Lifecycle Management instance, the upgrade process for the Engineering Lifecycle Management application might fail with the following error. The Applications Events table shows that the error Failed to upgrade the data warehouse with the reason code DWUpgradeErr for the Engineering Lifecycle Management application. Review the following troubleshooting information to resolve the error.

Problem

  1. In the Red Hat® OpenShift® Container Platform web console, go to Operators > Installed Operators and select the Engineering Lifecycle Management operator.
  2. Go to the ELM tab and select the Engineering Lifecycle Management instance.
  3. On the Details tab, verify the Engineering Lifecycle Management application status in the Applications Events table. It shows the message as Failed to upgrade the data warehouse with the reason code DWUpgradeErr, which indicates that the repotools is failed to upgrade the data warehouse during the upgrade.

Resolution

  1. Review the Jazz® Team Server application log /elm/server/conf/jts/logs/repotools-jts_upgradeWarehouse.log to identify the cause of the failure. For more information about accessing the application pod logs, see Accessing application pod logs.
  2. To resolve the error manually and resume the upgrade process, complete the following steps.
    1. Manually resolve the failure cause that affects the upgrade of data warehouse.
    2. Complete the following steps to delete the Engineering Lifecycle Management application pod.
      1. In the Red Hat OpenShift Container Platform web console, go to Workloads > Pods.
      2. Select the project where you installed the Engineering Lifecycle Management operator from the Project list.
      3. The Pods page lists the Engineering Lifecycle Management application pods and Engineering Lifecycle Management operator pod information.
      4. Click the pod name to see the pod details.
      5. Click Delete Pod from the Actions menu. The Engineering Lifecycle Management application pod is deleted. The Engineering Lifecycle Management application pod restarts automatically.
    3. The upgrade process resumes automatically and upgrades the data warehouse.
  3. To upgrade the data warehouse manually and resume the upgrade process, complete the following steps.
    1. Upgrade the data warehouse manually for the Engineering Lifecycle Management application in which the upgrade process is failed. For more information, see Repository tools command to upgrade data warehouse database schema.
      Note: The repotools script that is provided in the referred web page is available at location /elm/server on the application pod.
    2. Run the following command to complete the upgrade step.
      /elm/server/resolveUpgradeErr.sh UPGRADE_UPGRADED_DW
    3. Complete the following steps to delete the Engineering Lifecycle Management application pod.
      1. In the Red Hat OpenShift Container Platform web console, go to Workloads > Pods.
      2. Select the project where you installed the Engineering Lifecycle Management operator from the Project list.
      3. The Pods page lists the Engineering Lifecycle Management application pods and Engineering Lifecycle Management operator pod information.
      4. Click the pod name to see the pod details.
      5. Click Delete Pod from the Actions menu. The Engineering Lifecycle Management application pod is deleted. The Engineering Lifecycle Management application pod restarts automatically.
    4. After the Engineering Lifecycle Management application pod is restarted, the upgrade process resumes automatically with the next step.