Upgrading when the database server times out during upgrade of rs_activity_log table

Use this procedure when you encounter a timout error during a database upgrade.

About this task

During the upgrade of the rs_activity_log table in the DC_SYSTEM database, you may receive a timeout error similar to the following:


4/8/2010 9:04:40 AM    DC_SYSTEM     ERROR    There was an error executing
   the command list.
Timeout expired.  The timeout period elapsed prior to completion of
   the operation or the server is not responding.
At statement: --Move all the 'DocumentsFound' attribute values into the
   new REPORT_VALUE column to make them reportable/chartable in the Portal

This database table contains the user activity logs from the Portal.

You may want to review the rs_activity_log table to identify if the data should be preserved or not.

To fix this issue:

Procedure

  1. Back up the contents of the rs_activity_log, if you want to preserve it for auditing purposes.
  2. You can do either of the following:
    1. Increase the SQL Server timeout setting for the Discover databases.
    2. Clear the rs_activity_log database.