Solutions

License Limit Exceeded error returned for Reporter 9 and log processing has stopped

Solutions ID:    KB3010
Version:    4.0
Status:    Published
Published date:    06/30/2009
Updated:    10/17/2013
 

Problem Description

License Limit Exceeded error returned for Reporter 9 and log processing has stopped
You are 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 do I get it to start processing my logs again?
Access log processing on Blue Coat Reporter 9 stopped.  Why?
Reporter 9 stops processing log files

Resolution

Reporter 9.x has three available licenses:

  • Standard (default) - Installing and running Reporter requires no license; however, the default mode (also known as the Standard License) limits log processing to 50 million concurrent log lines. If log processing reaches this limit, Reporter halts processing until lines are removed from the databases (or you install a higher level license).
  • Enterprise - Purchasing and installing an Enterprise License enables Reporter to process up to 2.5 billion concurrent log lines.
  • Premium - Purchasing and installing an Premium License enables Reporter to process up to 20 billion log lines.


When navigating within the Reporter Management Console, go to Administration > System Overview > Reporter System Information > System Event Log.  In the System Event Log you may see 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"

You can use the current value stated relative to the license limits shown above to give you an idea which license to purchase.  You may also 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 you may need to keep only 20 days worth of data in the database.

Follow the steps below to expire records contained in the Reporter database:

  1. Navigate to Administration > General Settings > Reporter Settings > Data Settings > Databases
  2. From the database(s) in question, click on the Actions drop-down arrow and select "Set Expiration".
  3. Ensure that a check is placed in the box for "Expire database data older than".
  4. Enter a value for the amount of days (Blue Coat's recommendation is 30-60 days but a lower value may be needed).
  5. Set the Frequency (default is daily - Keep in mind that if you use weekly or monthly, your database data will exceed the number of days set for that duration).
  6. Set the execution time. By default, Reporter will expire data at 12:00 am. If you do not want to wait until the default execution time, kindly change the execution time accordingly.
  7. Click Save.
  8. If you have multiple databases, repeat steps 2 to 6 for each database.


NOTE
:  If there is a need to access expired data, you can create a new database to reprocess the access logs for the pertinent dates, provided you have saved the access logs (this does not apply to the direct stream transfer method from the ProxySG to Reporter or if you have 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:

  1. Navigate to Administration > General Settings > Reporter Settings > Data Settings > Log Sources
  2. From the log source(s) in question, click on the Actions drop-down arrow and select "Start Log Source".

Rate this Page

Please take a moment to complete this form to help us better serve you.

Did this document help answer your question?
 
 
If you are finished providing feedback, please click the RATE CONTENT button. Otherwise, please add more detail in the following text box and then click RATE CONTENT.
 
 

Your response will be used to improve our document content.

Ask a Question