I have Transactional replication in one environment, I disable existing one and configuring it again, But While initialization in am getting following error

Distributor Subsystem: Cannot continue the execution because the session is in the kill state.

Same was working before with out any issues.

Can some onle help me on this?

  • What does your replication monitor say? – Arthur D Nov 2 '16 at 13:59
  • In Replication Monitor after all primary keys and Index are applied, that is at end of initialization it shows this error message 'Cannot continue the execution because the session is in the kill state' and starts to reinitialize again. – Raja Nov 2 '16 at 14:24
  • When I tried to see the commands using SP_Browsereplcmds with the trans_seqno it shows as SYNCSTAT. – Raja Nov 2 '16 at 14:26
  • In ran profiler for it error is displayed after 'if object_id(N'sys.sp_MSrestoresavedforeignkeys','p')<0 Exec sys.sp_MSrestoresavedforeignkeys if @@trancount > 0 rollback tram' – Raja Nov 2 '16 at 15:04

I got the same issue on Replication, server restart resolved the problem.

|improve this answer|||||

Issue is resolved as of now. Just rebooting the server solved the problem.


|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.