TL;DR; Explains troubleshooting a confusing MS Build error in a mixed Visual Studio 2005/2008 environment, resolved by updating GDR and Business Intelligence components.
I received a confusing error from MS Build on Friday. I assumed that it was a GDR version issue for the top level message:
Now, we have the situation with our Business Intelligence system where we have 2 solutions. One for Visual Studio 2005 projects that consist solely of the Business Intelligence Package bits, and a 2008 solution which consists of everything else that is needed to build our solution. We do plan to move everything over to 2008, but we are currently targeting SQL Server 2005.
The problem looks like it is to do with the 2008 solution an not the 2005 one:
But, the error message implies that it is the 2005 solution:
c:WorkingXxxxxXXX Integration (Main)SourcesXXXDEVMainXXX2005.sln(0,0): warning MSB4126: The specified solution configuration “Release|Any CPU” is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform=“Any CPU”) or leave those properties blank to use the default solution configuration.
C:Program FilesMSBuildMicrosoftVisualStudiov9.0TeamDataMicrosoft.Data.Schema.SqlTasks.targets(58,5): error MSB4018: The “SqlBuildTask” task failed unexpectedly.
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.VisualStudio.TeamSystem.Data.Tasks.TaskHostLoader.Load(ITaskHost providedHost)
at Microsoft.VisualStudio.TeamSystem.Data.Tasks.DbBuildTask.Execute()
at Microsoft.Build.BuildEngine.TaskEngine.ExecuteInstantiatedTask(EngineProxy engineProxy, ItemBucket bucket, TaskExecutionMode howToExecuteTask, ITask task, Boolean& taskResult)
After reading up, I am none the wiser, but I did find information that implied that installing SP1 for TFS should fix the problem and not require that I update the TFS server. We are using GDR bits, so I will be installing GDR 16 and the SQL Server 2008 Business Intelligence bits.
UPDATE: So after jut updating the GDR, I got the solution to build! Not sure why there was an error in the 2005 solution!
Sources:
Each classification [Concepts, Categories, & Tags] was assigned using AI-powered semantic analysis and scored across relevance, depth, and alignment. Final decisions? Still human. Always traceable. Hover to see how it applies.
If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.
We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.
DFDS
Illumina
Philips
ProgramUtvikling
Lockheed Martin
New Signature
MacDonald Humfrey (Automation) Ltd.
Cognizant Microsoft Business Group (MBG)
Genus Breeding Ltd
Xceptor - Process and Data Automation
Alignment Healthcare
Workday
Deliotte
Emerson Process Management
Kongsberg Maritime
Ericson
Flowmaster (a Mentor Graphics Company)
Boeing
Ghana Police Service
Royal Air Force
Washington Department of Enterprise Services
Department of Work and Pensions (UK)
New Hampshire Supreme Court
Washington Department of Transport
Capita Secure Information Solutions Ltd
Milliman
Higher Education Statistics Agency
Trayport
Freadom
ALS Life Sciences