My database shows a status of "corrupt" or "error" and I cannot run reports.
This article only applies to Reporter 9.x
Find the database you need to modify by going to administration > system overview and scrolling down to the bottom of this page. Here you'll see a list of database names and their corresponding folder names and locations.
Stop the Reporter service
This can be done from the GUI in Administration > General Settings > SHUT DOWN/RESTART. Select 'Shut Down Reporter'
The service can also be stopped manually:
Linux: Run the command: sudo service bcreporter stop Some older versions of Red Hat/CentOS may require the command: sudo /etc/init.d/bcreporter stop
Windows: Bring up the 'Services' window (services.msc) Right-click the "Blue Coat Reporter 9" service and select 'stop'
Go to the Database location you found in step one, and delete everything in this folder, but not the folder itself.
Create new directories
Once all files are deleted, create the following new directories. Create a directory called: main create a directory called: video NOTE: The directory names MUST be all lower case
(Optional) Prepare archived access logs for reprocessing
If logs are renamed (.done):
Windows: Open CMD and run as Administrator
Navigate to the directory that contains the log files
To remove the .done extension from all log files in the directory, run this command: ren *.done *.
Linux: Navigate to the directory that contains the log files
To remove the .done extension from all log files in the directory, run this command: for i in `ls | grep '\.done$'`; do mv $i `echo $i | sed -e 's/\.done$//g'`; done
If the logs are moved after processing:
If the logs are moved to a different directory for post processing, you can move those back to the log source directory
Start the Reporter service
Linux: Run the command: sudo service bcreporter start Some older versions of Red Hat/CentOS may require the command: sudo /etc/init.d/bcreporter start
Windows: Bring up the 'Services' window (services.msc) Right-click the "Blue Coat Reporter 9" service and select 'start'
Upon startup, Reporter should now be processing archived logs back into the database.
Imported Document ID: 000010417
Subscribing will provide email updates when this Article is updated. Login is required.