Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Troubleshooting > Log Server and Log Database issues > More than 100 files in the Log Server cache directory
More than 100 files in the Log Server cache directory
Administrator Help | Forcepoint Web Security and Forcepoint URL Filtering | v8.5.x
Normally, Log Server ODBC cache files or BCP files are moved to the Log Database at a steady rate. If temporary files are accumulating on the Log Server machine, current Internet usage information is not being sent to the Log Database.
Log Server may be unable to process temporary files if:
*
*
*
*
*
*
*
*
To troubleshoot the problem:
*
Make sure Microsoft SQL Server is running (see Log Database is not available), and that no other processes that use significant resources, such as a full backup or antivirus scan, are running.
Also check the disk IO to verify that the machine is able to handle a fast insertion rate into the database.
*
See this article for a full list of certified versions.
*
If you are using SQL Server Enterprise or Standard, and the ETL job is not running, make sure the SQL Server Agent service is running on the machine.
If SQL Server Agent is running:
*
*
*
Locate the wse_etl_config table.
*
*
Change the value for max_buffer_size to 40000.
*
Use SQL Server Management Studio to verify that the Auto Growth option is enabled for the catalog database.
*
Go to the Web > Settings > Reporting > Log Database page in the Forcepoint Security Manager and verify that:
*
The File Path entries under Partition Management are valid.
*
*
1.
Go to the Web > Settings > Reporting > Log Server page in the Security Manager.
2.
Expand the Log Record Creation section.
3.
Select the ODBC (Open Database Connectivity) radio button.
4.
Click OK to cache your changes, then click Save and Deploy to implement them.
By default, ODBC cache files are created in the C:\Program Files\Websense\Web Security\bin\Cache directory.
*
The log (ldf) file for the database tempdb may be full. Restart the Microsoft SQL Server (MSSQLSERVER) services to clear the tempdb database.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Troubleshooting > Log Server and Log Database issues > More than 100 files in the Log Server cache directory
Copyright 2018 Forcepoint. All rights reserved.