Showing posts with label trnsfer. Show all posts
Showing posts with label trnsfer. Show all posts

Friday, March 30, 2012

Multi Threading exception

Apologies if this is not the right forum.

We have some c~ code which calls a stored proc to trnsfer data from one db to another.

We are using multi threading to allow a whole days data to be processed in parrallel.


However, we are experiencing problems. After a while we get the following message:

"An exception during changed data captured caused all processing threads to abort".

Can anyone tell me what posssible reasons would cause this to happen?

It is not an area in which I have a lot of expertise, the code was written by a third party.

Many thanks

This is not an error message thrown by SQL Server (or the CLR), so it's likely one produced by the third-party code. You'll need to look at their code to see what actual error is happening to cause them to display this message.

Steven