SQL Transaction is completed but it's no longer is usable

johanclasson / vso-agent-tasks

Build and Release Tasks for Visual Studio Online and Team Foundation Server

MIT License

20 stars 16 forks source link

SQL Transaction is completed but it's no longer is usable #66

Closed raochandansingh closed 4 years ago

raochandansingh commented 4 years ago

Hi,

Today I am getting one error while executing scripts using DBUp Migration tool. It seems all scripts are executed and also found in the journal table. When I re-executed, it's successfully done ( because all scripts skipped, found records of these into journal table)

Can you please help me to understand why this error is coming and causing this error.

johanclasson commented 4 years ago

Sorry no. But perhaps you can ask the folks over at DbUp? I am guessing it has nothing to do with this task due to the stack trace.

johanclasson commented 4 years ago

Can you try and use TransactionPerScript and see if that works?

johanclasson commented 4 years ago

Closing due to lack of activity...