Error System.OutOfMemoryException when running a 2013R2 Rep

BillNavtn

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

davmac1

How many pages is your 15 day report?
This is a known memory problem with large datasets. How large is yours?

Alex_Chow

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?

clausl

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

BillNavtn

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

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

Perfect, and Tunisia is of course not part of the North American version ;-)

/Claus Lundstrøm

Ignacio_Pequeño

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;