Views:

This error happens because of a missing primary key in the TMCM/Apex Central database.

To resolve this issue, get the TMCM/Apex Central database and submit it to Trend Micro Technical Support for analysis:

  1. Stop the following services:
    • Trend Micro Management Infrastructure
    • Trend Micro Common CGI
       
      Trend Micro Common CGI is not available in TMCM 7.0 and Apex Central.
    • Trend Micro Control Manager
    • Trend Micro NTP
  2. Log on to the SQL server using Management Studio.
  3. Right-click db_ControlManager and click Properties > Data Files . This shows the location of the db_controlmanager.mdf database file.
  4. Right-click db_ControlManager and click Detach database.
  5. Copy the db_controlmanager.mdf file and send it to Trend Micro Technical Support.
  6. Re-attach the TMCM/Apex Central™ database again:
    1. Log on to the SQL server using Management Studio.
    2. Right-click Databases and click Attach. The Attach Databases dialog box opens.
    3. Locate the db_controlmanager.mdf database file and click Add. Sample location: .. \MSSQL\DATA\ db_controlmanager.mdf