The Message Center on the SELECTserver administration site periodically displays Usage Log Processing failures with the following message:Error Truncating Usage Data
SELECTserver 9 introduced a Data Retention feature that can remove old usage data after a certain time period, limiting the growth of a license database. However, this feature has proven ineffective, producing truncation errors when invoked during usage log processing instead. While the errors do not affect the operation of SELECTserver itself, they indicate that the removal of old usage data failed.
For users comfortable with database management, a SQL script is available that can be applied to the license database itself to correct the feature by performing the following steps:
For those uncomfortable with database management, the error can be avoided by simply turning off the Data Retention feature by performing the following steps: