Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Troubleshooting > Investigative report and presentation report issues > Trend data is missing from the Log Database
Trend data is missing from the Log Database
Web Security Help | Web Security Solutions | Version 7.8.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 Security 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. See Configuring user permissions for Microsoft SQL Server and SQL Server Agent job.
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.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Troubleshooting > Investigative report and presentation report issues > Trend data is missing from the Log Database
Copyright 2016 Forcepoint LLC. All rights reserved.