VSTS Database Dacpac release has failure when deploying the package, but the deployment status said succeed -
vsts database dacpac release has failure when deploying package, deployment status said succeed.
is there way fix can see deployment fails @ status?right if don't @ log, think deployment good.
below see in release log, deployment status still succeed:
2016-08-23t21:24:52.2672666z analyzing deployment plan (complete)
2016-08-23t21:24:52.2682666z updating database (start)
2016-08-23t21:24:56.1344991z error occurred while batch being executed.
2016-08-23t21:24:56.1435001z updating database (failed)
2016-08-23t21:24:56.1575000z *** not deploy package.
2016-08-23t21:24:56.1575000z warning sql72015: type column principalinvestigator in table [dbo].[study] nvarchar (120) null being changed nvarchar (60) null. data loss occur.
2016-08-23t21:24:56.1575000z error sql72014: .net sqlclient data provider: msg 50000, level 16, state 127, line 6 rows detected. schema update terminating because data loss might occur.
2016-08-23t21:24:56.1575000z error sql72045: script execution error.
in 'project settings', under 'debug', unselect 'block incremental deployment if data loss might occur' , save it, execute successfully.
but if converting nvarchar(120) nvarchar(60) end in data loss.
Comments
Post a Comment