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 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)
Back to the top | Give Feedback

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
(http://support.microsoft.com/kb/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.
Back to the top | Give Feedback

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
(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
(http://msdn.microsoft.com/en-us/library/dd193405.aspx#LimitationsOfCompositeProjects)
Back to the top | Give Feedback

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
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top