Sims Error during/after Nov 2007 Upgrade

[Frazer]

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.

 

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, ' '
                                                       
   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!

Edited January 11, 2008 by Frazer

[paul]

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.

[Frazer]

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.

[apeo]

Do ppl still get CDs for upgrades... thought pretty much everyone uses SOLUS now.

[Frazer]

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!

[apeo]

100Mbit! tinternet connection... nice.

[Geoff]

A 100mbit connection is standard for Secondary Schools in Lancs/Cumbria.

[f21970]

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!!!!!!!

[spc-rocket]

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.

[Ric_]

@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.

[PhilNeal]

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?