CB Protection: Database Upgrade Fails Due to Query Cost

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Database upgrade fails due to query cost exceeding threshold.

Environment

• CB Protection Server: All Supported
• Microsoft SQL Server: All Supported

Cause

The database has the query governor enabled in the server connections options page.

Resolution

1. Open SQL Management Studio.
2. Right click on the SQL Server at the top of the explorer window and select "Properties".
3. Select the "Connections" tab.
4. Make one of the following changes to help address the issue:
   • Uncheck the box for "Use query governor to prevent long-running queries.
   • Increase the query governor threshold to a higher threshold.

Additional Information

Setting the threshold of the query governor to zero will disable the governor, similar to un-checking the box.