Error System.OutOfMemoryException when running a 2013R2 Rep

BillNavtn
BillNavtn Member Posts: 9
edited 2015-04-08 in NAV Three Tier
Hi everyone,

This Exception is thrown when running a report on NAV 2013 R2:
An error occured during local report processing.
An error has occured during report processing.
Exception of type 'System.OutOfMemoryException' was thrown.

The report is The standard 10804: G/L Detail Trial Balance.

I tried to run the report 4 the whole year.. ==> Exception
Then, for a trimestre ==> Exception
And then 4 a month, the same Exception was thrown. So i tried for 15 days and finally the data is displayed.

So I think the problem is relied to the big size of data and the big numbers of records.

Am asking about what is the limitation to number of records sent to RTC.
And if there is a Hotfix or a rollup to fix this problem or it's a memory problem ?? :( Someone help me

Answers

  • davmac1
    davmac1 Member Posts: 1,283
    How many pages is your 15 day report?
    This is a known memory problem with large datasets. How large is yours?
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    There's no solution to this other than you filter your data so the dataset is smaller.

    Microsoft NAV team really, REALLY need to find a permanent solution. Pushing the blame to the RDLC team is not going to solve it. :thumbsdown:

    Consider throwing out RDLC may be a good start?
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • clausl
    clausl Member Posts: 455
    Looks like this report has been fixed in RollUp1 for NAV 2013 R2, but only for France:
    https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2901573

    ID Title Functional area Changed Objects
    353965 Performance problems with the Journals and the G/L Detail Trial Balance reports in the French version Finance REP 10801 REP 10804

    If not also fixed in the North America version, I would request Microsoft to fix this as well. If you cannot wait, you could download the French version and see what they have done to make this report faster.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • BillNavtn
    BillNavtn Member Posts: 9
    davmac1 wrote:
    How many pages is your 15 day report?
    This is a known memory problem with large datasets. How large is yours?

    Don't know the number of pages. but i have about 160.000 rows to print each month.
  • BillNavtn
    BillNavtn Member Posts: 9
    clausl wrote:
    Looks like this report has been fixed in RollUp1 for NAV 2013 R2, but only for France:
    https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2901573

    ID Title Functional area Changed Objects
    353965 Performance problems with the Journals and the G/L Detail Trial Balance reports in the French version Finance REP 10801 REP 10804

    If not also fixed in the North America version, I would request Microsoft to fix this as well. If you cannot wait, you could download the French version and see what they have done to make this report faster.

    /Claus Lundstrøm

    Thanks, It really Works.. 1933 pages are printed now :)
  • clausl
    clausl Member Posts: 455
    Perfect, and Tunisia is of course not part of the North American version ;-)

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • Ignacio_Pequeño
    Ignacio_Pequeño Member Posts: 1
    Hi,
    recently i had the same problem with Report 10723 in the spanish localization. If you don't need the preview, the solution to avoid the error is try to call the report by code and generate the pdf, excel or word document through then functions: SAVEASPDF, SAVEASEXCEL and SAVEASWORD. This solution is only possible if you have a layout valid and call the report on RTC client for 2009 versions and 2013 , 2015 etc.

    In my case I obtained a pdf of 9500 pages (17 Mb) and an excel of 180000 rows (23Mb).


    I create a report with first dataitem and request option page like the report 10723 for pass the filters and parameters.
    Variables:
    Name ConstValue
    Text001 <Generating Report...>
    Text002 <Select File...>
    Text003 <Select a valid file name in options.>


    Name DataType Subtype Length
    PrintAmountsInAddCurrency Boolean
    ZeroBalance Boolean
    Rep10723 Report Main Accounting Book
    W Dialog
    FileNameServer Text
    FileNameClient Text
    FileMgt Codeunit File Management
    OptType Option


    Code in OnPreReport
    IF FileNameClient = '' THEN
    ERROR(Text003);
    CLEAR(Rep10723);
    Rep10723.FunSetView("G/L Account".GETVIEW);
    Rep10723.FunSetParms(PrintAmountsInAddCurrency,ZeroBalance);
    W.OPEN(Text001);

    CASE OptType OF
    OptType::pdf:
    BEGIN
    FileNameServer := FileMgt.ServerTempFileName('pdf');
    Rep10723.SAVEASPDF(FileNameServer);
    END;
    OptType::excel:
    BEGIN
    FileNameServer := FileMgt.ServerTempFileName('xlsx');
    Rep10723.SAVEASEXCEL(FileNameServer);
    END;
    END;


    FileMgt.DownloadToFile(FileNameServer,FileNameClient);

    W.CLOSE;

Categories