Home Download News/Events Partners Contact

Main Menu









   

Frequently Asked Questions

I get an HTTP 500 - Internal server error. What can I do?
To make the error visible in the Internet Explorer go to: Internet Explorer > Tools.. > Internet Options > Advanced Tab > Uncheck "Show Friendly Error Messages".
When connecting to Analysis Services 2005, I get an error message: "Could not connect to XMLA service: http://[MyServerName]/xmla/msmdpump.dll." Please check user id and password, restart IIS and try again.
  1. If using Windows Server 2003, you will need to enable ISAPI extensions for XML/A to work.
  2. Login to your web server with the user id you used for Anonymous user. Create a UDL file (like test.udl) and point it to SSAS 2005 server using Microsoft OLE DB Provider for Olap Services 9.0.
  3. Type the URL for msmdpump.dll in you browser. Make the error visible in the Internet Explorer go to: Internet Explorer > Tools.. > Internet Options > Advanced Tab > Uncheck "Show Friendly Error Messages".
  4. Please check your windows event log.
  5. Try using the SDK sample application to make sure that XMLA SDK is properly installed.
  6. Here is Microsoft's white paper that could be useful.
When connection to Analysis Services 2000, I receive an error that says: "...Unable to process the request, because the DataSourceInfo property was missing or not correctly specified..." What should I do?
XMLA SDK 1.1 requires MSXML 4.0. It can be downloaded by clicking here. Try using the SDK sample application to make sure that XMLA SDK is properly installed. You can also test the connection with this page MDX.htm. Please save this page to desktop before running it. Sometime it is necessary to restart the IIS service or the PC for the XML/A web service to work.
The Report Portal does not seem to work under Windows Server 2003.
You will need to enable ASP’s "parent paths" for a Web Site or application when using relative paths in include statements. This is disabled by default in IIS 6. Make sure that Active Server Pages are allowed in the IIS 6 console. Please refer to this Microsoft knowledge base article. You will also need to explicitly enable ISAPI extensions for XML/A to work.
Why doesn't Report Portal support Netscape?
As of January 19 2004, Microsoft's Internet Explorer global usage share is 94.8 percent according to OneStat.com.
What can be done to improve XMLA service performance?
Enabling the HTTP compression on the web server can significantly improve performance. This article explains how to enable HTTP compression. Make sure that HTTP compression does not have caching enabled. Use MetaEdit tool to set parameter "max-age"property should be set to zero.
How can I create a custom Geo Map?
Please download our MAP SDK: MapSDK.zip.
The login.aspx page gives me a strange looking error: <%=sMsg%>
Your server does not seem to have ASP.NET configured. Please take these steps:
  1. Go to Default Website Properties, Home Directory Tab, Configuration..., App Mappings Tab, Find ASPX.
  2. If you could not find ASPX run the following the command line:
    %windir%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
I manually deleted ReportPortal files and can no longer uninstall the application via the "Add/Remove Programs" dialog.
Please download and run this script. It will remove ReportPortal from your registry and from the list.
Can purchased copy can be installed over the demo copy without data loss?
Yes, this can accomplished in two steps:
  1. Uninstall the Evaluation version of Report Portal. Choose "NO" when asked to delete the database.
  2. Install Report Portal by double clicking on ReportPortalSetup.msi file. Choose the same database name used by the Evaluation version.
How can I get Foodmart 2000 sample database for Analysis Services 2005?
Download backup file FoodMart2000.zip. Open "SQL Server 2005 Management Studio. Right click on "Databases" and choose "Restore..."
Why after accessing a Reporting Services report I can no longer access an OLAP report?
It looks like your Reporting Services "ReportServer" virtual directory is using Windows Integrated Authentication. XMLA web service is unable to handle a Windows Authentication. After being authenticated by Reporting Services virtual directory, your browser challenges XMLA service and the service breaks. Please enable basic anonymous/basic authentication instead for "ReportServer" virtual directory.
I am using Analysis Services 2000. I am experiencing errors when processing some reports. IIS grabs significant amounts of memory and then restarts.
You will need to configure the amount of memory used by XMLA. Please open datasources.xml (C:\Program Files\Microsoft XML For Analysis SDK\Config\datasources.xml) file in Notepad. Change text inside DataSourceInfo XML tag like so:

<DataSourceInfo> Provider=MSOLAP.2;Data Source=local; Client Cache Size=150; Execution Location=3; Default Isolation Mode=1; Large Level Threshold=100; </DataSourceInfo>

Here are the connection properties to change:
  1. Client Cache Size=150; - try to make smaller
  2. Execution Location=3; 3 - Queries are executed on the server.
  3. Default Isolation Mode=1;
  4. Large Level Threshold=100; - try to make smaller
I have Windows 2003 server with Windows Sharepoint Services. I get the following error when connecting to ReportPortal: Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System. Web.SessionStateModule or a custom session state module is included in the <configuration> \<system.web>\<httpMOdules> section in the application configuration.
Please open Web.config and uncomment this section:
<httpModules>
<add name="Session" type="System.Web.SessionState.SessionStateModule"/>
</httpModules>

Home | Download | News | Contact
Copyright © 2003 - 2008, XMLA Consulting.