VSTS Extension 'remote_data_archive_migration_state'
dtv
Posts: 7
Hi,
First, I am using the SQL Release VSTS Extension with an Azure v12 database.
Same issue as before with the SQL CI VSTS Extension I ran into.
Question:
How/when can I expect the recent updates to be applied to this extension? Is it no longer supported?
I know that the DLM Automation Suite 1.3.20.463 was updated with the fix from SQL Compare 11.5.0.397, which I have confirmed works when I run SQL Compare by itself. However, I've been looking around to see how I could (if it is even possible) to update the SQL Release VSTS extension. The operations does not appear to be working anymore. The last update to this extension according to the Marketplace was 12/22/2015.
2016-03-30T01:30:59.9827962Z ##[debug]Calling: C:LRMMSServicesMmsTaskAgentProvisionerToolsagents1.97.1 asksRedgateSqlRelease1.0.1SCSQLCompare.exe /server1:tcp:REMOVED.database.windows.net /database1:REMOVED /username1:REMOVED /password1:******** "/makescripts:C:UsersuildguestAppDataLocalTempSQL Releasefpf3g3co.lax" /force /options:DecryptPost2kEncryptedObjects,IncludeDependencies /OutputWidth:1024 /out:"C:UsersuildguestAppDataLocalTempSQL Releaseabez2lpm.log"
2016-03-30T01:31:03.3062164Z ##[debug]C:LRMMSServicesMmsTaskAgentProvisionerToolsagents1.97.1 asksRedgateSqlRelease1.0.1SCSQLCompare.exe ended with exit code 126
2016-03-30T01:31:03.3654003Z ##[error]SQLCompare.exe terminated with the exit code 126: Failed due to a SQL Server error.
2016-03-30T01:31:03.3664022Z ##[error]SQLCompare.exe produced this error output:
2016-03-30T01:31:03.3664022Z ##[error]Error: Error occurred connecting to database: Invalid column name 'remote_data_archive_migration_state'.
2016-03-30T01:31:03.4065625Z Finishing task: RedgateSqlRelease
2016-03-30T01:31:03.4305557Z ##[error]Task RedgateSqlRelease failed. This caused the job to fail. Look at the logs for the task for more details.
First, I am using the SQL Release VSTS Extension with an Azure v12 database.
Same issue as before with the SQL CI VSTS Extension I ran into.
Question:
How/when can I expect the recent updates to be applied to this extension? Is it no longer supported?
I know that the DLM Automation Suite 1.3.20.463 was updated with the fix from SQL Compare 11.5.0.397, which I have confirmed works when I run SQL Compare by itself. However, I've been looking around to see how I could (if it is even possible) to update the SQL Release VSTS extension. The operations does not appear to be working anymore. The last update to this extension according to the Marketplace was 12/22/2015.
2016-03-30T01:30:59.9827962Z ##[debug]Calling: C:LRMMSServicesMmsTaskAgentProvisionerToolsagents1.97.1 asksRedgateSqlRelease1.0.1SCSQLCompare.exe /server1:tcp:REMOVED.database.windows.net /database1:REMOVED /username1:REMOVED /password1:******** "/makescripts:C:UsersuildguestAppDataLocalTempSQL Releasefpf3g3co.lax" /force /options:DecryptPost2kEncryptedObjects,IncludeDependencies /OutputWidth:1024 /out:"C:UsersuildguestAppDataLocalTempSQL Releaseabez2lpm.log"
2016-03-30T01:31:03.3062164Z ##[debug]C:LRMMSServicesMmsTaskAgentProvisionerToolsagents1.97.1 asksRedgateSqlRelease1.0.1SCSQLCompare.exe ended with exit code 126
2016-03-30T01:31:03.3654003Z ##[error]SQLCompare.exe terminated with the exit code 126: Failed due to a SQL Server error.
2016-03-30T01:31:03.3664022Z ##[error]SQLCompare.exe produced this error output:
2016-03-30T01:31:03.3664022Z ##[error]Error: Error occurred connecting to database: Invalid column name 'remote_data_archive_migration_state'.
2016-03-30T01:31:03.4065625Z Finishing task: RedgateSqlRelease
2016-03-30T01:31:03.4305557Z ##[error]Task RedgateSqlRelease failed. This caused the job to fail. Look at the logs for the task for more details.
Comments
We have just released the latest version of SQL Release to the VSTS plugin. This includes SQL Compare 11.5.2 which fixes the Azure v12 issue.
Software Engineer
Redgate Software