Removed device remains in ZENworks

A device that has was thought to be deleted/removed from ZENworks is still showing in inventory reports.

Loader-messages.log:

[TRACE] [] [2364] [ZENLoader] [772] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [1 soft deleted objects are marked for clean up.] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [beforeObjectDeleteBulk :Calling updateComplianceBulk updation for users] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [getAllTargetedDevicesForObject :object=<GUID>, primary type=Device] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [getAllTargetedDevicesForObject: invalid primary type:Device] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [beforeObjectDeleteBulk: Calling updateComplianceBulk updation for devices] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [getAllTargetedDevicesForObject :object=<GUID>, primary type=Device] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [getAllTargetedDevicesForObject: invalid primary type:Device] [] [] [] [ZENServer]
[DEBUG] [] [2364] [ZENLoader] [772] [] [((ComplianceUpdation()] [] [Calling updateComplianceForACOGroups updation for groups of aco object=<GUID>] [] [] [] [ZENServer]
[TRACE] [] [2364] [ZENLoader] [772] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Cleaning soft deleted objects using Database Procecure.] [] [] [] [ZENServer]
[TRACE] [] [2364] [ZENLoader] [772] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Error message from Database procedure zZENObjectDelete : Unable to find in index 'IDX_CompChg12_K2_K10_K1' for table 'NC_MouseChanges'] [] [] [] [ZENServer]
[TRACE] [] [2364] [ZENLoader] [772] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Cleaned up 0 soft deleted objects in 706 ms.] [] [] [] [ZENServer]
[TRACE] [] [2364] [ZENLoader] [772] [] [Loader.SoftDeletedObjectsCleanupHandler] [] [Failed to clean up 1 soft deleted objects.] [] [] [] [ZENServer]

Database Error Message on Validate:
An error occurred while attempting to validate the index 'IDX_CompChg12_K2_K10_K1 - NC_MouseChanges (zenadmin)'.
Run time SQL error -- Validation of index "IDX_CompChg12_K2_K10_K1" has failed
[SAP][ODBC Driver][SQL Anywhere]Run time SQL error -- Validation of index "IDX_CompChg12_K2_K10_K1" has failed
SQLCODE: -300
SQLSTATE: HY000
SQL Statement: VALIDATE INDEX "IDX_CompChg12_K2_K10_K1" ON "zenadmin"."NC_MouseChanges"

Please contact support for assistance with this issue.

The IDX_CompChg12_K2_K10_K1 index had become corrupted.