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

Status : 

  Deferred<br /><br />
		The product team has reviewed this issue and has deferred it for consideration at a later time.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 657580 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 4/6/2011 3:31:35 AM
Access Restriction Public


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)