Hi.

I'm using XslTransform to transform a XML resulting of a Dataset into a
Excel spreadsheet.
But the object is not releasing its resources while transforming and
I'm getting OutOfMemory errors.

The memory consumed by the process exceeds the size of 306 MB and the
IIS process is recycled, resulting in a "Server Application
Unavailable" error message. The size of the XML result might be 15MB.

The memory of process grows during de Transform method call.

I've already tried use a FileStream to keep memory free but has no
effect.

Any ideas?
Thanks.

Would you please share your code and data? We will look at it.

Thanks,
Zafar
[quoted text, click to view]

Thanks for answer.

How can I debug stylesheet outside of an ASP.NET/IIS application ?

The fonts are below:

The transform code: --------------------------------------

Private Function GetExcelXML(ByRef dts As DataSet, ByVal XSLT As
String) As Stream

Dim xmlDoc As New XPath.XPathDocument(New
StringReader(dts.GetXml))
Dim xslTran As New Xsl.XslTransform
Dim xmlStream As New FileStream(Server.MapPath("buffer.tmp"),
FileMode.Create)
Dim xmlTW As New XmlTextWriter(xmlStream,
System.Text.Encoding.UTF8)

dts =3D Nothing 'release memory of dataset

xmlTW.Formatting =3D Formatting.Indented
xmlTW.Indentation =3D 1
xmlTW.WriteStartDocument()

xslTran.Load(NomeArqXSLT)
xslTran.Transform(xmlDoc, Nothing, xmlTW, Nothing) 'here
the memory increase too much

Return xmlStream
End Function


XSLT file: --------------------------------------

<xsl:stylesheet version=3D"1.0"
xmlns=3D"urn:schemas-microsoft-com:office:spreadsheet"
xmlns:xsl=3D"http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl=3D"urn:schemas-microsoft-com:xslt"
xmlns:user=3D"urn:my-scripts"
xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:x=3D"urn:schemas-microsoft-com:office:excel"
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet">
<xsl:template match=3D"FloorSpaceDetalhe">
<Workbook xmlns=3D"urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:x=3D"urn:schemas-microsoft-com:office:excel"
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html=3D"http://www.w3.org/TR/REC-html40">
<Styles>
<Style ss:ID=3D"Default" ss:Name=3D"Normal">
<Alignment ss:Vertical=3D"Bottom" />
<Borders />
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
<Style ss:ID=3D"s21">
<Font ss:Bold=3D"1" />
<Alignment ss:Horizontal=3D"Center" ss:Vertical=3D"Bottom" />
</Style>
</Styles>
<Worksheet>
<xsl:attribute name=3D"ss:Name">Floor Space Detalhado</xsl:attribute>
<Table>
<Row>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Categoria</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Sub-Categoria</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Capacidade</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Marca</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Modelo</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Data</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Rede</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Cidade</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Estado</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Loja</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Tipo Loja</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Promotor</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Coordenador</Data>
</Cell>
<Cell ss:StyleID=3D"s21">
<Data ss:Type=3D"String">Lojas da Rede</Data>
</Cell>
</Row>
<xsl:apply-templates select=3D"Dados" />
</Table>
</Worksheet>
</Workbook>
</xsl:template>
<xsl:template match=3D"Dados">
<Row>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsCategoria" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsSubCategoria" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsCapacidade" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsMarca" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsModelo" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dtFloorSpace" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsRede" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsCidade" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"cdEstado" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsLoja" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsTipoLoja" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsUsuario" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"String">
<xsl:value-of select=3D"dsCoordenador" />
</Data>
</Cell>
<Cell>
<Data ss:Type=3D"Number">
<xsl:value-of select=3D"LojasRede" />
</Data>
</Cell>
</Row>
</xsl:template>
</xsl:stylesheet>


XML Source: --------------------------------------
---->>> In my source, the number of records (Dados) is 23983.

<FloorSpaceDetalhe>
<Dados>
<dsCategoria>Freezer horizontal</dsCategoria>
<dsSubCategoria>Residencial</dsSubCategoria>
<dsCapacidade>De 251 a 350 litros</dsCapacidade>
<dsMarca>Metalfrio</dsMarca>
<dsModelo>DA301</dsModelo>
<dtFloorSpace>16/02/2006</dtFloorSpace>
<dsRede>Ricardo Eletro</dsRede>
<dsCidade>Betim</dsCidade>
<cdEstado>MG</cdEstado>
<dsLoja>8</dsLoja>
<dsTipoLoja>Rua</dsTipoLoja>
<dsUsuario>Andrea Beatriz Maciel </dsUsuario>
<dsCoordenador>Val=E9ria Andrade</dsCoordenador>
<LojasRede>9</LojasRede>
</Dados>
</FloorSpaceDetalhe>

[quoted text, click to view]

Which overload of the Transform method exactly do you use, could you
show the code how exactly you call the Transform method, what kind of
arguments you pass in? Have you debugged that stylesheet outside of an
ASP.NET/IIS application to check whether there are no problems with the
stylesheet? What's the size of the input XML?

--

Martin Honnen --- MVP XML