Unhandled Exception occurred during processing


 Product(s):SELECTserver
 Version(s):N/A 
 Environment:N/A
 Area:Administration
 Subarea:Nightly Processing

Error or Warning Message

The Message Center displays the following error message several days in a row for the Usage Log Processing task:

Unhandled Exception occurred during processing

Upon examining the SS-UsageLogProcessingService.log file in C:\Program Files\Bentley\SELECTserver\Logs, the following error string is found multiple times:

ERROR - Shared -   System.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object

Explanation

The license database used by SELECTserver has reached the maximum size permitted by an instance of SQL Server Express. All versions of SELECTserver include an Express edition of Microsoft SQL Server which imposes either a 4 GB (SQL Server 2005) or 10 GB (SQL Server 2008) limit. The error indicates that no further data can be written to the database unless some existing data is removed first.

How to Avoid

Option 1: Create a new license database

If historical usage data is not needed, the easiest and most straightforward solution is to simply create a new license database.

Option 2: Adjust the Data Retention settings

For users of SELECTserver 09.00.xx.xxx, a Data Retention setting can be adjusted to remove old usage data and reduce the size of the database. Use the following steps:

  1. Open the SELECTserver administration site.
  2. Choose Server Settings from the Administration drop-down menu along the top edge.
  3. Locate the Data Retention setting at the very bottom.
  4. Ensure that Data Retention is enabled, and adjust the timeframe as needed.
  5. Choose Manage Services from the Administration drop-down menu along the top edge.
  6. Locate the SELECTserver Tasks section.
  7. Click on the Run Now button next to Usage Log Processing to apply the new Data Retention settings.

Option 3: Move the database to a Standard or Enterprise edition of SQL Server

Standard or Enterprise editions of SQL Server impose a much higher maximum limit to databases. Administrators that have access to one of these editions which requires a license from Microsoft, can move the license database and reconfigure the SELECTserver Database Setup utility to use it in its new location.

Option 4: Migrate to Bentley CONNECT SELECTservices

Bentley offers a free online licensing solution that eliminates the need to handle database administration issues like this. The following FAQ provides more information about this licensing option.

 Original Author:Jeremy Hoesly