Reputation: 17
"Object reference not set to an instance of an object" in VS while deploying multidimensional project
When I try to deploy new empty multidimensional project in "Visual Studio 2017 Data Tools" I get this error "Object reference not set to an instance of an object". However I see the new databse in Analysis Services via SSMS. Then I try to fill my project with data (AdventureWorksDW) and deploy but that error occurs again and no data loaded to db.
- SQL Server 2017
- Visual Studio 2017
Upvotes: 0
Views: 1304
Answers (2)
Reputation: 588
In my case I had x64 build platform configuration and I had to set the sql project to Any CPU platform
Upvotes: 0
Reputation: 588
If someone runs across this (happened to me in VS2022) Check your .sqlproj file and ensure you have the xmlns defined correctly:
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
This is what fixed the deploy problem for me. see sql-server-samples
Upvotes: 0
Related Questions
- OLAP Cube deployment issues
- SSAS Deploy fails: Unable to cast object of type 'Microsoft.AnalysisServices.Tabular.StructuredDataSource'
- SQL SSAS - Deploying error
- How to deploy OLAP Cube to local SQL Server?
- Missing method in Visual Studio when trying to process OLAP cube
- SSAS OLAP multidimensional data disappears on deployment
- Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found
- Error during deploy from visual studio to analysis server
- Error Loading metadata in visual studio
- Error while deploying SSAS after modifying dimension & attribute properties