Health Check Error: Cannot Remove Temporary Table

Overview

The Health Check wizard must be run when upgrading in order to evaluate your instance's ability to move to the target version. During the health check, various types of issues may be detected which can affect your ability to upgrade. This article will cover how to resolve a "Cannot Remove Temporary Table" error reported by the health check.

Symptoms

This error generates an output similar to the following in health check:
Cannot Remove Temporary Table

Resolution

The generated error message will help determine the table causing the health check error. To address this issue, you can manually delete the table and then run the health check again to confirm that the issue is resolved:

  DELETE `table_name`;

If the issue persists, please contact Sugar support so that we may assist.