Error: Transaction context in use by another session
vincentj
Posts: 47
Hi,
I can't get the synchronization wizard to work at all. First I was getting the error: "MSDTC on server 'blah' is unavailable". So I went into services and enabled the Distributed Transaction Coordinator service, and now I always get the error "Transaction context in use by another session."
The only way that I've found to get around this is to modify the script by hand and change the isolation level to READ COMMITTED. Eventually I plan on using this tool to automate our database deployments so I need to get it working without manual intervention. Is there a configuration option somewhere that I can change to fix this problem? Thanks.
This error was present in the previous version also (8.5).
I can't get the synchronization wizard to work at all. First I was getting the error: "MSDTC on server 'blah' is unavailable". So I went into services and enabled the Distributed Transaction Coordinator service, and now I always get the error "Transaction context in use by another session."
The only way that I've found to get around this is to modify the script by hand and change the isolation level to READ COMMITTED. Eventually I plan on using this tool to automate our database deployments so I need to get it working without manual intervention. Is there a configuration option somewhere that I can change to fix this problem? Thanks.
This error was present in the previous version also (8.5).
Comments
If so, this is a known issue, and we have an existing enhancement request to provide an option for setting the transaction isolation level to use in your scripts (ref. SC-1318)
Redgate Software
Redgate Software
Please visit http://www.red-gate.com/MessageBoard/vi ... 1312#51312 for more information.
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software