Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: [Mondrian] Excel + refresh

  1. #1
    Manuel Darveau Guest

    Default [Mondrian] Excel + refresh

    Hi,

    I've just updated to mondrian 3.2.0.13583 and now excel gives me "the query
    did not run, or the database table could not be opened." error when I
    refresh.
    I didn't saw anything special in mondrian's log so I configured log4j in
    DEBUG and got this:

    2010.05.21;10:39:52.405 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.406 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.408 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance">
    <Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    <RequestType>DISCOVER_DATASOURCES</RequestType>
    <Restrictions>
    <RestrictionList/>
    </Restrictions>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>
    <Content>SchemaData</Content>
    <Format>Tabular</Format>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Discover>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.408 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.408 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.408 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
    key="Content", value="SchemaData"
    2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
    key="Format", value="Tabular"
    2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: time = 0
    2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: FREE_MEMORY: 131433kb
    26.69%
    2010.05.21;10:39:52.409 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.410 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <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>
    <cxmlaiscoverResponse
    xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    elementFormDefault="qualified">
    <xsd:element name="root">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element name="row" type="row" minOccurs="0"
    maxOccurs="unbounded"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    <xsd:simpleType name="uuid">
    <xsd:restriction base="xsd:string">
    <xsdattern
    value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>
    </xsd:restriction>
    </xsd:simpleType>
    <xsd:complexType name="row">
    <xsd:sequence>
    <xsd:element sql:field="DataSourceName" name="DataSourceName"
    type="xsd:string"/>
    <xsd:element sql:field="DataSourceDescription"
    name="DataSourceDescription" type="xsd:string" minOccurs="0"/>
    <xsd:element sql:field="URL" name="URL" type="xsd:string"
    minOccurs="0"/>
    <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo"
    type="xsd:string" minOccurs="0"/>
    <xsd:element sql:field="ProviderName" name="ProviderName"
    type="xsd:string" minOccurs="0"/>
    <xsd:element sql:field="ProviderType" name="ProviderType"
    type="xsd:string" maxOccurs="unbounded"/>
    <xsd:element sql:field="AuthenticationMode"
    name="AuthenticationMode" type="xsd:string"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:schema>
    <row>
    <DataSourceName>Provider=Mondrian;DataSource=cube;</DataSourceName>
    <DataSourceDescription>Data Warehouse</DataSourceDescription>
    <URL>http://localhost:8082/datawarehouse/xmla</URL>
    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    </row>
    </root>
    </cxmla:return>
    </cxmlaiscoverResponse>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    2010.05.21;10:39:52.417 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.418 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.420 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance">
    <Header>
    <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
    mustUnderstand="1"/>
    </Header>
    <Body>
    <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
    <Command>
    <Statement/>
    </Command>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>

    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Execute>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.421 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.421 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.422 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.423 DEBUG mdx: ""
    2010.05.21;10:39:52.423 DEBUG XmlaHandler.process: time = 0
    2010.05.21;10:39:52.424 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
    26.21%
    2010.05.21;10:39:52.424 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.424 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    /></SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    elementFormDefault="qualified">
    <xsd:element name="root"/>
    </xsd:schema>
    </root>
    </cxmla:return>
    </cxmla:ExecuteResponse>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    2010.05.21;10:39:52.429 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.429 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.431 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance">
    <Header>
    <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
    mustUnderstand="1"/>
    </Header>
    <Body>
    <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
    <Command>
    <Statement/>
    </Command>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>

    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Execute>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.431 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.431 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.432 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.432 DEBUG mdx: ""
    2010.05.21;10:39:52.432 DEBUG XmlaHandler.process: time = 0
    2010.05.21;10:39:52.433 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
    26.21%
    2010.05.21;10:39:52.433 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.433 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    /></SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    elementFormDefault="qualified">
    <xsd:element name="root"/>
    </xsd:schema>
    </root>
    </cxmla:return>
    </cxmla:ExecuteResponse>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    2010.05.21;10:39:52.435 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.435 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.437 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance">
    <Header>
    <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId=""
    mustUnderstand="1"/>
    </Header>
    <Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    <RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType>
    <Restrictions>
    <RestrictionList/>
    </Restrictions>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>
    <Content>SchemaData</Content>
    <Format>Tabular</Format>

    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Discover>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.437 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.438 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.438 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="Content", value="SchemaData"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="Format", value="Tabular"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.440 DEBUG XmlaHandler.process: time = 1
    2010.05.21;10:39:52.442 DEBUG XmlaHandler.process: FREE_MEMORY: 126748kb
    25.74%
    2010.05.21;10:39:52.442 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.442 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    /></SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <cxmlaiscoverResponse
    xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    elementFormDefault="qualified">
    <xsd:element name="root">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element name="row" type="row" minOccurs="0"
    maxOccurs="unbounded"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    <xsd:simpleType name="uuid">
    <xsd:restriction base="xsd:string">
    <xsdattern
    value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>
    </xsd:restriction>
    </xsd:simpleType>
    <xsd:complexType name="row">
    <xsd:sequence>
    <xsd:element sql:field="SchemaName" name="SchemaName"
    type="xsd:string"/>
    <xsd:element sql:field="SchemaGuid" name="SchemaGuid"
    type="uuid" minOccurs="0"/>
    <xsd:element sql:field="Restrictions" name="Restrictions"
    minOccurs="0" maxOccurs="unbounded">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element name="Name" type="xsd:string"
    sql:field="Name"/>
    <xsd:element name="Type" type="xsd:string"
    sql:field="Type"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    <xsd:element sql:field="Description" name="Description"
    type="xsd:string"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:schema>
    <row>
    <SchemaName>DBSCHEMA_CATALOGS</SchemaName>
    <Restrictions>
    <Name>CATALOG_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns information about literals supported by the
    provider.</Description>
    </row>
    <row>
    <SchemaName>DBSCHEMA_COLUMNS</SchemaName>
    <Restrictions>
    <Name>TABLE_CATALOG</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_SCHEMA</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>COLUMN_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description/>
    </row>
    <row>
    <SchemaName>DBSCHEMA_PROVIDER_TYPES</SchemaName>
    <Restrictions>
    <Name>DATA_TYPE</Name>
    <Type>xsd:unsignedShort</Type>
    </Restrictions>
    <Restrictions>
    <Name>BEST_MATCH</Name>
    <Type>xsd:boolean</Type>
    </Restrictions>
    <Description/>
    </row>
    <row>
    <SchemaName>DBSCHEMA_SCHEMATA</SchemaName>
    <Restrictions>
    <Name>CATALOG_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>SCHEMA_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>SCHEMA_OWNER</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description/>
    </row>
    <row>
    <SchemaName>DBSCHEMA_TABLES</SchemaName>
    <Restrictions>
    <Name>TABLE_CATALOG</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_SCHEMA</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_TYPE</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description/>
    </row>
    <row>
    <SchemaName>DBSCHEMA_TABLES_INFO</SchemaName>
    <Restrictions>
    <Name>TABLE_CATALOG</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_SCHEMA</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_TYPE</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description/>
    </row>
    <row>
    <SchemaName>DISCOVER_DATASOURCES</SchemaName>
    <Restrictions>
    <Name>DataSourceName</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>URL</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>ProviderName</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>ProviderType</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>AuthenticationMode</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns a list of XML for Analysis data sources
    available on the server or Web Service.</Description>
    </row>
    <row>
    <SchemaName>DISCOVER_ENUMERATORS</SchemaName>
    <Restrictions>
    <Name>EnumName</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns a list of names, data types, and enumeration
    values for enumerators supported by the provider of a specific data
    source.</Description>
    </row>
    <row>
    <SchemaName>DISCOVER_KEYWORDS</SchemaName>
    <Restrictions>
    <Name>Keyword</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns an XML list of keywords reserved by the
    provider.</Description>
    </row>
    <row>
    <SchemaName>DISCOVER_LITERALS</SchemaName>
    <Restrictions>
    <Name>LiteralName</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns information about literals supported by the
    provider.</Description>
    </row>
    <row>
    <SchemaName>DISCOVER_PROPERTIES</SchemaName>
    <Restrictions>
    <Name>PropertyName</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns a list of information and values about the
    requested properties that are supported by the specified data source
    provider.</Description>
    </row>
    <row>
    <SchemaName>DISCOVER_SCHEMA_ROWSETS</SchemaName>
    <Restrictions>
    <Name>SchemaName</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    \n...Message truncated due to length...

  2. #2
    Manuel Darveau Guest

    Default [Mondrian] Re: Excel + refresh

    I tried downgrading to 3.2.13343 and I get:

    2010.05.21;12:32:36.409 ERROR Errors when handling XML/A message
    mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results
    error
    at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2836)
    at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:548)
    at
    mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:426)
    at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:330)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at
    org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
    at
    org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
    at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
    at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at
    org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
    at
    org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at
    org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
    at
    org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
    assert failed: parentExp != null || nullParentValue == null
    at
    mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813)
    at mondrian.olap.Util.newInternal(Util.java:1492)
    at mondrian.olap.Util.assertTrue(Util.java:1484)
    at mondrian.olap.Util.assertPrecondition(Util.java:1554)
    at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:162)
    at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:314)
    at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:255)
    at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:122)
    at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:732)
    at mondrian.rolap.RolapCube.<init>(RolapCube.java:172)
    at mondrian.rolap.RolapCube.<init>(RolapCube.java:203)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:424)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:308)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:219)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:53)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:958)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755)
    at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166)
    at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:74)
    at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2907)
    at
    mondrian.xmla.RowsetDefinition$MdschemaCubesRowset.populate(RowsetDefinition.java:3740)
    at mondrian.xmla.Rowset.unparse(Rowset.java:167)
    at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2831)
    ... 18 more

    Manuel Darveau

    On Fri, May 21, 2010 at 10:51 AM, Manuel Darveau <manueldarveau (AT) gmail (DOT) com>wrote:

    > Hi,
    >
    > I've just updated to mondrian 3.2.0.13583 and now excel gives me "the query
    > did not run, or the database table could not be opened." error when I
    > refresh.
    > I didn't saw anything special in mondrian's log so I configured log4j in
    > DEBUG and got this:
    >
    > 2010.05.21;10:39:52.405 DEBUG Invoking validate http header callbacks
    > 2010.05.21;10:39:52.406 DEBUG Unmarshalling SOAP message
    > 2010.05.21;10:39:52.408 DEBUG XML/A request content
    > <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    > http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance">
    > <Body>
    > <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    > <RequestType>DISCOVER_DATASOURCES</RequestType>
    > <Restrictions>
    > <RestrictionList/>
    > </Restrictions>
    > <Properties>
    > <PropertyList>
    > <LocaleIdentifier>1033</LocaleIdentifier>
    > <Content>SchemaData</Content>
    > <Format>Tabular</Format>
    > <Catalog>cube</Catalog>
    > </PropertyList>
    > </Properties>
    > </Discover>
    > </Body>
    > </Envelope>
    > 2010.05.21;10:39:52.408 DEBUG Handling XML/A message header
    > 2010.05.21;10:39:52.408 DEBUG Invoking callbacks preAction
    > 2010.05.21;10:39:52.408 DEBUG Handling XML/A message body
    > 2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
    > key="LocaleIdentifier", value="1033"
    > 2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
    > key="Content", value="SchemaData"
    > 2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
    > key="Format", value="Tabular"
    > 2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
    > key="Catalog", value="cube"
    > 2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: time = 0
    > 2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: FREE_MEMORY: 131433kb
    > 26.69%
    > 2010.05.21;10:39:52.409 DEBUG Invoking callbacks postAction
    > 2010.05.21;10:39:52.410 DEBUG XML/A response content
    > <?xml version="1.0" encoding="ISO-8859-1"?>
    > <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>
    > <cxmlaiscoverResponse
    > xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    > <cxmla:return>
    > <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema"
    > xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    > xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance"
    > xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    > targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    > elementFormDefault="qualified">
    > <xsd:element name="root">
    > <xsd:complexType>
    > <xsd:sequence>
    > <xsd:element name="row" type="row" minOccurs="0"
    > maxOccurs="unbounded"/>
    > </xsd:sequence>
    > </xsd:complexType>
    > </xsd:element>
    > <xsd:simpleType name="uuid">
    > <xsd:restriction base="xsd:string">
    > <xsdattern
    > value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>
    > </xsd:restriction>
    > </xsd:simpleType>
    > <xsd:complexType name="row">
    > <xsd:sequence>
    > <xsd:element sql:field="DataSourceName" name="DataSourceName"
    > type="xsd:string"/>
    > <xsd:element sql:field="DataSourceDescription"
    > name="DataSourceDescription" type="xsd:string" minOccurs="0"/>
    > <xsd:element sql:field="URL" name="URL" type="xsd:string"
    > minOccurs="0"/>
    > <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo"
    > type="xsd:string" minOccurs="0"/>
    > <xsd:element sql:field="ProviderName" name="ProviderName"
    > type="xsd:string" minOccurs="0"/>
    > <xsd:element sql:field="ProviderType" name="ProviderType"
    > type="xsd:string" maxOccurs="unbounded"/>
    > <xsd:element sql:field="AuthenticationMode"
    > name="AuthenticationMode" type="xsd:string"/>
    > </xsd:sequence>
    > </xsd:complexType>
    > </xsd:schema>
    > <row>
    > <DataSourceName>Provider=Mondrian;DataSource=cube;</DataSourceName>
    > <DataSourceDescription>Data Warehouse</DataSourceDescription>
    > <URL>http://localhost:8082/datawarehouse/xmla</URL>
    > <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    > <ProviderName>Mondrian</ProviderName>
    > <ProviderType>MDP</ProviderType>
    > <AuthenticationMode>Unauthenticated</AuthenticationMode>
    > </row>
    > </root>
    > </cxmla:return>
    > </cxmlaiscoverResponse>
    > </SOAP-ENV:Body>
    > </SOAP-ENV:Envelope>
    >
    > 2010.05.21;10:39:52.417 DEBUG Invoking validate http header callbacks
    > 2010.05.21;10:39:52.418 DEBUG Unmarshalling SOAP message
    > 2010.05.21;10:39:52.420 DEBUG XML/A request content
    > <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    > http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance">
    > <Header>
    > <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
    > mustUnderstand="1"/>
    > </Header>
    > <Body>
    > <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
    > <Command>
    > <Statement/>
    > </Command>
    > <Properties>
    > <PropertyList>
    > <LocaleIdentifier>1033</LocaleIdentifier>
    >
    > <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    > <Catalog>cube</Catalog>
    > </PropertyList>
    > </Properties>
    > </Execute>
    > </Body>
    > </Envelope>
    > 2010.05.21;10:39:52.421 DEBUG Handling XML/A message header
    > 2010.05.21;10:39:52.421 DEBUG Invoking callbacks preAction
    > 2010.05.21;10:39:52.422 DEBUG Handling XML/A message body
    > 2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    > key="LocaleIdentifier", value="1033"
    > 2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    > key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    > 2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    > key="Catalog", value="cube"
    > 2010.05.21;10:39:52.423 DEBUG mdx: ""
    > 2010.05.21;10:39:52.423 DEBUG XmlaHandler.process: time = 0
    > 2010.05.21;10:39:52.424 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
    > 26.21%
    > 2010.05.21;10:39:52.424 DEBUG Invoking callbacks postAction
    > 2010.05.21;10:39:52.424 DEBUG XML/A response content
    > <?xml version="1.0" encoding="ISO-8859-1"?>
    > <SOAP-ENV:Envelope xmlns:SOAP-ENV="
    > http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
    > http://schemas.xmlsoap.org/soap/encoding/" >
    > <SOAP-ENV:Header>
    > <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    > /></SOAP-ENV:Header>
    > <SOAP-ENV:Body>
    > <cxmla:ExecuteResponse
    > xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    > <cxmla:return>
    > <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema"
    > xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    > targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    > xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance"
    > xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    > elementFormDefault="qualified">
    > <xsd:element name="root"/>
    > </xsd:schema>
    > </root>
    > </cxmla:return>
    > </cxmla:ExecuteResponse>
    > </SOAP-ENV:Body>
    > </SOAP-ENV:Envelope>
    >
    > 2010.05.21;10:39:52.429 DEBUG Invoking validate http header callbacks
    > 2010.05.21;10:39:52.429 DEBUG Unmarshalling SOAP message
    > 2010.05.21;10:39:52.431 DEBUG XML/A request content
    > <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    > http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance">
    > <Header>
    > <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
    > mustUnderstand="1"/>
    > </Header>
    > <Body>
    > <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
    > <Command>
    > <Statement/>
    > </Command>
    > <Properties>
    > <PropertyList>
    > <LocaleIdentifier>1033</LocaleIdentifier>
    >
    > <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    > <Catalog>cube</Catalog>
    > </PropertyList>
    > </Properties>
    > </Execute>
    > </Body>
    > </Envelope>
    > 2010.05.21;10:39:52.431 DEBUG Handling XML/A message header
    > 2010.05.21;10:39:52.431 DEBUG Invoking callbacks preAction
    > 2010.05.21;10:39:52.432 DEBUG Handling XML/A message body
    > 2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    > key="LocaleIdentifier", value="1033"
    > 2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    > key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    > 2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    > key="Catalog", value="cube"
    > 2010.05.21;10:39:52.432 DEBUG mdx: ""
    > 2010.05.21;10:39:52.432 DEBUG XmlaHandler.process: time = 0
    > 2010.05.21;10:39:52.433 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
    > 26.21%
    > 2010.05.21;10:39:52.433 DEBUG Invoking callbacks postAction
    > 2010.05.21;10:39:52.433 DEBUG XML/A response content
    > <?xml version="1.0" encoding="ISO-8859-1"?>
    > <SOAP-ENV:Envelope xmlns:SOAP-ENV="
    > http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
    > http://schemas.xmlsoap.org/soap/encoding/" >
    > <SOAP-ENV:Header>
    > <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    > /></SOAP-ENV:Header>
    > <SOAP-ENV:Body>
    > <cxmla:ExecuteResponse
    > xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    > <cxmla:return>
    > <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema"
    > xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    > targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    > xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance"
    > xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    > elementFormDefault="qualified">
    > <xsd:element name="root"/>
    > </xsd:schema>
    > </root>
    > </cxmla:return>
    > </cxmla:ExecuteResponse>
    > </SOAP-ENV:Body>
    > </SOAP-ENV:Envelope>
    >
    > 2010.05.21;10:39:52.435 DEBUG Invoking validate http header callbacks
    > 2010.05.21;10:39:52.435 DEBUG Unmarshalling SOAP message
    > 2010.05.21;10:39:52.437 DEBUG XML/A request content
    > <?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="
    > http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance">
    > <Header>
    > <Session xmlns="urn:schemas-microsoft-com:xml-analysis"
    > SessionId="" mustUnderstand="1"/>
    > </Header>
    > <Body>
    > <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    > <RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType>
    > <Restrictions>
    > <RestrictionList/>
    > </Restrictions>
    > <Properties>
    > <PropertyList>
    > <LocaleIdentifier>1033</LocaleIdentifier>
    > <Content>SchemaData</Content>
    > <Format>Tabular</Format>
    >
    > <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    > <Catalog>cube</Catalog>
    > </PropertyList>
    > </Properties>
    > </Discover>
    > </Body>
    > </Envelope>
    > 2010.05.21;10:39:52.437 DEBUG Handling XML/A message header
    > 2010.05.21;10:39:52.438 DEBUG Invoking callbacks preAction
    > 2010.05.21;10:39:52.438 DEBUG Handling XML/A message body
    > 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    > key="LocaleIdentifier", value="1033"
    > 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    > key="Content", value="SchemaData"
    > 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    > key="Format", value="Tabular"
    > 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    > key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    > 2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    > key="Catalog", value="cube"
    > 2010.05.21;10:39:52.440 DEBUG XmlaHandler.process: time = 1
    > 2010.05.21;10:39:52.442 DEBUG XmlaHandler.process: FREE_MEMORY: 126748kb
    > 25.74%
    > 2010.05.21;10:39:52.442 DEBUG Invoking callbacks postAction
    > 2010.05.21;10:39:52.442 DEBUG XML/A response content
    > <?xml version="1.0" encoding="ISO-8859-1"?>
    > <SOAP-ENV:Envelope xmlns:SOAP-ENV="
    > http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="
    > http://schemas.xmlsoap.org/soap/encoding/" >
    > <SOAP-ENV:Header>
    > <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    > /></SOAP-ENV:Header>
    > <SOAP-ENV:Body>
    > <cxmlaiscoverResponse
    > xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    > <cxmla:return>
    > <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
    > http://www.w3.org/2001/XMLSchema"
    > xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    > xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="
    > http://www.w3.org/2001/XMLSchema-instance"
    > xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    > targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    > elementFormDefault="qualified">
    > <xsd:element name="root">
    > <xsd:complexType>
    > <xsd:sequence>
    > <xsd:element name="row" type="row" minOccurs="0"
    > maxOccurs="unbounded"/>
    > </xsd:sequence>
    > </xsd:complexType>
    > </xsd:element>
    > <xsd:simpleType name="uuid">
    > <xsd:restriction base="xsd:string">
    > <xsdattern
    > value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>
    > </xsd:restriction>
    > </xsd:simpleType>
    > <xsd:complexType name="row">
    > <xsd:sequence>
    > <xsd:element sql:field="SchemaName" name="SchemaName"
    > type="xsd:string"/>
    > <xsd:element sql:field="SchemaGuid" name="SchemaGuid"
    > type="uuid" minOccurs="0"/>
    > <xsd:element sql:field="Restrictions" name="Restrictions"
    > minOccurs="0" maxOccurs="unbounded">
    > <xsd:complexType>
    > <xsd:sequence>
    > <xsd:element name="Name" type="xsd:string"
    > sql:field="Name"/>
    > <xsd:element name="Type" type="xsd:string"
    > sql:field="Type"/>
    > </xsd:sequence>
    > </xsd:complexType>
    > </xsd:element>
    > <xsd:element sql:field="Description" name="Description"
    > type="xsd:string"/>
    > </xsd:sequence>
    > </xsd:complexType>
    > </xsd:schema>
    > <row>
    > <SchemaName>DBSCHEMA_CATALOGS</SchemaName>
    > <Restrictions>
    > <Name>CATALOG_NAME</Name>
    > <Type>xsd:string</Type>
    > </Restrictions>
    > <Description>Returns information about literals supported by the
    > provider.</Description>
    > </row>
    > <row>
    > <SchemaName>DBSCHEMA_COLUMNS</SchemaName>
    > <Restrictions>
    > <Name>TABLE_CATALOG</Name>
    > <Type>xsd:string</Type>
    > </Restrictions>
    > <Restrictions>
    > <Name>TABLE_SCHEMA</Name>
    > <Type>xsd:string</Type>
    > </Restrictions>
    > <Restrictions>
    > <Name>TABLE_NAME</Name>
    > <Type>xsd:string</Type>
    > </Restrictions>
    > <Restrictions>
    > <Name>COLUMN_NAME<\n...Message truncated due to length...

  3. #3
    Julian Hyde Guest

    Default RE: [Mondrian] Re: Excel + refresh

    The error

    parentExp != null || nullParentValue == null

    means that in your schema, you have specified nullParentValue on a Level
    where you have not specified parentExp. You can only specify nullParentValue
    in a parent-child level.

    Julian



    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Manuel Darveau
    Sent: Friday, May 21, 2010 9:34 AM
    To: mondrian (AT) pentaho (DOT) org
    Subject: [Mondrian] Re: Excel + refresh


    I tried downgrading to 3.2.13343 and I get:

    2010.05.21;12:32:36.409 ERROR Errors when handling XML/A message
    mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results
    error
    at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2836)
    at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:548)
    at
    mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java
    :426)
    at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:330)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at
    org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
    at
    org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
    at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
    at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    at org.mortbay.jetty.Server.handle(Server.java:326)
    at
    org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
    at
    org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:
    879)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at
    org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:22
    8)
    at
    org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520
    )
    Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
    assert failed: parentExp != null || nullParentValue == null
    at
    mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:813)
    at mondrian.olap.Util.newInternal(Util.java:1492)
    at mondrian.olap.Util.assertTrue(Util.java:1484)
    at mondrian.olap.Util.assertPrecondition(Util.java:1554)
    at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:162)
    at mondrian.rolap.RolapLevel.<init>(RolapLevel.java:314)
    at mondrian.rolap.RolapHierarchy.<init>(RolapHierarchy.java:255)
    at mondrian.rolap.RolapDimension.<init>(RolapDimension.java:122)
    at mondrian.rolap.RolapCube.getOrCreateDimension(RolapCube.java:732)
    at mondrian.rolap.RolapCube.<init>(RolapCube.java:172)
    at mondrian.rolap.RolapCube.<init>(RolapCube.java:203)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:424)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:308)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:219)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:53)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:958)
    at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755)
    at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:166)
    at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
    at mondrian.olap.DriverManager.getConnection(DriverManager.java:74)
    at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2907)
    at
    mondrian.xmla.RowsetDefinition$MdschemaCubesRowset.populate(RowsetDefinition
    ..java:3740)
    at mondrian.xmla.Rowset.unparse(Rowset.java:167)
    at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2831)
    ... 18 more

    Manuel Darveau


    On Fri, May 21, 2010 at 10:51 AM, Manuel Darveau <manueldarveau (AT) gmail (DOT) com>
    wrote:


    Hi,

    I've just updated to mondrian 3.2.0.13583 and now excel gives me "the query
    did not run, or the database table could not be opened." error when I
    refresh.
    I didn't saw anything special in mondrian's log so I configured log4j in
    DEBUG and got this:

    2010.05.21;10:39:52.405 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.406 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.408 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope
    xmlns="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    <RequestType>DISCOVER_DATASOURCES</RequestType>
    <Restrictions>
    <RestrictionList/>
    </Restrictions>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>
    <Content>SchemaData</Content>
    <Format>Tabular</Format>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Discover>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.408 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.408 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.408 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.408 DEBUG DefaultXmlaRequest.initProperties:
    key="Content", value="SchemaData"
    2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
    key="Format", value="Tabular"
    2010.05.21;10:39:52.409 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: time = 0
    2010.05.21;10:39:52.409 DEBUG XmlaHandler.process: FREE_MEMORY: 131433kb
    26.69%
    2010.05.21;10:39:52.409 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.410 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <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>
    <cxmlaiscoverResponse
    xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    elementFormDefault="qualified">
    <xsd:element name="root">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element name="row" type="row" minOccurs="0"
    maxOccurs="unbounded"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    <xsd:simpleType name="uuid">
    <xsd:restriction base="xsd:string">
    <xsdattern
    value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-
    F]{12}"/>
    </xsd:restriction>
    </xsd:simpleType>
    <xsd:complexType name="row">
    <xsd:sequence>
    <xsd:element sql:field="DataSourceName" name="DataSourceName"
    type="xsd:string"/>
    <xsd:element sql:field="DataSourceDescription"
    name="DataSourceDescription" type="xsd:string" minOccurs="0"/>
    <xsd:element sql:field="URL" name="URL" type="xsd:string"
    minOccurs="0"/>
    <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo"
    type="xsd:string" minOccurs="0"/>
    <xsd:element sql:field="ProviderName" name="ProviderName"
    type="xsd:string" minOccurs="0"/>
    <xsd:element sql:field="ProviderType" name="ProviderType"
    type="xsd:string" maxOccurs="unbounded"/>
    <xsd:element sql:field="AuthenticationMode"
    name="AuthenticationMode" type="xsd:string"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:schema>
    <row>
    <DataSourceName>Provider=Mondrian;DataSource=cube;</DataSourceName>
    <DataSourceDescription>Data Warehouse</DataSourceDescription>
    <URL>http://localhost:8082/datawarehouse/xmla</URL>
    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    </row>
    </root>
    </cxmla:return>
    </cxmlaiscoverResponse>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    2010.05.21;10:39:52.417 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.418 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.420 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope
    xmlns="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Header>
    <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
    mustUnderstand="1"/>
    </Header>
    <Body>
    <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
    <Command>
    <Statement/>
    </Command>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>

    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Execute>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.421 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.421 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.422 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    2010.05.21;10:39:52.422 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.423 DEBUG mdx: ""
    2010.05.21;10:39:52.423 DEBUG XmlaHandler.process: time = 0
    2010.05.21;10:39:52.424 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
    26.21%
    2010.05.21;10:39:52.424 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.424 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope
    xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    /></SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    elementFormDefault="qualified">
    <xsd:element name="root"/>
    </xsd:schema>
    </root>
    </cxmla:return>
    </cxmla:ExecuteResponse>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    2010.05.21;10:39:52.429 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.429 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.431 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope
    xmlns="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Header>
    <BeginSession xmlns="urn:schemas-microsoft-com:xml-analysis"
    mustUnderstand="1"/>
    </Header>
    <Body>
    <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
    <Command>
    <Statement/>
    </Command>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>

    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Execute>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.431 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.431 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.432 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    2010.05.21;10:39:52.432 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.432 DEBUG mdx: ""
    2010.05.21;10:39:52.432 DEBUG XmlaHandler.process: time = 0
    2010.05.21;10:39:52.433 DEBUG XmlaHandler.process: FREE_MEMORY: 129093kb
    26.21%
    2010.05.21;10:39:52.433 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.433 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope
    xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    /></SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    elementFormDefault="qualified">
    <xsd:element name="root"/>
    </xsd:schema>
    </root>
    </cxmla:return>
    </cxmla:ExecuteResponse>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    2010.05.21;10:39:52.435 DEBUG Invoking validate http header callbacks
    2010.05.21;10:39:52.435 DEBUG Unmarshalling SOAP message
    2010.05.21;10:39:52.437 DEBUG XML/A request content
    <?xml version="1.0" encoding="UTF-8"?><Envelope
    xmlns="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Header>
    <Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId=""
    mustUnderstand="1"/>
    </Header>
    <Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    <RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType>
    <Restrictions>
    <RestrictionList/>
    </Restrictions>
    <Properties>
    <PropertyList>
    <LocaleIdentifier>1033</LocaleIdentifier>
    <Content>SchemaData</Content>
    <Format>Tabular</Format>

    <DataSourceInfo>Provider=Mondrian;DataSource=cube;</DataSourceInfo>
    <Catalog>cube</Catalog>
    </PropertyList>
    </Properties>
    </Discover>
    </Body>
    </Envelope>
    2010.05.21;10:39:52.437 DEBUG Handling XML/A message header
    2010.05.21;10:39:52.438 DEBUG Invoking callbacks preAction
    2010.05.21;10:39:52.438 DEBUG Handling XML/A message body
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="LocaleIdentifier", value="1033"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="Content", value="SchemaData"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="Format", value="Tabular"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="DataSourceInfo", value="Provider=Mondrian;DataSource=cube;"
    2010.05.21;10:39:52.438 DEBUG DefaultXmlaRequest.initProperties:
    key="Catalog", value="cube"
    2010.05.21;10:39:52.440 DEBUG XmlaHandler.process: time = 1
    2010.05.21;10:39:52.442 DEBUG XmlaHandler.process: FREE_MEMORY: 126748kb
    25.74%
    2010.05.21;10:39:52.442 DEBUG Invoking callbacks postAction
    2010.05.21;10:39:52.442 DEBUG XML/A response content
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SOAP-ENV:Envelope
    xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
    SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" >
    <SOAP-ENV:Header>
    <Session SessionId="" xmlns="urn:schemas-microsoft-com:xml-analysis"
    /></SOAP-ENV:Header>
    <SOAP-ENV:Body>
    <cxmlaiscoverResponse
    xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">
    <cxmla:return>
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:sql="urn:schemas-microsoft-com:xml-sql"
    targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"
    elementFormDefault="qualified">
    <xsd:element name="root">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element name="row" type="row" minOccurs="0"
    maxOccurs="unbounded"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    <xsd:simpleType name="uuid">
    <xsd:restriction base="xsd:string">
    <xsdattern
    value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-
    F]{12}"/>
    </xsd:restriction>
    </xsd:simpleType>
    <xsd:complexType name="row">
    <xsd:sequence>
    <xsd:element sql:field="SchemaName" name="SchemaName"
    type="xsd:string"/>
    <xsd:element sql:field="SchemaGuid" name="SchemaGuid"
    type="uuid" minOccurs="0"/>
    <xsd:element sql:field="Restrictions" name="Restrictions"
    minOccurs="0" maxOccurs="unbounded">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element name="Name" type="xsd:string"
    sql:field="Name"/>
    <xsd:element name="Type" type="xsd:string"
    sql:field="Type"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    <xsd:element sql:field="Description" name="Description"
    type="xsd:string"/>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:schema>
    <row>
    <SchemaName>DBSCHEMA_CATALOGS</SchemaName>
    <Restrictions>
    <Name>CATALOG_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description>Returns information about literals supported by the
    provider.</Description>
    </row>
    <row>
    <SchemaName>DBSCHEMA_COLUMNS</SchemaName>
    <Restrictions>
    <Name>TABLE_CATALOG</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_SCHEMA</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>TABLE_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Restrictions>
    <Name>COLUMN_NAME</Name>
    <Type>xsd:string</Type>
    </Restrictions>
    <Description/>
    </row>
    <row>
    <SchemaName>DBSCHEMA_PROVIDER_TYPES</SchemaName>
    <Restrictions>
    <Name>DATA_TYPE</Name>
    <Type>xsd:unsignedShort</Type>
    </Restrictions>
    \n...Message truncated due to length...

  4. #4
    Manuel Darveau Guest

    Default Re: [Mondrian] Re: Excel + refresh

    Julian

    You are right. I had nullParentValue="Unknown".
    I guess this is a bug in the schema workbench since I never put that
    parameter there (I was not aware of it).

    Now excel's refresh action is working when connecting to mondrian 3.2.13343
    but with 3.2.0.13583 excel still gives me "the query did not run, or the
    database table could not be opened." error when I refresh.

    Manuel

    On Fri, May 21, 2010 at 1:49 PM, Julian Hyde <jhyde (AT) pentaho (DOT) com> wrote:

    > The error
    >
    > parentExp != null || nullParentValue == null
    > means that in your schema, you have specified nullParentValue on a Level
    > where you have not specified parentExp. You can only specify nullParentValue
    > in a parent-child level.
    >
    > Julian
    >


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  5. #5
    Julian Hyde Guest

    Default RE: [Mondrian] Re: Excel + refresh

    Please log a bug on the workbench.

    I don't know what's causing your latest error.

    Julian


    _____

    From: Manuel Darveau [mailto:manueldarveau (AT) gmail (DOT) com]
    Sent: Friday, May 21, 2010 11:25 AM
    To: jhyde (AT) pentaho (DOT) com; Mondrian developer mailing list
    Subject: Re: [Mondrian] Re: Excel + refresh


    Julian

    You are right. I had nullParentValue="Unknown".
    I guess this is a bug in the schema workbench since I never put that
    parameter there (I was not aware of it).

    Now excel's refresh action is working when connecting to mondrian 3.2.13343
    but with 3.2.0.13583 excel still gives me "the query did not run, or the
    database table could not be opened." error when I refresh.

    Manuel


    On Fri, May 21, 2010 at 1:49 PM, Julian Hyde <jhyde (AT) pentaho (DOT) com> wrote:


    The error

    parentExp != null || nullParentValue == null

    means that in your schema, you have specified nullParentValue on a Level
    where you have not specified parentExp. You can only specify nullParentValue
    in a parent-child level.

    Julian



    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.