vibhasjog ,

Please check if you are using transaction in this step in case you don't have your linked server configured for this.