Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Unanswered:

    Edit the code.

  2. #2
    Join Date
    Jun 2009
    Posts
    2

    Smile Memory error: While attempting to store a string, a string was found that was larger

    I execute the query:
    Code:
    <?xml version="1.0" encoding="utf-8"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
      <SOAP-ENV:Body>
        <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
          <Command>
            <Statement>
              Select [Customer].[Customer Geography].members ON COLUMNS From [Adventure Works]
            </Statement>
          </Command>
          <Properties>
            <PropertyList>
              <DataSourceInfo>Adventure Works DW</DataSourceInfo>
              <Format>Tabular</Format>
              <Catalog>Adventure Works DW</Catalog>
              <AxisFormat>TupleFormat</AxisFormat>
            </PropertyList>
          </Properties>
        </Execute>
      </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
    And get the result:

    Code:
    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> 
      <soap:Body> 
        <ExecuteResponse xmlns="urn:schemas-microsoft-com:xml-analysis"> 
          <return> 
            <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"> 
              <Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /> 
              <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"> 
                <Error ErrorCode="3238199300" Description="Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" /> 
              </Messages> 
            </root> 
          </return> 
        </ExecuteResponse> 
      </soap:Body> 
    </soap:Envelope>
    How to fix it?

  3. #3
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59
    What version you are using?
    And also check the following thread..
    Memory Error
    MohammedU
    SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •