Octopus Deploy ShadowServer properties

Sean_Lively

I'm using the latest available Redgate - Create Database Release step template in Octopus deploy, and I'm getting a "A deployment preview report could not be generated" message in changes.html. Looks like the ShadowServer properties are not exposed on the step template? 

jackdewinter

Is this on your first deployment? This message appears for empty reports.

Sean_Lively

This is not the first deployment. 

Sean_Lively

WARNING: C:\Windows\TEMP\DLM Automation\4cbf3sqa.5cl\PrimeReporting.sqlproj: No 

schema snapshot could be retrieved from the target database; no report will be 

generated until your next deployment. If you continue to see this message,  

then it is possible that a schema snapshot file is not being created during  

build. To resolve, specify the ShadowServer property in your build  

configuration. See https://www.red-gate.com/sca/continuous-integration 

jackdewinter

Sorry, I meant is this your first deployment to this database? After a deployment a migration log and a schema snapshot should be in your target database. In this scenario it looks like there isn't a schema snapshot in the target database that you are deploying to.

Sean_Lively

It's not the first deployment to this database, both __MigrationLog and __SchemaSnapshot exist in the database and have data in them.