Home Dashboard Directory Help

[Datadude] Deploy failure - something to do with triggers by Jamie Thomson


 as Deferred Help for as Deferred

Sign in
to vote
Type: Bug
ID: 657580
Opened: 4/6/2011 3:31:35 AM
Access Restriction: Public
User(s) can reproduce this bug


I am trying to do deploy to an existing database and am getting the following error:
The "SqlDeployTask" task failed unexpectedly.
System.ArgumentNullException: Value cannot be null.
Parameter name: key
at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value)
at Microsoft.Data.Schema.Sql.Build.SqlDeploymentPlanGenerator.AlterStatementGenerator.CheckTriggerAlterStatus

(the full text of the error is below).

As you can see from the error it is having trouble with triggers. It just so happens that since the lsat deployment and attempting this one I have removed some triggers from my project - I guess this is what is causing the error (note that I also have "Generate DROP statements for objects not in project" checked).

I have attached:
1) A backup of the database I am attempting to deploy to
2) A copy of my datadude project
Sign in to post a comment.
Posted by Microsoft on 6/1/2011 at 3:59 PM
Hi Jamie,

Thank you for submitting this issue and supplying excellent repro steps and files. We have reproduced this issue and have added it to our product backlog. It will be considered for a service release of Visual Studio.

We have confirmed there is a bug in our refactoring operation. The sequence of events where objects where renamed and removed from project or database is causing our refactoring opeation to hit a unexpected condition. You can manually remove the trigger from the target database [warehouse].[MessageHistory_i] or temporarily add it to your project. The issue is the refactoring operation is trying to generate a compensating action for the refactoring operation and confused when it does not exist in the comparison models.

Thanks for your patience while we resolve this issue.


Barclay Hill

Sr. Program Manager | Visual Studio Product Team (Data Tools) | Microsoft Corporation
Posted by Microsoft on 5/13/2011 at 3:26 PM
Hi Jamie, thanks for sending this in. I am investigating the project files.

Barclay Hill
Sr. Program Manager | Visual Studio Product Team (Data Tools) | Microsoft Corporation
Posted by Microsoft on 4/7/2011 at 1:04 AM
Thank you for submitting feedback on Visual Studio 2010 and .NET Framework. Your issue has been routed to the appropriate VS development team for review. We will contact you if we require any additional information.
Posted by Microsoft on 4/6/2011 at 4:13 AM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Warehouse.zip (restricted) 4/6/2011 -
Warehouse project.zip (restricted) 4/6/2011 -