Customer is unable to click on the Managed Datasource folder due to the "Timeout expired" error. You will run into this error if the size of the LiteSpeedCentral database is very large.
WORKAROUND:
This is a known issue and it is due to the size of the LiteSpeedCentral database just as you suspected. Development is aware of this and plans to add a feature to the product that will allow you to manage the amount of data kept in the activity logging databases. In the mean time, here is a script below which can be used to manually truncate the data:
Remove the constraint from the LiteSpeedCentral. [OR] LiteSpeedLocal..LitespeedBackupFile table. This can be done via Enterprise Manager or via script. The script would appear as follows:
ALTER TABLE dbo.LitespeedBackupFile
DROP CONSTRAINT FK_LitespeedBackupFile_LitespeedActivity
GO
ALTER TABLE dbo.LitespeedBackupFile WITH NOCHECK ADD CONSTRAINT
FK_LitespeedBackupFile_LitespeedActivity FOREIGN KEY
(
ServerName,
ActivityID
) REFERENCES dbo.LitespeedActivity
(
ServerName,
ActivityID
) ON DELETE CASCADE
GO
2. Then you can issue a simple deletion script. The example I have provided below removes files older than 1 day. This can be altered by changing the value within the DATEADD function.
DELETE
FROM LitespeedActivity
WHERE StartTime < DATEADD(dd, -1, getdate())
STATUS:
Waiting for fix in a future release of LiteSpeed for SQL Server.
