+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Defining Half Term Holidays Crashes Sims.NET in Technical; Our SIMS Manager has found that since the summer upgrade, whenever she tries to enter the dates for the recent ...
  1. #1

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395

    Defining Half Term Holidays Crashes Sims.NET

    Our SIMS Manager has found that since the summer upgrade, whenever she tries to enter the dates for the recent holiday, Sims.NET crashes, throwing all the users out.

    Has anyone else encountered this issue?

  2. #2

    Join Date
    Oct 2007
    Location
    Northamptonshire
    Posts
    311
    Thank Post
    20
    Thanked 82 Times in 69 Posts
    Rep Power
    45
    What actually happens on the SIMS server? Does the sqlserver process hang maxing out the cpu?

    We had a similar issue before, after running the generic SIMS re-indexing patch seemed to resolve the issue and when editing dates for the academic year afterwards it completed within a few minutes rather than hanging.

  3. #3

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395
    Just found this so time to give it a whirl:

    http://support.capitaes.co.uk/websup...18715.xmlFalse

  4. #4

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,698
    Thank Post
    335
    Thanked 516 Times in 484 Posts
    Rep Power
    180
    Quote Originally Posted by Ashm View Post
    What actually happens on the SIMS server? Does the sqlserver process hang maxing out the cpu?

    We had a similar issue before, after running the generic SIMS re-indexing patch seemed to resolve the issue and when editing dates for the academic year afterwards it completed within a few minutes rather than hanging.
    Out of curiosity, where did you get that re-index patch from? One of the Capita support guys told us to run it before, and would email it to us, and months later no email Just wondered if it's downloadable without going through cases etc again.

    Thanks,
    Steve

  5. #5

    Join Date
    Oct 2007
    Location
    Northamptonshire
    Posts
    311
    Thank Post
    20
    Thanked 82 Times in 69 Posts
    Rep Power
    45
    Quote Originally Posted by Steve21 View Post
    Out of curiosity, where did you get that re-index patch from? One of the Capita support guys told us to run it before, and would email it to us, and months later no email Just wondered if it's downloadable without going through cases etc again.

    Thanks,
    Steve
    I don't think it's freely available they just emailed it to me when we had the above issue.

    @tech_guy that's the same KB we followed but we only ended up needing to the "Apply Patch 14265 (Re-Indexes the SQL database)" step.

  6. Thanks to Ashm from:

    Steve21 (7th November 2012)

  7. #6

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,991
    Thank Post
    114
    Thanked 507 Times in 342 Posts
    Blog Entries
    2
    Rep Power
    286
    Be careful with the re-index patch.

    It does three things:

    1. Changes your database recovery model to 'simple'. This will utterly ruin your backups if you use the 'full' recovery model with log files backups, or you use log shipping. Watch out for this one, it's caught me out. We were on brown alert until I figured out what was causing the database recovery model to change.
    2. Re-index your databases. The main attraction (but why use a fill factor of 100?)
    3. Shrinks the log file to the minimum size possible. If you size your log files properly this will mess up your plan as you'll almost certainly experience auto-grow.


    It might not concern your set-up, but it's best to be aware of pitfalls.
    Last edited by jinnantonnixx; 7th November 2012 at 04:14 PM.

  8. Thanks to jinnantonnixx from:

    skunk (8th November 2012)

  9. #7
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    Thanks @jinnantonnixx, I tried to apply the re-index patch but it corrupted the DB due to someone logging into our terminal server in the seconds between the db being put into single user mode and DBupdate getting hold of it.

    But would have not noticed it swapping to 'simple' mode and screwing up my backups. Will look out for this when I get the chance to run it again.

  10. #8

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,991
    Thank Post
    114
    Thanked 507 Times in 342 Posts
    Blog Entries
    2
    Rep Power
    286
    That piece of code to shrink the log file (and setting the recovery to 'simple') has absolutely no place in a patch to reindex a database. They should take it out and publish the shrink patch as a separate patch.

    I just extracted the T-SQL that reindexes the databases and run it from a scheduled SQL job. We shouldn't have to do this, but it's better than knackering up your backups.

    Sigh.
    Last edited by jinnantonnixx; 8th November 2012 at 12:09 PM.

  11. #9

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,991
    Thank Post
    114
    Thanked 507 Times in 342 Posts
    Blog Entries
    2
    Rep Power
    286
    Quote Originally Posted by skunk View Post
    I tried to apply the re-index patch but it corrupted the DB due to someone logging into our terminal server in the seconds between the db being put into single user mode and DBupdate getting hold of it.
    If that happens again, you can put the database back to multi-user mode with this code. Run the code from a query window (after the rogue user has left the system, of course)

    Code:
    alter database [your_sims_database_name] set multi_user with no_wait
    Last edited by jinnantonnixx; 8th November 2012 at 01:41 PM. Reason: wrong text quoted

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] MS Excel crashes on SIMS.net reports
    By samtayuk in forum MIS Systems
    Replies: 2
    Last Post: 21st January 2012, 01:22 PM
  2. [SIMS] XML spreadsheet from SIMS.net crashing??
    By ljlbray in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2011, 06:46 AM
  3. SIMS edit pupils' details crashing SIMS.net
    By CadlaM in forum MIS Systems
    Replies: 12
    Last Post: 13th January 2009, 02:20 PM
  4. SIMs.net - User defined fields in reports?
    By duncane in forum MIS Systems
    Replies: 4
    Last Post: 21st September 2008, 08:07 AM
  5. Sims.net (unique user defined reports missing)
    By edie209 in forum MIS Systems
    Replies: 3
    Last Post: 15th June 2006, 12:17 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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