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 ...
7th November 2012, 11:49 AM #1
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?
7th November 2012, 12:21 PM #2
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.
7th November 2012, 12:21 PM #3
7th November 2012, 12:24 PM #4
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.
Originally Posted by Ashm
7th November 2012, 12:43 PM #5
I don't think it's freely available they just emailed it to me when we had the above issue.
Originally Posted by Steve21
@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.
Thanks to Ashm from:
Steve21 (7th November 2012)
7th November 2012, 12:55 PM #6
Be careful with the re-index patch.
It does three things:
- 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.
- Re-index your databases. The main attraction (but why use a fill factor of 100?)
- 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.
Thanks to jinnantonnixx from:
skunk (8th November 2012)
8th November 2012, 11:52 AM #7
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.
8th November 2012, 12:00 PM #8
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.
Last edited by jinnantonnixx; 8th November 2012 at 12:09 PM.
8th November 2012, 12:49 PM #9
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)
Originally Posted by skunk
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
By samtayuk in forum MIS Systems
Last Post: 21st January 2012, 01:22 PM
By ljlbray in forum MIS Systems
Last Post: 21st September 2011, 06:46 AM
By CadlaM in forum MIS Systems
Last Post: 13th January 2009, 02:20 PM
By duncane in forum MIS Systems
Last Post: 21st September 2008, 08:07 AM
By edie209 in forum MIS Systems
Last Post: 15th June 2006, 12:17 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)