ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal Installation
 XMLA setup

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
PrimaCommerce Posted - 06/01/2017 : 21:46:02
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.



11   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 06/03/2017 : 22:58:51
The msmdpump.dll was 32 bit and XMLA application pool was 64 bit. Switching XMLA application pool to 32 bit resolved the problem.
PrimaCommerce Posted - 06/03/2017 : 05:09:34
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.''

admin Posted - 06/03/2017 : 04:15:35
What happens when you try to view msmdpump.dll in browser?
(like: http://www.reportportal.us/xmla/msmdpump.dll)
PrimaCommerce Posted - 06/03/2017 : 02:51:45
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
admin Posted - 06/03/2017 : 02:30:29
Did you copy msmdpump.dll and related files to C:\inetpub\wwwroot\XMLA folder?
PrimaCommerce Posted - 06/03/2017 : 02:01:32
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]



admin Posted - 06/03/2017 : 01:14:53
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]

PrimaCommerce Posted - 06/03/2017 : 00:06:39
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.''

admin Posted - 06/02/2017 : 05:10:21
The first error ("error in setting the window handle property") can be safely ignored. Do you see a message after this error?
PrimaCommerce Posted - 06/02/2017 : 02:20:57
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

admin Posted - 06/01/2017 : 23:10:57
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

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page