+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
MIS Systems Thread, SIMS June 2009 Main Release - Delay in Technical; From SupportNet: Dear Colleagues We have decided to delay the SIMS 2009 Main Release for between 5 and 10 working ...
  1. #1

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142

    SIMS June 2009 Main Release - Delay

    From SupportNet:
    Dear Colleagues

    We have decided to delay the SIMS 2009 Main Release for between 5 and 10 working days.

    We are doing this in order to investigate and resolve an upgrade issue that some customers are reporting when applying patches to their SIMS system. Our initial investigations have shown that this problem could also affect upgrades to the June Main Release and therefore we need to address this problem now. The revised release date will be published on Supportnet as soon as possible.

    We apologise for the inconvenience that this may cause.

    Regards,
    Jonathan Wood
    SIMS Product Manager (Technical and Releases)

  2. #2

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I'm glad they are trying to fix this before the release!!

  3. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Me too.

    The application of patch and upgrades issues arose as a by product of the new SIMS Homepage in March. Staff not logging off SIMS 'legally' are still logged in as ghosts the following day. I think the fact that their panels were still trying to address the database when their account was 'closed' has something to do with the problem.
    I don't want to keep having to convert to single user mode just to apply a patch and then have to convert back again to multi-user after applying the patch or upgrade!

    Graham, I hope you get it sorted quickly!

  4. #4

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    If you disable tcpip in the sql configuration that works too instead of locking to single user

  5. #5

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Quote Originally Posted by sarah09 View Post
    If you disable tcpip in the sql configuration that works too instead of locking to single user
    yeah thats what i did to get round it, our SMIS team gave us this little app that disabled all of the users except our admin login. problem was it then did not give us the option to enable this. i think it was down to us not using the sa account. but hey

    I just disabled the network card when i did the update! as then no bugger could connect hehe.

    --- another option might be to stop the services for SQL, but i dont know weather the update requires these services.

    James.

  6. #6

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    6,875
    Thank Post
    393
    Thanked 581 Times in 532 Posts
    Rep Power
    173
    What was the problem?

  7. #7

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Quote Originally Posted by Edu-IT View Post
    What was the problem?
    If you mean the problem users are getting when installing new patch's etc.

    Basically when applying any new updates/patches it attempts to lock the database, but if you have users still logged into sims this fails. (you used to be able to just end any sessions, but that dont do anything anymore as the sql account is still active)

    So the only way of stopping this error from happening is doing any of options above. so you can then successfully update sims.

    james

    -- So the error you were recieving latley when updating about the database being locked, ^^ that is why.

  8. #8


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    Could be wrong but the last I heard removing the network cable during the upgrade wasn't supported because the server wasn't in it's normal environment. (Something about the network needing to be present and the S:\ mapped etc on the server even after solus had downloaded the packages).

    Not sure whether this was just best practice or enforced for some other reason.

    I used to struggle getting staff of of the system so we opted for 7am upgrades rather than fight for access.

  9. #9
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    862
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    I am SO glad that they are sorting out the applying patches issue!

    I usually do it at 5pm and send a global email round saying the update will be done at that time, please be off SIMS.

    My back is covered, then!

  10. #10
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Yeah applying patch problem was annoying. SMIS told me how to get round it by locking it down to 1 admin user i.e. -m switch for MS SQL 2005 service.

  11. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Quote Originally Posted by kmount View Post
    Could be wrong but the last I heard removing the network cable during the upgrade wasn't supported because the server wasn't in it's normal environment. (Something about the network needing to be present and the S:\ mapped etc on the server even after solus had downloaded the packages).
    The "S drive" shouldn't be a network drive on the server, it should be a physical path so you have the correct access etc. I believe mr Edwards (Capita) recommend disabling TCP\IP which would kick off all the remote users, as EduTech etc said, Matt Griffin (SMIS) creating a tool that disables all the SIMS SQL accounts appart from the one user your applying the update as.

    I believe the issue is Capita uses the standard Microsoft command to lock the database into single user mode, ofcourse this doesn't appear to work (thanks Microsoft), so the new dbupgrade will disable all the users minus the current user. I think it's down to not being able to run SOLUS as the SA user. I tend to find download only via SOLUS then manually upgrade via dbupgrade with the SA works. Still looooads more hassle. Bit strange as you can use the SA user for FMS but not SIMS?! Go figure!!

  12. #12
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Matt,
    I posted the KB for this on SupportNet.

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Quote Originally Posted by Sivadam View Post
    Matt,
    I posted the KB for this on SupportNet.
    What? :confussed:

  14. #14
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,202
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    29
    @EduTech: You'll need the SQL Server Instance running otherwise it won't be able to apply to changes to the database that runs inside the instance.

    A few years back removing the network cable actually stopped the upgrade from performing (Strangely you could plug it into a switch that wasn't conencted to anything else so the network would look like it's there but without anyone being able to access it!)


    Wes

  15. #15
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Sorry Matt - it's me that's confused!
    I actually gave the KB to our Technical Staff. I didn't post it on SupportNet. I just explained the issue above.
    It's senility setting in!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. SIMS June Update
    By skunk in forum MIS Systems
    Replies: 33
    Last Post: 1st August 2008, 01:28 AM
  2. THREE jobs in West Kent (close 16th June and 25th June)
    By elsiegee40 in forum Educational IT Jobs
    Replies: 0
    Last Post: 6th June 2008, 07:34 AM
  3. Replies: 0
    Last Post: 13th May 2008, 06:46 PM
  4. SIMS August Main Release is here
    By DrFrankenMouse in forum MIS Systems
    Replies: 40
    Last Post: 2nd September 2007, 01:20 PM
  5. SIMS.net February main release delayed
    By NetworkGeezer in forum MIS Systems
    Replies: 19
    Last Post: 6th February 2007, 08:25 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
  •