App Control: Getting Events: Error Processing host[hostId] ERROR_MESSAGE:Incorrect syntax near '-'.

[#1]

Environment

• App Control Server: 8.7 and Higher

Symptoms

After upgrading to 8.7.0 App Control Server, start receiving thousand of the following Events:

• Subtype: Server Error
• Description: 

  Error Processing host[hostId] ERROR_MESSAGE:Incorrect syntax near '-'.

Cause

This behavior is being reviewed by VMware Carbon Black: EA-19858

Resolution

1. Login to the App Control database server
2. Confirm there is a recent full backup of the das database
3. Open a Support Ticket to Request Fix870CloneThread.sql script
4. After the script is received go to - https://APPCSERVER/Support.php > Scheduled Task tab > Confirm ProcessFileInstancesClones task is enabled
5. Stop the CB App Control Reporter Service
6. Open SQL Mgmt Studio and run the hotfix > Fix870CloneThread.sql
7. Start CB App Control Reporter Service

Additional Notes

• In some cases the Server Backlog is increasing due to events amount caused by this issue
• This issue is only affecting Virtual Machines Environment