data_engine fails to start

Document ID : KB000111836
Last Modified Date : 21/08/2018
Show Technical Document Details
Issue:
The data_engine probe would not stay up and running and the log showed errors indicating that the CM_METRIC_UNIT table was missing.

Aug 21 10:03:11:330 [3796] de: [QoSData] ExecuteRecords - 1 errors
Aug 21 10:03:11:330 [3796] de: (1) ExecuteRecords [Microsoft OLE DB Provider for SQL Server] Invalid object name 'CM_METRIC_UNIT'.
...
Aug 21 10:06:11:456 [3184] de: COM Error [0x80040e37] IDispatch error #3127 - [Microsoft OLE DB Provider for SQL Server] Invalid object name 'CM_METRIC_UNIT'.
Environment:
- UIM 8.4
- data_engine v8.4
Cause:
- Suspect either a deletion of tables or restore from backup that did not complete properly due to the number of missing tables in the database schema.
Resolution:
Reran the UIM installation to repair the schema which was missing many tables, including many CM_* tables then the data)engine started without issue and the error subsided.