VSTS: Deploy Azure SQL DACPAC Release Management throwing an error -

-

i trying setup vsts release management azure sql database. using "deploy azure sql dacpac" task. path dacpac file setup 

$(system.defaultworkingdirectory)\**\*.dacpac

while database updates correctly error in end causes task fail.

"system.management.automation.parentcontainserrorrecordexception: *** not deploy package"

it looks updates applied database task still throws error. log below

2016-07-07t07:50:44.6118522z publishing database 'mydb' on server 'myserver.database.windows.net'. 2016-07-07t07:50:45.7587428z initializing deployment (start) 2016-07-07t07:50:52.5825349z initializing deployment (complete) 2016-07-07t07:50:52.5835341z analyzing deployment plan (start) 2016-07-07t07:50:52.7085342z analyzing deployment plan (complete) 2016-07-07t07:50:52.7085342z updating database (start) 2016-07-07t07:50:53.7000358z altering [dbo].[usp_products_list]... 2016-07-07t07:50:53.7170379z creating [dbo].[usp_products_getbyid]... 2016-07-07t07:50:53.8745919z error occurred while batch being executed. 2016-07-07t07:50:53.8855912z updating database (failed) 2016-07-07t07:50:53.9105905z ##[debug]system.management.automation.remoteexception: *** not deploy package. 2016-07-07t07:50:53.9225921z ##[debug][azure rdfe call] deleting firewall rule 260745ad-327c-45ae-bcb8-5c6bb0e43797 on azure database server: myserver 2016-07-07t07:50:55.9753040z ##[debug][azure rdfe call] firewall rule 260745ad-327c-45ae-bcb8-5c6bb0e43797 deleted on azure database server: myserver 2016-07-07t07:50:55.9934761z ##[error]system.management.automation.parentcontainserrorrecordexception: *** not deploy package.

stored procedure code

create procedure [dbo].[usp_products_getbyid]     @pid int     set nocount on;  select [id]       ,[description]       ,[created_dt]       ,[last_mod_dt]       ,[active]   [dbo].[products]   [id] = @pid go

in particular case, error happened because in database project, in 1 of init scripts table, trying set identity specification non-numeric column.

so, check scripts run without errors (using sql management studio or visual studio) if other solutions don't work.

too bad error in vsts doesn't capture sql error...


Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor
Read more

android - Robolectric "INTERNET permission is required" -

-
i'm getting error when create activity robolectric: java.lang.illegalargumentexception: internet permission required. this i'm doing: @config(constants = buildconfig.class, sdk = testconfig.min_sdk_unit_tests, manifest = "src/main/androidmanifest.xml") @runwith(robolectricgradletestrunner.class) public class atest { @test public void testtrackdonotaskmeagainselected() throws exception { final anactivity activity = robolectric.buildactivity(anactivity.class).create().get(); } update 1: our current setup, have manifests: app/src/androidtest/androidmanifest.xml app/src/debug/androidmanifest.xml app/src/main/androidmanifest.xml app/src/test/androidmanifest.xml i found debug executed instead of test , that's why permission in app/src/test/androidmanifest.xml ignored. add manifest: <uses-permission android:name="android.permission.internet" />
Read more

java - Android raising EPERM (Operation not permitted) when attempting to send UDP packet after network connection -

-
when responding supplicant_state_changed_action broadcast , attempting send udp packet, exception: java.net.socketexception: sendto failed: eperm (operation not permitted) @ libcore.io.iobridge.maybethrowaftersendto(iobridge.java:542) @ libcore.io.iobridge.sendto(iobridge.java:511) @ java.net.plaindatagramsocketimpl.send(plaindatagramsocketimpl.java:184) @ java.net.datagramsocket.send(datagramsocket.java:305) @ com.mycompany.app.serviceclass.discover(serviceclass.java:355)at com.mycompany.app.serviceclass.access$600(serviceclass.java:39) @ com.mycompany.app.serviceclass$statemachine.run(serviceclass.java:242) @ java.lang.thread.run(thread.java:818) caused by: android.system.errnoexception: sendto failed: eperm (operation not permitted) @ libcore.io.posix.sendtobytes(native method) @ libcore.io.posix.sendto(posix.java:211) @ libcore.io.blockguardos.sendto(blockguardos.java:278) @ libcore.io.iobridge.sendto(iobridge.java:509) @ java.net.plaindat
Read more