none
msmdpump.dll not getting registered

    Question

  • I am using SSAS 2008 and I am getting error on registering msmdpump.dll using regsvr32

    Error is "msmdpump.dll was loaded, but the DllRegisterServer entry point was not found". The file can not be rgistered"

    My machine is Win XP with IIS 5.1.

    I want to use SSAS from Java. I am going through steps mentioned on this link -

    http://www.matthewgodding.com/articles/2010/2/27/getting-data-from-sql-analysis-services-using-java-and-olap4.html

    I can not launch page http://localhost/olap/msmdpump.dll

    I get this error in firefox -

    <soap:Envelope>

    <soap:Body>

    <soap:Fault>
    <faultcode>XMLAnalysisError.0xc10e0002</faultcode>
    <faultstring>Parser: The syntax for 'GET' is incorrect.</faultstring>

    <detail>
    <Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile=""/>
    </detail>
    </soap:Fault>
    </soap:Body>
    </soap:Envelope>

     

    Thursday, August 26, 2010 10:45 PM

Answers

  • Have you granted IUSR_<your servername> necessary access on your SSAS cube?

    - On your SSAS cube create a role with Full Control (Administrator) access.

    - Add <your servername>\IUSR_<your servername> to this role.

    - Try connecting with Excel again.

     

    Regards, 'Dotun

     

    • Marked as answer by sVirgo2008 Friday, August 27, 2010 4:23 PM
    Friday, August 27, 2010 3:57 PM

All replies

  • Hi,

    It will be interesting for you to know that your "error message" from firefox with the launch of http://localhost/olap/msmdpump.dll  was an indication that you are getting response from SSAS. You will not get this message with Internet Explorer and that actually confused me when I first set up SSAS http access for a client.

    I can walk you through some of the things I have done before to set up SSAS http access if its ok. Firstly, could you check if you can access your SSAS cube from Excel. In my case I used Excel 2007

    - Launch Excel

    - Click on the Data menu

    - Choose "From Other Sources" in the Get External Data category.

    - Choose "From Analysis Services"

    - Type http://localhost/olap/msmdpump.dll  in "Server name". (Make sure no blank spaces after dll).

    - Click the Next button.

    This should give you an option to select the database and cube that is accessible to the current user. If this is successful, this shows that your http configuration access was successful. 

    Please let me know your results.

     

    Regards 'Dotun

    Friday, August 27, 2010 10:03 AM
  • Hi Dotun!

    I tried with Excel and after following steps till

    "Launch Excel

    - Click on the Data menu

    - Choose "From Other Sources" in the Get External Data category.

    - Choose "From Analysis Services"

    - Type http://localhost/olap/msmdpump.dll  in "Server name". (Make sure no blank spaces after dll)."

    I got an error - Either a connection can not be made to localhost server, or analysis service is not running

    Finally I was able to work with Excel- it worked as you mentioned above.

    My mistake was in ini file, I did not mention instance name.

    • Edited by sVirgo2008 Friday, August 27, 2010 3:58 PM
    Friday, August 27, 2010 3:35 PM
  • Yes, I followed this link, the difference is I am using SQL Server 2008.

    However, I was unable to register msmdpump.dll and it gave me the error message

    Error is "msmdpump.dll was loaded, but the DllRegisterServer entry point was not found". The file can not be rgistered"

    Friday, August 27, 2010 3:37 PM
  • Have you granted IUSR_<your servername> necessary access on your SSAS cube?

    - On your SSAS cube create a role with Full Control (Administrator) access.

    - Add <your servername>\IUSR_<your servername> to this role.

    - Try connecting with Excel again.

     

    Regards, 'Dotun

     

    • Marked as answer by sVirgo2008 Friday, August 27, 2010 4:23 PM
    Friday, August 27, 2010 3:57 PM
  • Great, it worked. I could access from Java using olap4j driver.

    At this time, my security setting in IIS is windows authentication. I can access cube from Java and Excel both.

    But I still can not launch it from IE.

    Will it be okay to continue working like this.

    Friday, August 27, 2010 4:23 PM
  • Great, it worked. I could access from Java using olap4j driver.

    At this time, my security setting in IIS is windows authentication. I can access cube from Java and Excel both.

    But I still can not launch it from IE.

    Will it be okay to continue working like this.


    Yes, this is OK. IE does not send the correct XMLA to SSAS, so getting a 500 error is expected.

    If you use something like Excel, SSMS or some other OLAP client and it works, then you are fine.


    http://geekswithblogs.net/darrengosbell - please mark correct answers
    Monday, August 30, 2010 7:13 AM
    Moderator
  • Dear sVirgo,

     Am trying to access MS SSAS data cube from Java through olap4j driver(through msmdpump.dll). I am able to connect , but when I try to execute a query, i am getting the below error: Please help me out if you can. Thanks in advance.

    org.olap4j.OlapException: XMLA provider gave exception: <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
    <faultcode>
    XMLAnalysisError.0xc10a0004
    </faultcode>
    <faultstring>
    The CRASHDWHSRG cube either does not exist or has not been processed.
    </faultstring>
    <detail>
    <Error Description="The CRASHDWHSRG cube either does not exist or has not been processed." ErrorCode="3238658052" HelpFile="" Source="Microsoft SQL Server 2012 Analysis Services">
    </Error>
    </detail>
    </soap:Fault>

    Tuesday, December 17, 2013 7:57 PM
  • Great, it worked. I could access from Java using olap4j driver.

    At this time, my security setting in IIS is windows authentication. I can access cube from Java and Excel both.

    But I still can not launch it from IE.

    Will it be okay to continue working like this.

     Am trying to access MS SSAS data cube from Java through olap4j driver(through msmdpump.dll). I am able to connect , but when I try to execute a query, i am getting the below error: Please help me out . I tested the http://XXXX/OLAP/msmdpump.dll from MS Excel,and it is working fine . Thanks in advance.

    org.olap4j.OlapException: XMLA provider gave exception: <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
    <faultcode>
    XMLAnalysisError.0xc10a0004
    </faultcode>
    <faultstring>
    The CRASHDWHSRG cube either does not exist or has not been processed.
    </faultstring>
    <detail>
    <Error Description="The CRASHDWHSRG cube either does not exist or has not been processed." ErrorCode="3238658052" HelpFile="" Source="Microsoft SQL Server 2012 Analysis Services">
    </Error>
    </detail>
    </soap:Fault>
    Tuesday, December 17, 2013 8:00 PM
  • This error is coming back from SSAS, so this means that msmdpump is configured and working correctly.

    The error:

    The CRASHDWHSRG cube either does not exist or has not been processed.

    Means that either your connection string or query is incorrect and SSAS cannot find this cube in the database that you connected to (or it exists but is not in processed state)


    http://darren.gosbell.com - please mark correct answers

    • Proposed as answer by Boni K Tuesday, December 17, 2013 10:18 PM
    Tuesday, December 17, 2013 10:09 PM
    Moderator
  • Thank you Darren.  It helped!

    Regards,

    Boni

    Tuesday, December 17, 2013 10:19 PM