Return
-
Title
LiteSpeed Delete Activity not deleting records from Central Database -
Description
When trying to delete records of the LiteSpeed Central database using the LiteSpeed_DeleteActivity store procedure like this:
exec [LiteSpeedCentral]..[LiteSpeed_DeleteActivity] @delCentral=1, @purgeDeleted=1, @delLogshipping=1, @delStatus=1, @delUnit=3, @delUnitType='MONTHS'
Even with different parameters, is completed instantly without deleting any records. This can also happen with the LiteSpeedLocal database. -
Cause
The most probable issue is that the LiteSpeed store procedures are not registered correctly in the server where the LiteSpeed database is hosted, either the Central or the Local database. -
Resolution
Run the LiteSpeed Instance Configuration Wizard, in the third step (SQL Instances) in the action section select Uninstall in for the SQL Server instance where the Central database is hosted and complete the wizard.
After completing the uninstall, do the same thing but selecting the install process in the third step to re-register the LiteSpeed store procedures.
