Overview

Scope

  1. All active EUCLID SITS environments - DEV , TEST , LIVE, TRN & DUST  are upgraded to a supported version of SITS (expected to be 9.6.0 and then 9.7.0)
  2. Testing of  other dependent downstream systems: EUGEX and other systems directly connected to SITS
  3. Refresh of all environments from LIVE
  4. Performance testing before and after upgrades on all environments
  5. Enhance automation of read-only performance testing on LIVE environment 
  6. Investigate increasing coverage of automated testing 

Not in Scope:

  • No end-to-end testing to all downstream systems fed from EUGEX, as no expected impact on EUGEX views which feed local school data feeds, feed to counselling, disability systems etc…
  • Load testing (other than comparison of performance before and after upgrade as above)
  • Update StuTalk version (current version is 2.0)

 

Objectives

  1. Upgrade SITS Student Record to a supported version of SITS.
  2. Minimise downtime for the LIVE system during upgrade
  3. Refresh DEV, TEST, TRN, DUST from LIVE 
  4. Allow sufficient time for  testing to reduce chance of critical post-go live issues
  5. Minimise overall time duration of the upgrade project - so that there is minimal disruption to other project work (ie. quick back-to-back deployments into DEV / TEST / LIVE)

Acknowledging that Objectives 4 and 5 are in conflict with one another. The more time taken for testing in each environment, the slower the progression from DEV to TEST to LIVE, and more disruption to other projects although the testing should result in lower risk of issues in LIVE. Such testing time will be reduced by re-using automatic testing and performance scripts.

 

Deliverables

  1. Refresh non live environments (DEV, TEST, TRN, DUST) from LIVE

Must

  1. Upgrade EUCLID DEV  

Must

  1. Complete technical test of DEV. Carry out any required re-work. Obtain downtime for STAR / EUGEX

Must

  1. Upgrade EUCLID TEST    

Must

  1. Complete regression test of TEST and any required re-work. Obtain downtime for STAR / EUGEX

Must

  1. Upgrade EUCLID TRN  

Must

  1. Upgrade EUCLID LIVE, Complete  testing and sign off

Must

  1. Refresh TEST from LIVE after LIVE upgrade (required because of the roll over in 19/20 and need 18/19 data)

Must

  1. Clone EUCLID DUST

Must

  1. Review and extend automated performance and testing scripts

Should

  1. Comparison of  performance of all environments before and after upgrade

Must

  1. Research about creating automated pre-production environments – Assess options (Dev/Dev Tech)

Could

  1. The following JIRAs have  been kept open, in order that they can be more appropriately picked up by the next SITS upgrade project in 18/19.

SAC061-45

  Holding pages - jira to cover puppet feature branch for IP restrictions

SAC061-49 

 update imp plan to include holding pages

 

Must

  1. Migrate regression tests from old spreadsheet format to TestRail

Should

Benefits

  • Student Record system remains within the standard support contract with SITS supplier Tribal 
  • Access to new functionality in new version
  • Understanding of any impact that the upgrade has on performance

 

Success Criteria

  • Minimum disruption to LIVE service during upgrade. Aim to complete it over a week-end
  • Minimum impact on downstream systems. Aim to complete it over the same week-end
  • No short term degradation in the performance of the service using the automated performance tests and analytics
  • Minimum impact to training in TRN
  • Successful liaison with project teams working on other projects within SITS
  • Few open issues, and quick resolution of any critical issues in DEV / TEST/ TRN and LIVE - as these could impact other project work and testing in DEV and TEST, and will impact business users in the LIVE environment

Project Milestones

Stage

Milestone

Due Date

Plan

End of planning 23-Nov-2018
Execute Refresh DUST 23-Nov-2018
Execute
  Refresh DEV environment
23-Nov-2018
Execute Refresh TEST environment
  30-Nov-2018
Execute
  Refresh TRN (Training) environment  
  30-Nov-2018
Execute Upgrade DEV 07-Dec-2018
Execute
  Sign off Dev Upgrade
21-Dec-2018
Execute Upgrade TEST 11-Jan-2019
Execute Sign off TEST upgrade - ASOR 04-Feb-2019
Execute Upgrade TRN 15-Feb-2019
Deploy Upgrade LIVE 10-Mar-2019
Deploy Upgrade Live - Fall Back date TBC 24-Mar-2019
Deploy  Deployment Sign Off Review (DSOR) 25-Mar-2019
Deploy Second refresh of TEST 12-Apr-2019
Deploy Clone DUST from Live 17-Apr-2019
Closure Close 3 May 2019

 

Project Info

Project
SITS Double Software Upgrade
Code
SAC076
Programme
Student Systems Partnership SSP
Management Office
ISG PMO
Project Manager
Franck Bergeret
Project Sponsor
Brandi Headon
Current Stage
Close
Status
Closed
Project Classification
Run
Start Date
01-Oct-2018
Planning Date
23-Nov-2018
Delivery Date
11-Mar-2019
Close Date
03-May-2019
Programme Priority
1
Overall Priority
Normal
Category
Compliance

Documentation

Plan