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 .