IFS Business Reporter 'Out of Memory' error

  • 8 September 2020
  • 2 replies

Userlevel 1
Badge +4

It seems like IFS Business Reporter was pushed to users PCs after a recent IFS delivery was applied. We are having many issues with our BR reports currently published with an earlier version of BR. I have run the report through the Upgrade Utility but when I run the report, I receive the following error message:

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.Runtime.InteropServices.Marshal.GetObjectForNativeVariant(IntPtr pSrcNativeVariant)
   at System.Runtime.InteropServices.CustomMarshalers.EnumeratorViewOfEnumVariant.MoveNext()
   at Ifs.Application.Br.ExcelInterface.Vsto.ExcelRange.GetEnumerator()
   at Ifs.Application.Br.Expansion.ReportExpandUtil.GetExpandedRange(IExcelRange inputRange, IVirtualExcelSheet vsheet, IExcelWorksheet excelWorkSheet)
   at Ifs.Application.Br.Core.DesignModel.NameManager.HandleSheetRepeaterNameRanges(IExcelName designModeNameRange)
   at Ifs.Application.Br.Core.DesignModel.NameManager.SwapAndCacheNamedRanges()
   at Ifs.Application.Br.Rendering.ReportExecutionMgr.PrintReport(Dsrd dsrd, DesignDsodTemplate template, List`1 physicalDataSets, Exception& exception, Int32 lastDataSetId, ReportGeneratorBase generator, IReportLoaderOperations operations)
   at Ifs.Application.Br.Rendering.ContainerObjects.BrExecutionTemplateExe.ProcessDsrdAndPrintReport(Exception& exception, IReportLoaderOperations operations, Dsrd dsrd, DesignDsodTemplate dsodTemplate, List`1 physicalDatasets, Int32 reportDataSetCount, ReportGeneratorBase generator, IReportLoaderOperations opearations)
   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ExecuteReportFromClient(Boolean cacheEnabled)
   at Ifs.Application.ExcelReporter.MainWorkbook.ExecuteClick(Boolean cacheEnabled)


Has anyone experienced this before? If so, is there a solution to remedy this? Any help would be greatly appreciated. Thanks.

2 replies

Userlevel 6
Badge +13

Hi Chris,

Can you try selecting 'Enable compression of result set' option under 'Report Options' of the BA client

and check the behaviour?


Userlevel 1
Badge +2

@chrisbrigg , 

If you are getting this issue due to a new delivery of Business Reporter. It is recommended to get Support from IFS as this could be an error in the software it self, or could be due to increased amount of data fetched to the report.

To confirm whether this is a software issue, please run the same report using the old IFS Business Reporter client you had.

The latest (as of writing) IFS Business Reporter release for Apps 10 is 5.0.22. If this is an issue in this particular version, it is highly likely that this might have gotten fixed in 5.0.22.