We do custom reports on traffic usage using FortiAnalyzer (v5.2.4). Our custom reports looks as expected if generated for a time period of two week. However if I choose a longer time period (e.g. 30 days) some of the graphics in the report are empty ("No matching log data for this report"). The behavior is not always the same. Sometimes the graphics are in the report, sometimes not.
Further if we try to execute the corresponding sql query (e.g. for a time period of 30 days) via command line ("execute sql-query-dataset ...") we get the following error:
Command fail. Return code 1
What can we do to further debug this situation? Is there a possibility to get more information about this "Internal error"?