Troubleshooting SQL test queries

If the SQL test is unsuccessful, an error message is displayed to indicate the cause of the problem in the query.

Following are some example error messages and possible causes:

ERROR: syntax error at or near...

• Check that SQL keywords are spelled correctly and that the query is well-formed. Table and column names are demarked by grave accent (`) characters. Single (') and double (") quotation marks will cause an error.

No Data

• The query is correctly formed, but no data has been logged for the specified log type. Check that you have configured and authorized a logging device of that type on the FortiAnalyzer.

You can click Format to automatically format the entered SQL query in a dataset, making it easier to read, update, and detect errors.