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 ...
13th January 2010, 09:03 PM #1
- Rep Power
Sims Autumn update stuck
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
IDG Tech News
13th January 2010, 10:31 PM #2
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.
13th January 2010, 11:59 PM #3
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.
By matt40k in forum MIS Systems
Last Post: 11th February 2011, 01:12 PM
By Simcfc73 in forum MIS Systems
Last Post: 8th January 2010, 08:05 PM
By pete in forum MIS Systems
Last Post: 26th December 2009, 02:34 PM
By localzuk in forum MIS Systems
Last Post: 1st December 2009, 03:37 PM
By FN-GM in forum MIS Systems
Last Post: 4th January 2008, 08:58 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)