HY000 errors after restoring the configuration in an aggregator

If you receive HY000 errors after you restore the configuration in an aggregator, run a dummy import.

Symptoms

When you restore the configuration of an aggregator or the Central Manager, you receive one or both of these messages.

ERROR 1031 (HY000) at line 1: Table storage engine for 'GUARD_USER_ACTIVITY_AUDIT' doesn't have this option 
ERROR 1031 (HY000) at line 1: Table storage engine for 'AGGREGATOR_ACTIVITY_LOG' doesn't have this option

Causes

This error condition can occur if there is a temporary mismatch in the internal databases.

Environment

The collector and aggregator are affected.

Resolving the problem

To resolve the problem, run a dummy import.