Description
This error occurs because of the Transaction Isolation Level.
By default DLM Automation uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Level of Read Committed.
Workarounds
There are two alternate solutions to this issue:
1 - Use the -TransactionIsolationLevel parameter on the cmdlet (or equivalent option on the add-on) and set it to ReadCommitted
2 - Use the NoTransactions SQL Compare option
https://documentation.red-gate.com/sc13/using-the-command-line/options-used-in-the-command-line#Optionsusedinthecommandline-NoTransactions
Please note that when using NoTransactions the deployment will not be rolled back in case of error, so if you use this option it's advisable to backup first