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

Create a technical support case if you need further support.

"Unable to complete the operation due to SQL logic error" in Deep Security

    • Updated:
    • 16 Oct 2019
    • Product/Version:
    • Deep Security 11.0
    • Deep Security 12.0
    • Platform:
    • N/A
Summary

The following error is encountered in Deep Security:

Unable to complete the operation due to SQL logic error[1]: no such table: DatabaseInfo

The agent also shows the following warning message and details on the console:

Event ID: 728
Event: Get Events Failed
Target: server00.lgb.group
Event Origin: Agent
Action By: System
Manager: PRODTMDEEPSEC.lgb.group

Details
Public

This may occur when the agent itself cannot find the table information from the local database use by Log Inspection, resulting to Get Events failed warning (absent log inspection events) from the agent status. This happens when the local database becomes corrupted.

To resolve this:

  1. Reset the agent then delete all Log Inception components (while DS Agent service is stopped).
  2. Restart and activate the agent. Everything should be restored including the local Log Inspection database file (lca.db).
  3. Check if events are being delivered to the DS Manager to confirm if the local Log Inspection database is working fine.
Premium
Internal
Rating:
Category:
Solution Id:
000149883
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.