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

Popular posts from this blog

mysql - Dreamhost PyCharm Django Python 3 Launching a Site -

java - Sending SMS with SMSLib and Web Services -

java - How to resolve The method toString() in the type Object is not applicable for the arguments (InputStream) -