FIX: When you deploy composite projects in Microsoft Visual Studio Team System 2008 Database Edition GDR, if one project has constraints for tables in a referenced project, you receive a System.NullReferenceException exception

Article translations Article translations
Article ID: 970590 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario in Microsoft Visual Studio Team System 2008 Database Edition GDR:
  • You use composite projects to separate a Microsoft SQL Server database into smaller pieces.
  • In a database project, you add Constraints for tables that are defined in a referenced database project.
  • You deploy these projects to a database.
In this scenario, the deployment task fails and you receive the following error message in the Output window:
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Data.Schema.Sql.Build.SqlDeployment.PlanVerifier.IsExistenceVerified(IModelElement relatedElement)
at Microsoft.Data.Schema.Sql.Build.SqlDeployment.PlanVerifier.VerifyPlan(DeploymentPlan plan)
at Microsoft.Data.Schema.Sql.Build.SqlDeployment.OnVerifyPlan()
at Microsoft.Data.Schema.Build.Deployment.VerifyPlan()
at Microsoft.Data.Schema.Build.Deployment.Execute()
at Microsoft.Data.Schema.Tasks.DBDeployTask.Execute()
at Microsoft.Build.BuildEngine.TaskEngine.ExecuteInstantiatedTask(EngineProxy engineProxy, ItemBucket bucket, TaskExecutionMode howToExecuteTask, ITask task, Boolean& taskResult)

RESOLUTION

To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
970479 List of fixed issues in the Microsoft Visual Studio Team System 2008 Database Edition GDR R2

Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.

MORE INFORMATION

For more information about constraints, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/aa290112(VS.71).aspx
For more information about Composite Projects, visit the following MSDN Web site:
http://msdn.microsoft.com/en-us/library/dd193405.aspx#LimitationsOfCompositeProjects

Properties

Article ID: 970590 - Last Review: July 16, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbqfe kbexpertiseadvanced kbsurveynew kbprb KB970590

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com