+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Sims Error during/after Nov 2007 Upgrade in Technical; Hi All, Left the SIMS .net November 2007 upgrade running last night as it was taking an age to complete ...
  1. #1

    Join Date
    Sep 2005
    Posts
    143
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    19

    Sims Error during/after Nov 2007 Upgrade

    Hi All,
    Left the SIMS .net November 2007 upgrade running last night as it was taking an age to complete and this morning I found the following error on the server.

    Code:
    sims error
    Your database has been restored correctly and can be used normally.
    
    The error reported was 
    Cannot open database "SIMS" requested by the login. The login failed.
    Login failed for user 'sims_sysman'.
    
    The SQL Batch which caused the error was : 
    
    ------------------------------------------------------------------------------------------------------------------
    /*  TEST
    Description: Unit Tests
         Author: Kient
           Date: 20/01/2005
        Dataset: sims_dev_b2b_kient
    1. Create Unauthorized B2B Contract
        begin transaction
        --------------------------
        -- Check data
        --------------------------
        declare @b2b_person_id int
        
        select @b2b_person_id = bb_per_export_person_id from sims.bb_per_export_person 
        where external_id = 'aac7cbaa-96be-4195-abf4-fa64d649a6c4'
                                
        print('bb_per_export_person_id: ' + convert(varchar(5),@b2b_person_id))
        print('Data in Outbound')
        select * from sims.bb_per_export_contract
        where   bb_per_export_person_id = @b2b_person_id
        --------------------------
        -- Run sp
        --------------------------
        print('Start execute')
        exec sims.per_pia_EditEmployee_UpdateB2BContracts @b2b_person_id, '<?xml version="1.0" encoding="ISO-8859-1"?><data> <row bb_per_export_contract_id="0" deleted="0" unchanged = "0" contract_start_date="2005-01-01T00:00:00" contract_type="P" ems_id="0" external_id="e71340a5-5c87-4f07-bd71-3e40fc60e938" hours_per_week="0" post="3" service_term_code="111" weeks_per_year="53" status="I" /></data>'
                                                            
        print('End execute')
        --------------------------
        -- Check result
        --------------------------
        print('Data in Outbound')
        select * from sims.bb_per_export_contract
        where   bb_per_export_person_id = @b2b_person_id
        
        rollback transaction
        
        Result
        
        bb_per_export_person_id: 4
        Data in Outbound
        bb_per_export_contract_id bb_per_export_person_id external_id                          ems_id       authorised deleted unchanged comment                                                                                              post   contract_type service_term_code start_date                                             end_date                                               hours_per_week payroll_number   weeks_per_year termination_reason_code superannuation_code post_reason_code
    
    BIG SNIP as it wouldnt let me post it all!
    The first thing it says is your database has been restored - great I thought, ill just get westfield to try and do the upgrade tonight instead.
    When a client ran sims on their workstation it begun to upgrade and then doesnt log in giving the following error:
    Fault code : 1283-8946-9300
    Cannot find table 20. : System.Index.OutOfRangeException

    I think what has happened is this:
    The CD Westfield sends copies across updated simsapplicationsetup.exe etc so the workstations see this and automatically update, but the database isnt patched upto the same version and thus a version mismatch and it fails.
    Support website says I should run the patches again but it complains about sysman being logged in and wont update, needing the SQL SA user/pass to force it. Rebooting server/restarting services doesnt rectify this and westfield isnt open till 9am

    Anyway I can fix this without hoping someone is at the end of the phone ~9am?

    EDIT:
    Managed to get it working-ish for now. Replaced the SIMS .net folder in program files with a non-updated workstation copy and renamed simsapplicationsetup.exe on the S drive so that it cannot be found by the auto-update.
    Just need the patches to be applied properly now so we can update!
    Last edited by Frazer; 11th January 2008 at 01:00 PM.

  2. #2
    paul's Avatar
    Join Date
    Jun 2005
    Location
    Preston
    Posts
    170
    Thank Post
    2
    Thanked 12 Times in 8 Posts
    Rep Power
    22
    Westfield should have sent you a CD out with the November upgrade copy the sims setups folder from this replace those on your server/s: drive, once you have done this go to DB Upgrade on the server this will update the SIMS DB manually DB updates are located within the SIMS setups directory included when you coppied files from the CD.

  3. #3

    Join Date
    Sep 2005
    Posts
    143
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    19
    Yeah thats what ive done so far and what has caused this problem.
    I think I just need westfield to try and upgrade using the SQL SA user/pass to force out any logged in users. Bit odd how it picks up 'sysman' as a logged in user and refuses to upgrade as you need sysman to start the upgrade process.

    Knew I should have stayed in bed yesterday.

  4. #4
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Do ppl still get CDs for upgrades... thought pretty much everyone uses SOLUS now.

  5. #5

    Join Date
    Sep 2005
    Posts
    143
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    19
    Usually it is SOLUS but we do still get the odd CD, probably for those larger updates, although hopefully we will be on 100Mbit come March and it shouldnt be a problem!

  6. #6
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    100Mbit! tinternet connection... nice.

  7. #7

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,850
    Thank Post
    110
    Thanked 598 Times in 514 Posts
    Blog Entries
    1
    Rep Power
    227
    A 100mbit connection is standard for Secondary Schools in Lancs/Cumbria.

  8. #8

    Join Date
    Dec 2006
    Location
    Preston, Lancashire
    Posts
    126
    Thank Post
    13
    Thanked 12 Times in 11 Posts
    Rep Power
    19
    Don't know if you got this sorted, but I had same issue. Capitas recommendation was to keep installing til it worked....and it eventually did, after 4 attempts and a days downtime (very very time consuming). If it happened in industry there'd be hell to pay!!!!!!!

  9. #9

    Join Date
    Oct 2005
    Location
    East Midlands
    Posts
    748
    Thank Post
    17
    Thanked 109 Times in 69 Posts
    Rep Power
    38

    100mbit

    Quote Originally Posted by Geoff View Post
    A 100mbit connection is standard for Secondary Schools in Lancs/Cumbria.
    This only means between the school and the local concentrator or connection endpoint. 100mbit of pure net connectivity would cost a fortune!, I suspect the RBC has probably 1Gb to the net or something to satisfy the requirements of providing internet connection to various schools.

    Ash.

  10. #10

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183
    @ashok: The link is onto SuperJANET IIRC (10Gbit) at Lancaster Uni. However, getting back onto topic, there is a SOLUS server within the Lancs WAN so upgrades are pulled pretty quick.

  11. #11

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    Quote Originally Posted by f21970 View Post
    Capitas recommendation was to keep installing til it worked....and it eventually did, after 4 attempts and a days downtime (very very time consuming). If it happened in industry there'd be hell to pay!!!!!!!
    Iím intrigued by your comments but as you post anonymously canít investigate it further Ė if youíd like to give me a call reference I will.

    I canít imagine one of our service desk people team recommending continuously trying the same thing and am completely confused as to why that might have worked after 5 goes?



SHARE:
+ Post New Thread

Similar Threads

  1. Exchange 2007 upgrade questions again
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 29th October 2007, 11:22 AM
  2. SIMS August upgrade.
    By User3204 in forum MIS Systems
    Replies: 1
    Last Post: 20th August 2007, 09:14 PM
  3. Office 2007 upgrade
    By sweeper in forum Windows
    Replies: 2
    Last Post: 24th July 2007, 07:03 PM
  4. Sharepoint 2003 upgrade >> 2007
    By zag in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 25th April 2007, 10:32 AM
  5. Replies: 7
    Last Post: 14th September 2006, 11:37 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
  •