VxRail: Health Check Fails for op_status Test

VxRail Manager runs several health-checks (using VxVerify), one of which is operation_status. 
For VxRail 4.x, the size of the operation_status database table is checked. If it is too large, it could not then be migrated to VxRail 7.x. The individual entries are also checked to make sure that there are no empty extension values (Null or None).

For VxRail 7.0 and later versions, this test sees that the individual entries are checked to verify that there are no empty state values (Null or None).

The results of this health check and possible autocorrections are listed as a health check with one of the following results:

Each test that passes will not be listed in the summary report, for ease of reading.
An example of the health-check output is shown below:

#========================#======#=========#====================================================================#==============#
|  Hostname / Category   |Status  Dell_KB |  Warnings or Failures, unless tests Passed                         ; Product S.N. |
#========================#======#=========#====================================================================#==============#
| VxRM                   | Warning 201380 | op_status: Operation_status DB too large: 4200 kB.                                |

To get the database (DB) size in VxRail 4.x, this test runs a query similar to the command below:

psql -U postgres mysticmanager -c "select pg_size_pretty (pg_relation_size('operation_status'))"

This query looks at the size of the operation_status table and compares this against this tests warning and failure thresholds. Upgrades may fail if the operation_status DB table exceeds 4 MB, contains NULL entries, or (in 7.0+) has invalid status values outside the supported list.

Reduce oversized DB tables using the psql cleanup command, open a support case for NULL entries in 4.x, and use VxVerify -f or -fix to correct invalid entries in 7.x+. 

DB is too large:

psql -U postgres mysticmanager -c "delete from operation_status WHERE state='FAILED' OR state='COMPLETED' AND owner!='LOG_BUNDLE' AND id not like 'SBI_%';"

NULL or invalid DB entries:

For NULL entries in VxRail 4.x, open a support ticket for investigation: Contact Technical Support | Dell US 

Invalid entries in 7.x+:
Refer to: Dell VxRail: How to run the VxVerify tool