While deploying the package of Sql Change Automation in System Testing server through OCTOPUS deployment tool, we are getting the below error in Step (Redgate - Create Database Release).
We have created below Steps for Sql Change Automation deployment as suggested below link:
**Error: New-DatabaseReleaseArtifact : Cannot bind parameter ‘TransactionIsolationLevel’ to the target. Exception setting ** "TransactionIsolationLevel": "Object reference not set to an instance of an object."
Can you add the OctopusPrintEvaluatedVariables variable with a value of True to your project and create a new release and deploy that. Then send through the raw log from that deployment and an export of your Redgate - Create Database Release step template.
As suggested, I have added the OctopusPrintEvaluatedVariables variable with a value of True to my project.
I have attached the RAW log file. ServerTasks-23779.log.txt (361.6 KB)
Below screenshot is for Redgate - Create Database Release step template.
Could you try this for me, update the transaction level isolation from Serializable to any of the other values and save the step, then change it back to Serializable and save again and create a new release and deploy that.
I can’t find that value in the variables that were printed, which is odd as it should be available so am thinking that it might be an issue with the step template.
Looking at the error message (MigrationLogStateNotIdentical, description: Indicates that the state of two migration log tables are not the same.), it seems to indicate that the migration log tables between your source database (RMSCA) and the destination database (RM_SCA_TargetforTFS) don’t match.
As this is a RedGate specific error message, you might have a better chance of getting an answer to the issue using their forum.
15:09:22 Info | VERBOSE: Msg 15023, Level 16, State 1, Server IBLPN1B6RMDB01, Line 1
15:09:22 Info | VERBOSE: User, group, or role 'ITLINFOSYS\_TFSPROXY_TSG' already exists in the current database.
15:09:22 Info | WARNING: C:\Users\_TFSPROXY_TSG\AppData\Local\Temp\DLM
15:09:22 Info | Automation\1sgjpkhw.djp\Migrations\005_20180808-1322_Ayan-Biswas01.sql: An error occurred while attempting to deploy
15:09:22 Info | project scripts:
15:09:22 Info | WARNING: Msg 15023, Level 16, State 1, Server IBLPN1B6RMDB01, Line 1
15:09:22 Info | WARNING: User, group, or role 'ITLINFOSYS\_TFSPROXY_TSG' already exists in the current database.