-
Title
LiteSpeed Rebuild Index Task fails when run on LiteSpeedLocal table -
Description
When included in a LiteSpeed Maintenance Plan, Rebuild Index Task fails when run on LiteSpeedLocal table
-
Cause
Defect
-
Resolution
WORKAROUND:
Remove the "IGNORE_DUP_KEY" parameter from the t-sql. See attached script.STATUS: CR84934 is open with Development. Fixed in a future version of LiteSpeed.
-
Defect ID
CR84934 -
Attachments
-
Additional Information
Failure messages may be similar to:
Cannot find a table or object with the name "[dbo].[DbMaintStatus] ". Check the system catalog.
Msg 1979, Level 16, State 1, Line 1
Cannot use index option ignore_dup_key to alter index 'PK_DbMaintStatus' as it enforces a primary or unique constraint.
Msg 1915, Level 16, State 1, Line 1
Cannot alter a non-unique index with ignore_dup_key index option. Index '_dta_index_DTSStatus_endtime' is non-unique.
Msg 1979, Level 16, State 1, Line 1
Cannot use index option ignore_dup_key to alter index 'PK_DTSStatus' as it enforces a primary or unique constraint.
Msg 1915, Level 16, State 1, Line 1
Cannot alter a non-unique index with ignore_dup_key index option. Index '_dta_index_JobStatus_runtime' is non-unique.
Msg 1979, Level 16, State 1, Line 1
Cannot use index option ignore_dup_key to alter index 'PK_JobStatus' as it enforces a primary or unique constraint.
Msg 1915, Level 16, State 1, Line 1
Cannot alter a non-unique index with ignore_dup_key index option. Index '_dta_index_LitespeedActivity_11_1977058079__K1_K4_K7_K5_K3' is non-unique.