Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

“Dynamic SQL generation for the UpdateCommand is not supported…” occurs when editing the log maintenance settings in Control Manager (TMCM) / Apex Central™

    • Updated:
    • 27 Feb 2019
    • Product/Version:
    • Apex Central™ All.All
    • Control Manager 6.0
    • Control Manager 7.0
    • Platform:
    • Windows 2000 Advanced Server
    • Windows 2000 Server
    • Windows 2003 Enterprise
    • Windows 2003 Server R2
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Enterprise 64-bit
    • Windows 2008 Server R2
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Server R2
    • Windows 2016 Server
Summary

When modifying the TMCM/Apex Central™ log maintenance settings, the following error appears:

Description: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
Exception Type: System.InvalidOperationException
Source File: System.Data
Stack Trace:
at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors
(RowUpdatingEventArgs rowUpdatedEvent, DataRow dataRow) at System.Data.
Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, 
DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at Administration_admin_LogMaintainence.BtnSave_Click(Object sender, EventArgs e) in d:\Trend\Control
Manager\WebUI\WebApp\Administration\admin_LogMaintainence.aspx.cs:line 196 
at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBack
vent
(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String eventArgument) at
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at
System.Web.UI.Page.ProcessRequestMain(Boolean 
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Details
Public

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
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1095305
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.