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
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.
If historical usage data is not needed, the easiest and most straightforward solution is to simply create a new license database.
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:
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.
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.