+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, When running a report - System.OutOfMemoryException in Technical; Hi When running a report I ran it perfectly, for a whole year group, creating a letter as RTF from ...
  1. #1

    Join Date
    Sep 2011
    Location
    Cardiff, UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    When running a report - System.OutOfMemoryException

    Hi

    When running a report I ran it perfectly, for a whole year group, creating a letter as RTF from sims behaviour data. However today I have added the school header to the template and it wont let me run - giving me the error System.OutOfMemoryException.

    Anyone know how I can get this to work - presumably my school logo has made the template too large a file to run, can i free up memory? Is it memory on my pc or on the server?

    Any help please

    Ieu

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    I'm not sure if the memory problem is on the server or client (though I suspect client as some larger reports can only be run on the server) but I'd suggest adding in a registration group filter and running them a reg group or two at a time

  3. #3

    Join Date
    Mar 2013
    Posts
    172
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    29
    Maybe freeing up some memory in your computer my help as well as a teacher had a similar error message. They had to free up some memory in their computer hard drive and it worked

  4. #4

    Join Date
    Sep 2011
    Location
    Cardiff, UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hmmm.... i think it maybe the machine, although i've got 165GB free, so don't think i need to free much up, and also i've try running it on 3 machines - say issue!

    I dont really know how to run it on the server itself - is this possible/ simple to do?

  5. #5
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    297
    Thank Post
    36
    Thanked 68 Times in 40 Posts
    Rep Power
    34
    Are you using the express edition of SQL2008?

    When you hit preview when reporting, does the report show with no errors?
    Last edited by Ghostgame; 2nd July 2013 at 01:08 PM. Reason: Just had a look on SupportNet

  6. #6

    Join Date
    Sep 2011
    Location
    Cardiff, UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Sorry i dont know which SQL i'm using, but when i run a preview my report runs fine, and when I run the report - without the school badge image on the top it runs and merges correctly into the RTF, however when i add the image to the top of the template it fails.

  7. #7
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    297
    Thank Post
    36
    Thanked 68 Times in 40 Posts
    Rep Power
    34
    If you have a SupportNet account with Capita, KB91561 might help

    If you don't have one, sign up for one as it can be very handy when needing to solve an issue quickly for SIMS.

    Basically the KB says that it is due to your logo being outside of the page boundary.
    You need to edit your user defined template and bring the logo in closer.
    Should fix the report.

  8. Thanks to Ghostgame from:

    ieuanprice (2nd July 2013)

  9. #8

    Join Date
    Sep 2011
    Location
    Cardiff, UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi

    thanks all,, adjusting my margins sorted the problem out, what a silly thing causing so much grief

    Cheers

    Ieua



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Fault Code when running a report
    By Solus in forum MIS Systems
    Replies: 1
    Last Post: 4th May 2013, 09:48 AM
  2. SIMS crashing out when running a report
    By RSoP_Robbers in forum MIS Systems
    Replies: 39
    Last Post: 1st July 2010, 08:52 AM
  3. Running a report against a deleted reg group
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 30th January 2009, 09:26 PM
  4. Replies: 7
    Last Post: 12th October 2008, 09:33 PM
  5. sims times out when trying to run various reports
    By projector1 in forum MIS Systems
    Replies: 2
    Last Post: 5th July 2006, 01:54 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •