LiteSpeed_GatherJobStatistics is blocking other processes.
Error may display:
The session is being run on database [msdb] with application name 'SLSSQLMaint - LiteSpeed engine' by user 'SERVERS\SqlServices' on host 'Instance_name1'.
Last command issued: exec LiteSpeed_GatherJobStatistics
WORKAROUND 1:
First run the following:
UseLiteSpeedLocal
Go
ExecLiteSpeed_ImportNativeHistory
Go
Output:
Msg 515, Level 16, State 2, Procedure LiteSpeed_InsertUpdateDatabaseActivity, Line 57
Cannot insert the value NULL into column 'DatabaseID', table 'LiteSpeedLocal.dbo.LitespeedActivity'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 547, Level 16, State 0, Procedure LiteSpeed_InsertUpdateBackupFile, Line 14
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LitespeedBackupFile_LitespeedActivity". The conflict occurred in database "LiteSpeedLocal", table "dbo.LitespeedActivity".
The statement has been terminated.
Run this again:
UseLiteSpeedLocal
Go
ExecLiteSpeed_ImportNativeHistory
Go
Output:
Command(s) completed successfully.
WORKAROUND 2:
To disable the LiteSpeed_GatherJobStatistics we can rerun the Instance Configuration and select "Do not configure activity logging at this time". This setting will allow the LiteSpeed backups, restores, maintenance plans, etc. but will not utilize the LiteSpeed Activity Service, which is what calls the LiteSpeed_GatherJobStatistics stored procedure.
STATUS: Fixed in Version 7.x of LiteSpeed.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center