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.
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
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