Fortinet black logo

Troubleshooting a custom dataset

Troubleshooting a custom dataset

This topic provides a list and an example of common issues in a custom dataset that cannot be identified by the dataset test console.

Common issues:
  • $filter is not applied.
  • No ### for inner query.
  • distinct is used in inner query.
  • No column alias for column with function.
  • no hcache merge for count distinct.
  • No group by or order by.
  • Log tables are not joined. For example, join traffic log with IPS log.
  • Dataset test console is out of memory.

The image below indicates where common issues may appear in the dataset:

Troubleshooting a custom dataset

This topic provides a list and an example of common issues in a custom dataset that cannot be identified by the dataset test console.

Common issues:
  • $filter is not applied.
  • No ### for inner query.
  • distinct is used in inner query.
  • No column alias for column with function.
  • no hcache merge for count distinct.
  • No group by or order by.
  • Log tables are not joined. For example, join traffic log with IPS log.
  • Dataset test console is out of memory.

The image below indicates where common issues may appear in the dataset: