Details
-
Type:
Bug
-
Status: Closed
-
Severity:
High
-
Resolution: Fixed
-
Affects Version/s: 5.2.0 GA
-
Fix Version/s: 5.3.0 GA
-
Component/s: Management Services
-
Labels:
-
Story Points:0
-
Notice:
Description
In order to replicate this issue please follow these steps:
In 5.2 Data Access Manager edit the Analysis type connection for Sample Data and change EnableXmla to true
Upload the attached xaction: 51_CallOlapInput.xaction
Upload the attached ktr: 51_SampleOlap.ktr (make sure the URL in the ktr matches the one for your server)
Note the ktr uses the OLAP Input step with the following query:
select
NON EMPTY Hierarchize(Union(Crossjoin(
Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}
,
Union(Crossjoin([Region].[All Regions].Children,
), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS,
NON EMPTY Hierarchize(Union(
, [Positions].[All Positions].Children)) ON ROWS
from [Quadrant Analysis]
Although using XMLA over a PDI Olap input seems redundate please see ESR-3711
Set up a JDBC connection to a local Foodmart MySQL Database
Upload the attached Foodmart schema
Execute the 51_CallOlapInput.xaction and see the report as shown in the attached screenshot
Clear Mondrian Schema Cache
Stop your MySQL Server
If you run the xaction you will get the following exception on the Pentaho log:
2014-10-27 13:40:45,502 DEBUG [mondrian.xmla.XmlaServlet] XML/A response content
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
<SOAP-ENV:Header>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Server.00HSBE02</faultcode>
<faultstring>XMLA Discover unparse results error</faultstring>
<faultactor>Mondrian</faultactor>
<detail>
<XA:error xmlns:XA="http://mondrian.sourceforge.net">
<code>00HSBE02</code>
<desc>The Mondrian XML: Software caused connection abort: recv failed</desc>
</XA:error>
</detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Please see attached screencast:
https://pentaho.viewscreencasts.com/embed/03daed8a5fa64ebdb0ee51c514b4ed1f
PractiTest Integration
Attachments
Issue Links
- is duplicated by
-
MONDRIAN-1056 When JDBC connection for some XML/A datasource are not availalbe, the entire DISCOVER request fails with "Uncaught error SOAP-ENV:Server.00HSBE02: XMLA Discover unparse results error"
-
- Closed
-
- relates to
-
MONDRIAN-1468 Queries will fail on a valid schema and working connection if any different and other data sources contain either schema errors or data connection problems.
-
- Closed
-