This is typically an error with the recorder query timing out. You may want to look at tuning options on the database to try to increase performance. What you can do is turn up logging on the recorder server subsystem and run the query. From the log you can see the SQL query that is ran in the background. You can use SQL server management studio to analyze the query and look at potential optimization options.