Audit and Remediation: Query Fails With Error "Constraint failed"
search cancel

Audit and Remediation: Query Fails With Error "Constraint failed"

book

Article ID: 289230

calendar_today

Updated On:

Products

Carbon Black Cloud Enterprise EDR (formerly Cb Threathunter)

Issue/Introduction

Running a live query fails with errorĀ "Constraint failed"

Environment

  • Carbon Black Cloud Console: All Supported Versions

Cause

This happens if one of the SELECT commands requires a WHERE clause to go with it

Resolution

Add a WHERE clause which references the SELECT statement

Additional Information

One example of this is the hash table which requires a path or directory WHERE statement