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.
Bistech
YearUp.org
Genus Breeding Ltd
Schlumberger
Cognizant Microsoft Business Group (MBG)
Freadom
Deliotte
Trayport
Philips
Ericson
ProgramUtvikling
Epic Games
Emerson Process Management
SuperControl
Teleplan
Lean SA
MacDonald Humfrey (Automation) Ltd.
Illumina
New Hampshire Supreme Court
Ghana Police Service
Washington Department of Transport
Department of Work and Pensions (UK)
Washington Department of Enterprise Services
Nottingham County Council
Graham & Brown
Sage
Jack Links
ProgramUtvikling
ALS Life Sciences
Freadom