search

BIDeveloperExtensions / bideveloperextensions

A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT).
https://bideveloperextensions.github.io
Other
87 stars 24 forks source link

Deploy MDX Script - Object reference not set to an instance of an object. #107

Closed ea25 closed 4 years ago

ea25 commented 4 years ago

Getting Object reference not set to an instance of an object when I try to deploy mdx script.

Using Visual Studio 2017 Version 15.9.12 with BIDS Helpver version 2.3.9.0.

Can someone point where can I start investigating this ?

furmangg commented 4 years ago

Can you post a screenshot from the Tools...Options... BIDS Helper... Version screen?

ea25 commented 4 years ago

Please find attached below.

image

furmangg commented 4 years ago

Thank you for reporting. I was able to reproduce in Visual Studio 2017 (not Visual Studio 2019 for some reason) and have a fix for this specific issue coded. I'm going to do some more thorough testing before I release this fix, probably later this week.

ea25 commented 4 years ago

Much appreciated. Please note I'm also experiencing this on VS 2017, didn't have any problems on VS 2019 - same situation as yours.

AgentRatty commented 4 years ago

Furmangg, I am experiencing this issue with VS 2019 on SQLServer 2019. Upon trying to "Deploy MDX Script" I get "Object reference not set to an instance of an object."

image

furmangg commented 4 years ago

We released BI Developer Extensions 2.4.0. But based upon your version numbers you are significantly out-of-date.

@AgentRatty your SSDTBI build is 15.0.1200.70 which is quite out-of-date. We've uploaded the download instructions to indicate that you may need to uninstall and reinstall in order to get to a newer SSDTBI build number (the shared modules that can't be updated directly). If that still doesn't fix it, go ahead and install the SSIS extension. We do the best we can to ensure individual features work without unrelated extensions, but we have limited time to test without SSRS/SSAS/SSIS all being installed.

@ea25 your SSDTBI build is 15.0.1000.59 which is quite out of date. Use the download instructions link above to uninstall and reinstall.

After you do that BI Developer Extensions 2.4 should fix your problems.