Troubleshooting Tip: Unable to save Chart Builder

Description

This article describes how to troubleshoot issues where the Chart Builder does not save, and throws a 'Cannot read properties of undefined (reading 'sql')' error.

Scope

FortiAnalyzer.

Solution

To identify the cause of the error, enable browser debugging (Developer Tools for Chrome) and select Preview from the Chart Builder.

The error explains that the URI is too long to query, and there is no SQL query present in the Chart Builder.

To fix this issue, change the Log View page view to 50 or 100.

Proceed to run the Chart Builder again. It will save it into the Dataset.

Related article: 

Technical Tip: How to build a custom report on FortiAnalyzer using Chart Builder