Forum
Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal Installation
 XMLA setup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

PrimaCommerce

Croatia
14 Posts

Posted - 06/01/2017 :  21:46:02  Show Profile  Reply with Quote
Hi,
I'm installing ReportPortal 5.0 and I'm having problem with creating connection to OLAP over XMLA.

I foloved instructions how to setup Reportportal and XMLA but I get error
''TestXmla: The remote server returned an error: (500) Internal Server Error.''

I tried everything that I could think off.



admin

1609 Posts

Posted - 06/01/2017 :  23:10:57  Show Profile  Reply with Quote
The problem can be caused by security, SSAS provider or incompatible msmdpump.dll files.

1. Are you able to connect to SSAS using a UDL file? Create a text file (Test.txt), rename it to Test.udl and duoble click on it. select Microsoft OLE DB Provider of Analysis Services put your server info and click Test.

2. Copy a sample text file (Test.txt) to in C:\inetpub\wwwroot\XMLA folder. Try to view the file in browser (like http://www.reportportal.us/xmla/Test.txt)

Please try to set XMLA manually:
https://www.youtube.com/watch?v=tJGGyg1dDHY
Go to Top of Page

PrimaCommerce

Croatia
14 Posts

Posted - 06/02/2017 :  02:20:57  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]The problem can be caused by security, SSAS provider or incompatible msmdpump.dll files.

1. Are you able to connect to SSAS using a UDL file? Create a text file (Test.txt), rename it to Test.udl and duoble click on it. select Microsoft OLE DB Provider of Analysis Services put your server info and click Test.

I get an error ''Test connection failed because of an error in setting the window handle property. Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Continue with test connection?''



2. Copy a sample text file (Test.txt) to in C:\inetpub\wwwroot\XMLA folder. Try to view the file in browser (like http://www.reportportal.us/xmla/Test.txt)

I can connect and see test.txt file and it's content.

Please try to set XMLA manually:
https://www.youtube.com/watch?v=tJGGyg1dDHY

Go to Top of Page

admin

1609 Posts

Posted - 06/02/2017 :  05:10:21  Show Profile  Reply with Quote
The first error ("error in setting the window handle property") can be safely ignored. Do you see a message after this error?
Go to Top of Page

PrimaCommerce

Croatia
14 Posts

Posted - 06/03/2017 :  00:06:39  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]The first error ("error in setting the window handle property") can be safely ignored. Do you see a message after this error?



The next message is ''Test connection succeeded but some settings were not accepted by the provider.''

Go to Top of Page

admin

1609 Posts

Posted - 06/03/2017 :  01:14:53  Show Profile  Reply with Quote
Is your SSAS server installed on your web server?
Is XMLA virtual directory setup to have Anonymous authentication only?

1. Copy msmdpump.dll and related files (usually located in C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\bin\isapi) to C:\inetpub\wwwroot\XMLA

2. Open "C:\inetpub\wwwroot\XMLA\msmdpump.ini" in notepad. Change Local to [Your Server Name]

Go to Top of Page

PrimaCommerce

Croatia
14 Posts

Posted - 06/03/2017 :  02:01:32  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]Is your SSAS server installed on your web server?

Yes.

Is XMLA virtual directory setup to have Anonymous authentication only?

Yes.

1. Copy msmdpump.dll and related files (usually located in C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\bin\isapi) to C:\inetpub\wwwroot\XMLA

2. Open "C:\inetpub\wwwroot\XMLA\msmdpump.ini" in notepad. Change Local to [Your Server Name]



Go to Top of Page

admin

1609 Posts

Posted - 06/03/2017 :  02:30:29  Show Profile  Reply with Quote
Did you copy msmdpump.dll and related files to C:\inetpub\wwwroot\XMLA folder?
Go to Top of Page

PrimaCommerce

Croatia
14 Posts

Posted - 06/03/2017 :  02:51:45  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]Did you copy msmdpump.dll and related files to C:\inetpub\wwwroot\XMLA folder?



Yes i did.

I still get the same error
Go to Top of Page

admin

1609 Posts

Posted - 06/03/2017 :  04:15:35  Show Profile  Reply with Quote
What happens when you try to view msmdpump.dll in browser?
(like: http://www.reportportal.us/xmla/msmdpump.dll)
Go to Top of Page

PrimaCommerce

Croatia
14 Posts

Posted - 06/03/2017 :  05:09:34  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]What happens when you try to view msmdpump.dll in browser?
(like: http://www.reportportal.us/xmla/msmdpump.dll)



I get ''500 - Internal server error.''

Go to Top of Page

admin

1609 Posts

Posted - 06/03/2017 :  22:58:51  Show Profile  Reply with Quote
The msmdpump.dll was 32 bit and XMLA application pool was 64 bit. Switching XMLA application pool to 32 bit resolved the problem.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000