<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic out of memory exception in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/out-of-memory-exception/m-p/51755#M6748</link>
    <description>I have tried to parse excel file with more than 9000 records

The parsing is getting complete but when I tried to open the collection it's giving me the exception.

&amp;nbsp;</description>
    <pubDate>Wed, 07 Mar 2018 11:01:00 GMT</pubDate>
    <dc:creator>AmitPatnaik</dc:creator>
    <dc:date>2018-03-07T11:01:00Z</dc:date>
    <item>
      <title>out of memory exception</title>
      <link>https://community.blueprism.com/t5/Product-Forum/out-of-memory-exception/m-p/51755#M6748</link>
      <description>I have tried to parse excel file with more than 9000 records

The parsing is getting complete but when I tried to open the collection it's giving me the exception.

&amp;nbsp;</description>
      <pubDate>Wed, 07 Mar 2018 11:01:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/out-of-memory-exception/m-p/51755#M6748</guid>
      <dc:creator>AmitPatnaik</dc:creator>
      <dc:date>2018-03-07T11:01:00Z</dc:date>
    </item>
    <item>
      <title>There are knowledgebase…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/out-of-memory-exception/m-p/51756#M6749</link>
      <description>There are knowledgebase articles on this.&amp;nbsp; &amp;nbsp;The root cause can be found by doing an internet search for '.NET datatable out of memory' - it is how .NET handles large blocks of data in datatables (which is effectively what a collection is), the solution is to reorchestrate your solution to handle smaller bits of the data at a time and also the knowledgebase article has advice about removing rows and invoking the garbage collector.</description>
      <pubDate>Wed, 07 Mar 2018 17:04:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/out-of-memory-exception/m-p/51756#M6749</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-03-07T17:04:00Z</dc:date>
    </item>
  </channel>
</rss>

