August 14, 2017 at 8:14 pm
One of my table purging job is failing because of the below error :
Message
Executed as user: WINNTDOM\sqlserveragent. Error 50000, Level 16, State 1, Procedure sp_mt_throw_error, Line 34, Message: Error 21867, Level 16, State 1, Procedure sp_MStran_altertable, Line 275, Message: ALTER TABLE SWITCH statement failed. The table 'XXX' belongs to a publication which does not allow switching of partitions [SQLSTATE 42000] (Error 50000). NOTE: The step was retried the requested number of times (5) without succeeding. The step failed.
The same job is working fine for other similar instances . There is outgoing replication for this table to Informatica but the settings are same for other instances where the job is running fine . Any pointers would be useful to drill down the issue . Thanks in advance .
August 14, 2017 at 9:01 pm
table is a partitiontable and is having outgoing replication .
Allow_partition_switch was set to 0 . This has beenchanged to 1 .
After changing the job is running fine . Issue is fixed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply