Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

System.OutOfMemoryException

Hi experts,

In my SAP addon i have a report..for that report query A will retrieve 45,000 records...& another query B will retireve 35 records.

so based on the loop:

function 1
                 For Each in B.rows.count-1 '35 records
                                    For each in A.rows.count-1 '45,000 records
                                    ---------------------------------------------------
                                    ---------------------------------------------------
                                    ----------------------------------------------------
                                    Next
                 Next

         function 2  --------

         function 3  --------

so,the actual problem is when i click the print of the report due to multiple loops...the following error message was thrown......

System.OutOfMemoryException: Exception of type
System.OutOfMemoryException was thrown

can anybody suggest me some ideas that how to overcome this issue that without going to the IO exception.....iam doing my report in crystal reports 11.

regards,

dileep varma.

Former Member
Former Member replied

Hi Dileep,

Using a paging query and processing smaller number of records (for example 100 records at a time) might help.

Aravind

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question