| 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 |
Report Portal
