Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-3825

Simple MDX Query against MS SASS 12 fails with SOAP-Fault

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.9.0 GA (4.5.0 GA Suite Release)
    • Fix Version/s: None
    • Component/s: Data Source
    • Labels:
      None
    • 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

      i'm working on a proof concept using pentaho report designer with an OLAP datasource connected to a MS SASS 12. The first step was trying a simple MDX Query in the datasource editor of the designer.

      I've configured following datasource:

      Data -> Add datasource -> OLAP -> OLAP4J

      And added the following database connection:

      Generic Database
      Access: Native (JDBC)

      Connection-URL: jdbc:xmla:Server=http://192.168.100.20/olap/msmdpump.dll;Catalog='Analysis Services Tutorial';Cube='Analysis Services Tutorial'
      Custom Driver: org.olap4j.driver.xmla.XmlaOlap4jDriver
      User and password are set.

      The test was ok. In the datasource i added the following query:

      SELECT Measures.MEMBERS ON COLUMNS FROM [Analysis Services Tutorial]

      While starting the preview for this connection, i'll get the following exception (see full exception in attachments):

      java.lang.RuntimeException: org.olap4j.OlapException: XMLA provider gave exception: <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/"> [^]
      <faultcode>
      XMLAnalysisError.0xc10f0006
      </faultcode>
      <faultstring>
      XML parsing failed at line 15, column 10: Ungültiges qualifiziertes Zeichen.
      .
      </faultstring>
      <detail>
      <Error Description="XML parsing failed at line 15, column 10: Ungültiges qualifiziertes Zeichen.
      ." ErrorCode="3238985734" HelpFile="" Source="Microsoft SQL Server 2012 Analysis Services">
      </Error>
      </detail>
      </soap:Fault>

      Request was:
      <?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:Body>
      <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
      SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]
      <RequestType>DISCOVER_DATASOURCES</RequestType>
      <Restrictions>
      <RestrictionList>
      </RestrictionList>
      </Restrictions>
      <Properties>
      <PropertyList>
      <::PENTAHO-REPORTING::HOSTNAME></::PENTAHO-REPORTING::HOSTNAME>
      <::PENTAHO-REPORTING::PORT>1521</::PENTAHO-REPORTING::PORT>
      <::PENTAHO-REPORTING:ATABASE-TYPE>GENERIC</::PENTAHO-REPORTING:ATABASE-TYPE>
      <::PENTAHO-REPORTING::NAME>MS SASS</::PENTAHO-REPORTING::NAME>
      <CUBE>Analysis Services Tutorial</CUBE>
      <::PENTAHO-REPORTING:ATABASE-NAME></::PENTAHO-REPORTING:ATABASE-NAME>
      <Content>Data</Content>
      </PropertyList>
      </Properties>
      </Discover>
      </SOAP-ENV:Body>

      If i try this query within a simple java class using OLAP4J with same connection parameters, i got no errors. I also figured out, that in this case the request looks like

      <SOAP-ENV:Envelope
      xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" [^]
      SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]
      <SOAP-ENV:Body>
      <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
      SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> [^]
      <RequestType>DISCOVER_DATASOURCES</RequestType>
      <Restrictions>
      <RestrictionList>
      </RestrictionList>
      </Restrictions>
      <Properties>
      <PropertyList>
      <CUBE>Analysis Services Tutorial</CUBE>
      <Content>Data</Content>
      </PropertyList>
      </Properties>
      </Discover>
      </SOAP-ENV:Body>

      It seems , that the pentaho reporting properties are not allowed !?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              arakasi Thomas Wiesner
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: