+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Sims Autumn update stuck in Technical; Hi, I have run the Autumn release and it has stuck at Executing SQL Batch 3491. Does anyone now if ...
  1. #1

    Join Date
    Jan 2010
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Sims Autumn update stuck

    Hi,

    I have run the Autumn release and it has stuck at Executing SQL Batch 3491. Does anyone now if I can stop the upgrade as it is not resoding and just start again? I really need this working for tomorrow as the school need to get the exam results.

    Any help would be great

  2. #2


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,638
    Thank Post
    275
    Thanked 778 Times in 605 Posts
    Rep Power
    223
    The GUI not refreshing during the batch scripts is not uncommon, Go get a coffee and give it time to start responding.

    If it's still really not working (check process list to get an idea of load and look at the current sql activity if you have SQL Managment Studio available)........

    I'd stop the update, restore the sql database from backup and then re-run the update from SOLUS / the CD. Assuming the previous parts went ok, it should jump straight to the sql updates. If all goes well, test everything before you go home - it's an arse this time of night, but it's much less painful than encountering problems and frantic staff at 8am.

    Capita would recommend restoring the whole server from backup, or at least all the SIMS-related parts. That's your call.

  3. #3
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Did it start to respond eventually, it usually does.

    If it did fail I'd go with what Pete said - once you've restored the DB I'd grab the iso image of the upgrade CD and run it that way rather than downloading through SOLUS.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release
    By matt40k in forum MIS Systems
    Replies: 49
    Last Post: 11th February 2011, 01:12 PM
  2. SIMS 2009 12 Autumn Update
    By Simcfc73 in forum MIS Systems
    Replies: 2
    Last Post: 8th January 2010, 08:05 PM
  3. SIMS Autumn 09 Release - Experiences?
    By pete in forum MIS Systems
    Replies: 35
    Last Post: 26th December 2009, 02:34 PM
  4. SIMS.net Autumn release - Options 5.7
    By localzuk in forum MIS Systems
    Replies: 0
    Last Post: 1st December 2009, 03:37 PM
  5. SIMS getting stuck when updating.
    By FN-GM in forum MIS Systems
    Replies: 20
    Last Post: 4th January 2008, 08:58 AM

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
  •