Prev: 401.3 Error on Reports folder
Next: EXECUTE permission denied on object 'xp_sqlagent_notify'
From: SQL Question SQL on 16 Oct 2006 15:37
I'm running into some blocking issues and Timeouts in the ReportServerTempdb.

Portions of the errors in the logs are below. At this time there is an
apGetSessionData stored procedure that is blocking. Any suggestions on
tuning for this installation?

w3wp!runningjobs!7!10/16/2006-09:29:26:: i INFO: Adding: 1 running jobs to
the database
w3wp!dbcleanup!7!10/16/2006-09:33:56:: e ERROR: Sql Error in
CleanOrphanedSnapshots: System.Data.SqlClient.SqlException: Timeout expired.
w3wp!library!7!10/16/2006-09:33:56:: i INFO: Cleaned 0 batch records, 0
policies, 2 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs,
0 persisted streams
w3wp!dbcleanup!d!10/16/2006-09:43:56:: e ERROR: Sql Error in
CleanOrphanedSnapshots: System.Data.SqlClient.SqlException: Timeout expired.
w3wp!session!7!10/16/2006-09:48:12:: e ERROR: Sql Error in GetSnapshotData:
System.Data.SqlClient.SqlException: Timeout expired.
w3wp!library!7!10/16/2006-09:48:12:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. ---> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.


 | 
Pages: 1
Prev: 401.3 Error on Reports folder
Next: EXECUTE permission denied on object 'xp_sqlagent_notify'