Activity overview
Latest activity by PatIrvin
How do I set Redgate change automation build to not use transactions - AWS deploy issue
I have a pipeline in azure devops which uses Redgate change automation
and receives the following error with linked server when release runs -
2020-08-20T21:29:01.4937371Z The database update fai...
I have a pipeline in azure devops which uses Redgate change automation and receives the following error with linked server when release runs - System.Management.Automation.CmdletInvocationException: Applying update script failed: The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "XXXXXXXXXX" was unable to begin a distributed transaction.
LegacyVSTSPowerShellHost.exe completed with return code: -1.
I have tried changing the transaction isolation level to Read Uncommitted in the build but same error.
How do I set it to no transactions from the gui?
/ comments
I have a pipeline in azure devops which uses Redgate change automation and receives the following error with linked server when release runs - System.Management.Automation.CmdletInvocationException...
If running change automation from azure devops using an agent installed on server what steps do I need to take to ensure I have the latest SCA Powershell module? Thanks! / comments
If running change automation from azure devops using an agent installed on server what steps do I need to take to ensure I have the latest SCA Powershell module? Thanks!
I get the following error on my latest release using continuous automation to deploy package.
Nothing that I am aware of has changed from previously successful releases. this is an agent job in azure devops release. The specified value for the Source parameter is neither a valid database ...