This project has moved and is read-only. For the latest updates, please go here.
3
Vote

Dax Studio fails to start up

description

Hello

I have installed DAX Studio 2.3.5 on a virtual machine (VirtualBox) with Windows 8.1, SQL Server 2014 and Excel 2013. The installation apparently ran fine, but when I double click the DAX Studio icon, the application does not run.

I have enabled the start up logging and obtained the log file, where it seems that the problem is caused by the Microsoft.AnalysisServices assembly, but I'm not sure. I have versión 12 of Microsoft.AnalysisServices but the log seems to check for versión 11. I attach that log file and hope you can help me.

Thanks in advance.
Luis

file attachments

comments

dgosbell wrote Feb 27, 2016 at 8:16 PM

The log file indicates that the installer configured Dax Studio to bind to v11 of that assembly. We actually look for the highest common version between Microsoft.AnalysisServices.dll and Microsoft.AnalysisServices.AdomdClient.dll so it might be an issue with mismatched version numbers.

Can you download and run the DaxStudio.Checker application from here http://daxstudio.codeplex.com/releases/view/618744

That will display a list of all the dependencies that Dax Studio needs in a text box then paste it back in a reply on this issue?

We should be able to fix this by updating the binding redirects in the daxstudio.exe.config file, but the installer should set those and I'm curious to know why the installer did not set them right. The output from the checker app should tell us that.

wrote Feb 28, 2016 at 7:46 PM

LMBlanco wrote Feb 28, 2016 at 7:46 PM

OK, I have just run DaxStudioChecker and looking at the output that generates, it seems the problem is in Microsoft.AnalysisServices versions 11 and 13, and Microsoft.AnalysisServices.adomdclient version 13. I attach the file with that output, I hope this help you to find the problem.

Thanks again for your support and regards.
Luis

dgosbell wrote Feb 28, 2016 at 9:50 PM

There was a minor bug in the enhancements that I put in to the 2.3.5 installer which I think you've hit. It only occurs when you have a mismatch in the number of versions between AMO and ADOMD.

Can you try the 2.3.6 installer as I think that should fix your issue.

LMBlanco wrote Feb 29, 2016 at 10:30 PM

OK, I have installed version 2.3.6 and now the application starts fine. However I can connect to a SSAS Tabular Model but the connect dialog doesn't show the option to connect to a PowerPivot Model. Must I put this issue in a different track?

Thank you very much for your help and regards.
Luis

dgosbell wrote Feb 29, 2016 at 11:57 PM

You have to launch Dax Studio from inside Excel using the button in the Add-ins toolbar to connect to PowerPivot. If you launch Dax Studio standalone it can only connect to SSAS servers or Power BI desktop (if it's running).

This is because PowerPivot itself runs inside the Excel process so we can only talk to it if we too are running inside Excel.

wrote Mar 1, 2016 at 7:31 PM

wrote Mar 1, 2016 at 7:46 PM

cwra007 wrote Mar 1, 2016 at 7:46 PM

I have the exact same problem as Luis.
I have attached my Studio Checker file for your reference. I have also installed 2.3.6 which is running fine.

Windows 7 x64; Excel 2013 x64; SQL Server 2016

-Chris

wrote Mar 1, 2016 at 7:47 PM

LMBlanco wrote Mar 1, 2016 at 7:47 PM

Hello

I think there must be a problem with my DAX Studio installation, because when I open a Excel file that has a PowerPivot model, in the PP UTILS ribbon, the Dax Studio button is disabled, so I can't open it Dax Studio from Excel. I attach a snapshot so you can check it.

Thank you and regards,
Luis

dgosbell wrote Mar 1, 2016 at 9:55 PM

@Chris - the connect to PowerPivot option only shows up when you launch Dax Studio from the Excel Addin ribbon.

@Luis - Sorry, but I have no idea how your ribbon could have got into that state. I have no code for enabling/disabling the ribbon button. It should be enabled 100% of the time. I can only suggest uninstalling and re-installing

cwra007 wrote Mar 1, 2016 at 10:21 PM

@dgosbell - Apologies, I should have been clearer. My issue was that like Luis, I installed version 2.3.5 fine and while it showed up in the Excel ribbon, when I clicked on the button nothing happened. It also did not run when I clicked directly on the .exe file from within Windows Explorer.

I have however resolved the issue after reading this thread and installing 2.3.6.
I have attached my log file 'DAX Studio Checker.txt' for your developer team in case the wanted to look into the issue further.

Best
Chris

LMBlanco wrote Mar 1, 2016 at 11:02 PM

@dgosbell - OK don't worry, I will try uninstall/install and I hope have success. Anyway I really appreciate your support, so thank you very much :-)

@Chris - I'm glad you could fix the problem with the help of this thread :-)

Regards to both
Luis

dgosbell wrote Mar 1, 2016 at 11:25 PM

@Chris - Oh Cool - looking at your log file I can see that you definitely would have hit the bug in the 2.3.5 installer. So it's good to hear that 2.3.6 fixes your issue. I've just changed 2.3.6 to stable status and made it the default release.

@Luis - I wish I could be more help, but I have not seen your issue before. Basically I believe that when Excel loads the DAX Studio add-in it creates the ribbon button, so if the add-in is disabled or uninstalled the button should not appear. Unless it has something to do with the fact that you've moved the button to a different ribbon.

It would be work checking in File -> Options -> Add- Ins. Then at the bottom of the screen there is a "Manage" combo box. First check disabled items and make sure that DAX Studio is not in there. Then go into the COM Addins and make sure that Dax Studio has a tick next to it.

wrote Mar 2, 2016 at 8:31 PM

LMBlanco wrote Mar 2, 2016 at 8:31 PM

@dgosbell - It's very curious, I have checked Excel Add-Ins and DAX Studio is not there, but in COM Add-Ins appears "Dax Studio Excel Add-In" uncheked. When I select this, at the bottom of the dialog appears a message pointing out a runtime load error of the Add-In. If I check the box of this Add-In, accept the dialog, and re-open this COM Add-Ins, the Dax Studio Add-In keeps unchecked. I attach a snapshot so you can see this behavior. It seems the file DaxStudio.vsto is involved in the problem.

I hope this help you to figure out the origin of the problem.

Regards,
Luis

dgosbell wrote Mar 2, 2016 at 11:01 PM

@Luis - hmm we might be getting close to something. In your \Program Files\DaxStudio folder there should be a DaxStudio.dll.config and a DaxStudio.exe.config. can you post those here it sounds like the assembly bindings might be different somehow - which is strange as the installer should keep those 2 in sync. (the dll version is the one for the Excel add-in)

wrote Mar 3, 2016 at 7:45 PM

LMBlanco wrote Mar 3, 2016 at 7:45 PM

@dgosbell - OK I have attached these config files.

Thank you and regards,
Luis

dgosbell wrote Mar 7, 2016 at 1:52 AM

@Luis - the config files look OK, so if the standalone version of Dax Studio runs then I'm not sure why the Excel add-in is not working. We have seen one or two instances with VSTO not being loaded, but mainly with Excel 2010 (and PowerPivot uses VSTO - so if that is up and running everything normally works)

By default Excel will suppress errors from add-ins - you can temporarily switch off the suppression of these errors using an environment variable as outlined here http://www.macroview.com.au/support/KnowledgeBase/Pages/20110084.aspx. Can you try that and see if we can get more detailed error information that way?

wrote Mar 7, 2016 at 11:06 PM

LMBlanco wrote Mar 7, 2016 at 11:06 PM

@dgosbell - OK I have follow the steps in the link and attach the log file obtained. The message indicates that vsto was unable to load CLR.

Thank you and regards,
Luis

wrote Jun 9, 2016 at 12:14 PM

wrote Jan 3 at 7:25 PM

nickchobotar wrote Jan 3 at 7:25 PM

Hello,

I am not sure what caused it but now I am not able to launch DAX Studio 2.6.0 from excel. I can launch DAX Studio from .exe and connect to SSAS and Power BI without any problems.
Interestingly, with earlier versions (e.g. 2.5.0) DAX Studio launches from excel but I am getting an error "PowerPivot model not detected"

I have uploaded the checker file ( it appears i am missing a config file). Any idea what might be the reason for this?


I am using:
Windows 10
Excel 2016 64/bt

Thanks, Nick -

dgosbell wrote Jan 3 at 11:14 PM

@Nick your problem is different to the one in this issue. The Checker is really only useful when the UI won't start at all. Can you see if you can setup the logging in the daxstudio.dll.config file as outlined here and see if that captures any errors?

nickchobotar wrote Jan 4 at 2:00 PM

Hello dgosbell,

Thank you for your prompt reply. I am checking my program file dax studio folder and i cannot find a file named "daxstudio.dll.config" in it. Do you think this might be somehow related to my problem?

Could you please be so kind to send this file to me (Dax Studio 2.6.0)?

Thank you,
Nick -

nickchobotar wrote Jan 4 at 2:12 PM

Hello dgosbell,

I just wanted to clarify that i am missing both daxstudio.dll.config and daxstudio.exe.config files. It appears my system failed to install these.

**** My hidden files and folders setting is ON

Nick -

dgosbell wrote Jan 4 at 9:18 PM

@Nick - there is nothing really in the config files that should prevent normal operation of the application. So the absence of them is not the cause of this issue. I've attached a copy of the dll.config file so that you can copy that into the install folder and follow the instructions to uncomment the logging settings.

wrote Jan 4 at 9:18 PM

wrote Mar 7 at 9:26 AM