-
Title
Error "cannot find a table or object" in Optimization step of LiteSpeed maintenance plan -
Description
Error "cannot find a table or object" in Optimization step of LiteSpeed maintenance plan created in LiteSpeed Enterprise Console
Cannot find a table or object with the name <tablename>". Check the system catalog.
However, if job step is created in SQL Server native maintenance plan, the plan completes without any error. -
Cause
Product Defect
-
Resolution
WORKAROUND:
Edit the job script of the Maintenance Plan. Modify the original script from calling "xp_slssqlmaint" to "xp_sqlmaint"
Example:
From
EXECUTE master.dbo.xp_slssqlmaint N'-PlanID 289D8935-A77F-4A56-B9D0-8D72D7C25E46 -Rpt "D:\REPORTS\rpt.txt" -DelTxtRpt 4WEEKS -WriteHistory -RebldIdx 100 '
Change to:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 289D8935-A77F-4A56-B9D0-8D72D7C25E46 -Rpt "D:\REPORTS\rpt.txt" -DelTxtRpt 4WEEKS -WriteHistory -RebldIdx 100 '
STATUS:
Waiting for fix in future release of LiteSpeed -
Defect ID
ST46827