Troubleshooting Tip: Specific Reports Cannot be Generated
| Description | This article describes the troubleshooting steps when certain/specific reports cannot be generated, either via schedule, manual generation, or CLI. |
| Scope | FortiAnalyzer. |
| Solution | The following issue may happen in FortiAnalyzer, where only certain reports cannot be generated:
This might be due to unsupported SQL functions/methods being used in the dataset. In the example below, the type cast using double colon (::) is not supported. The validation will also show an error:
The custom dataset will need to be revised to exclude the unsupported functions or use an equivalent function/method that is supported. In the example, the double colon can be changed to the function CAST(), which can also be used to perform a type cast:
Once the validation shows that there are no issues found, the report should be able to be generated:
Related articles: Troubleshooting Tip: Report Generation Issues on FortiAnalyzerTroubleshooting Tip: Dataset query error due to database changes in FortiAnalyzer v7.6 |
