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)

    • Updated:
    • 19 Jan 2016
    • Product/Version:
    • Control Manager 6.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
Summary

When modifying the TMCM 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.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

A missing primary key in the TMCM database causes the error.

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

  1. Stop the following TMCM services:
    • Trend Micro Management Infrastructure
    • Trend Micro Common CGI
    • 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 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.


Need More Help?

Create a technical support case if you need further support.