IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

Audit and Remediation: Creating New Query Fails With "Query is not valid SQL. Syntax error found near Identifier (SELECT Results Clause)"

Audit and Remediation: Creating New Query Fails With "Query is not valid SQL. Syntax error found near Identifier (SELECT Results Clause)"

Environment

  • Audit and Remediation (formerly LiveQuery): All Supported Versions

Symptoms

Getting error when trying to save a query "Query is not valid SQL. Syntax error found near Identifier (SELECT Results Clause)"

Cause

This can happen if the SQL Query syntax is wrong, like adding extra special characters

Resolution

Make sure that there are no duplicate or extra characters in the query

Related Content


Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-09-2020
Views:
432
Contributors