License Limit Exceeded error returned for Reporter 9 and log processing has stopped
Getting an alert in Reporter 9 stating "License Limit Exceeded" and all log processing has stopped.
Error: ALERT raised: Licensed DB requests has reached or climbed above the 50000000 DB requests warning threshold -- currently 50871300 of 50000000 DB requests
Reporter 9 has stopped processing all my logs. How to get it to start processing my logs again?
Access log processing on Blue Coat Reporter 9 stopped. Why?
Reporter 9 stops processing log files
Reporter 9.x has three available licenses:
When navigating within the Reporter Management Console, go to Administration > System Overview > Reporter System Information > System Event Log. In the System Event Log there may be an event similar to the following message:
"ALERT raised: Licensed DB requests has reached or climbed above the 50000000 DB requests warning threshold -- currently 50871300 of 50000000 DB requests"
The use of the current value stated relative to the license limits shown above to give an idea which license to purchase. There may also be a way to be able to remedy the problem by simply limiting database log lines. This means expiring database data more frequently. So instead of keeping the last 30 days of data in the database, it means there may be need to keep only 20 days worth of data in the database.
Follow the steps below to expire records contained in the Reporter database:
NOTE: If there is a need to access expired data, it is possible to create a new database to reprocess the access logs for the pertinent dates, provided there has been saved access logs (this does not apply to the direct stream transfer method from the ProxySG to Reporter or if a post processing action of delete).
Upon completing these steps the log reader will not automatically start. To manually start the log reader, please do the following steps: