Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-2230

XMLA fails to be read if a prior schema is not valid due to a broken jdbc connection

    XMLWordPrintable

    Details

    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      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(

      {[Measures].[Actual]}, Union(Crossjoin({[Region].[All Regions]}, {[Department].[All Departments]}),
      Crossjoin({[Region].[All Regions]}, [Department].[All Departments].Children))), Crossjoin({[Measures].[Actual]}

      ,
      Union(Crossjoin([Region].[All Regions].Children,

      {[Department].[All Departments]}

      ), Crossjoin([Region].[All Regions].Children, [Department].[All Departments].Children))))) ON COLUMNS,
      NON EMPTY Hierarchize(Union(

      {[Positions].[All Positions]}

      , [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

          1. 51_CallOLAPInput.xaction
            1 kB
          2. 51_SampleOLAP.ktr
            17 kB
          3. mondrian.log
            4.45 MB
          4. MYFoodMart.mondrian.xml
            48 kB
          5. pentaho.log
            47 kB

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                clopez Carlos Lopez
                Votes:
                1 Vote for this issue
                Watchers:
                7 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0h
                    0h
                    Logged:
                    Time Spent - 4h
                    4h