Create fact tables to debug analytics update errors

Home Analytics & Reporting Search analytics

Managed by | Updated 5 years ago.

Background

The analytics system produces a number of temporary files during an analytics build. Sometimes a report build will fail reporting errors in these files. This article shows the steps required to preserve the files for use in debugging.

How to preserve the .fact files

edit the collection.cfg for the affected collection and add:
```
java_options=-DDONT_DELETE_FACT_TABLES_ON_EXIT=1
```
Run an update of the analytics (note: a full update with analytics.reports.disable_incremental_reporting=true is probably a good idea)
Examine the .facts files that are written to $SEARCH_HOME/admin/reports/COLLECTION_NAME/
Remove the java_options once you've finished debugging.