Trend data is missing from the Log Database

Administrator Help | TRITON AP-WEB and Web Filter & Security | Version 8.0.x

Trend data is inserted into the Log Database first by the ETL job (which generates daily trend data) and then by the trend job (which generates weekly, monthly, and yearly tables). This data is then used in presentation trend reports.

If there is no trend data in your database, or some trend data is missing:

Verify that you have enabled trend data retention on the Settings > Reporting > Log Database page in the Web module of the TRITON Manager. The Store trend data check box (under Trend Data Retention) must be marked in order for any trend data to be generated and stored.

If you are using Microsoft SQL Server Standard or Enterprise, verify that the SQL Server Agent service is running, and that it is running as the correct user.

Use the Windows Services tool to verify that the SQL Server Agent service is running.

Verify that the ETL and trend database jobs are running.

The ETL job generates daily trend data, and the trend job runs on a nightly basis to generate weekly, monthly and yearly trend values. Use SQL Server Management Studio to verify that both jobs are running. If they're not, check for errors in the job history and restart or manually run the jobs. See Last successful ETL job ran more than 4 hours ago for additional information.