Report for December 2019

Report Date
December 2019

IS Applications Infrastructure Programme Report for Programme Owner Stefan Kaempf

 

Section One: Programme Commentary, RAG and Resources Update

Programme bdugets and projects timelines will be revised by end of January : significant changes expected. Budget changes for 20-21 will be fed into 3 year Planning.

 

 

 

 

Section Two: Projects Not Started  

Project Info Programme Manager's Commentary
 
 
AP90-062 INF148 Patching process for application components - Implementation (2 year project) Starting Feb 2020
   

Section Three: Projects in Progress

 

Project Info

Project Manager's Commentary

INF135

CF10 Updates

 

Milestones

Build -DEV

7-Feb-2020  

Migration - TEST

28-Feb-2020

Acceptance

13-Mar-2020  

Delivery

31-Mar-2019

Close

17-Apr-2020

 

 

RAG Status AMBER

Report by Sue Woodger for December 2019

Achievements in last period

  • The showstopper issue has now been resolved and work can re-commence on the CF10 to CFf2018 applications
  • Revised milestone dates have been agreed and submitted to wis
  • Discussions on end of life held for the following applications: VRS, EVES, Event Booking, PADS, Bookable rooms

Issues

  • None this month

Next Steps

  • All applications working on Dev
  • Further discussions regarding managing end-of-life of applications to be held (meetings booked on 7 and 23 Jan)

 

 

  • Commentary:  Project is AMBER: the showstopper issue has been resolved and we have re-planned the milestones for the project and Dev and DevTech resource is confirmed however we now need to look at the budget for the revised milestones as the original budget has now been exhausted. Revised costs submitted to programme manager and sponsor for consideration. 

 

INF142 (18-19 Project)

Move IS based Oracle databases to VMs and stretched cluster

Milestones

Deliver Migration progress checkpoint 1 28-Jan-2020
Deliver Migration progress checkpoint 2 25-Feb-2020
Deliver Migration to VMs complete 14-Apr-2020
Deliver Transfer to MSC complete 08-May-2020
Deliver Decommissioning Complete 29-May-2020
Deliver Delivery complete 05-Jun-2020
Close Project Closure 26-Jun-2020

 

RAG Status: AMBER

Overall status is Amber for now. The overall time and cost will be amended in January after WIKI service migrated. After WIKI service is migrated there are still 7 or 8 different services that need to be migrated to the new Virtual server solution. A new plan will be agreed to migrate each remaining service and this will confirm extra budget needed. The project has 35 days remaining in the current budget(10 days was incorrectly booked last month so we have actually gained a few days back in the budget this month).  I would guesstimate another 100 days in total  would need to be allocated  to this project. The project was initially due to complete around June 2020, it is likely to slip a few months at least and will enter the 2020-2021 financial year(August). A WIS/PICCL will be getting raised to justify budget change and the shift in major milestones. The Programme Manager and Sponsor have been informed of the forthcoming budget increase  and the project being pushed back a few months. This will be put through in late January.

 

Report by Mark Downey for December 2019

Achievements

  • Test Service for WIKI migrated
  • Engagement with ITI begun around some of the issues with backups and scheduling for VMs

 

Issues

  • Ongoing issues with backups and scheduling for new VMs - meeting setup with dev tech and ITI to discuss and plan to resolve.
  • Migration of WIKI service has taken longer than expected with some issues in the automation.
  • Plans for all migrations still to be created and finalised
  • Major issues with VMs working the way the technical teams expect in the Metro stretch cluster environment. As this is not the priority at present, getting the production issues with backups and the actual migrations done is, it may well be that the Metro stretch cluster is descoped at some point in near future. Awaiting further feedback from Technical staff looking into these issues.

Next Steps

  • Live services for WIKI  service to be migrated and tested and signed off as working
  • Updated documentation for dev, test and live database migrations for WIKI and finalised
  • New updated plan for project to be created and put in place with new  guesstimates to cost, time and dates for when each service can be moved to Virtual Server solution.
  • A request for more budget and to move the project back by probably 3 months will be made after full WIKI service migrated.

 

 

INF143 - MySQL Environment Migration

Milestones

 

CAM BLOGS MGEN migrated to Maria DB on LIVE 10-Dec-2019
Deployment Review for CAM, BLOGS, MGEN 19-Dec-2019
Closure 31-Jan-2020

 

RAG Status 

GREEN

 

 

Report by Tim Gray for December 2019

Achievements in Last Period

  • CAM, Blogs and MGen all successfully deployed to LIVE
  • Deployment Review for CAM, Blogs and MGen achieved
  • Limited planning for remainder of work

Issues/Risk

  • Planning for remainder of work delayed due to availability (strike and staff illness)

Next Steps

  • Complete planning for next stage, i.e. breaking down larger DBs and moving them onto individual VMs
  • Secure budget and resources for remaining work
  • Replan remaining milestones

 

INF146 Migration of SVN to GIT

Milestones

Milestone Due Date
Planning complete 13-Dec-2019
Delivery complete 24-Apr-2020
Closure 08-May-2020

RAG Status

GREEN

Report by Karen Stirling for November 2019

 

Achievements since last report

  • Meeting held with Elecosoft on 7th November to discuss options for upgrade and reviewing server details to understand if in place upgrade could be an option and understand where supplier can support upgrade activity
  • Costs provided for supplier engagement during upgrade
  • Draft estimates and review task activity

Issues

  • Elecosoft advised that although there is a cloud solution available they have not yet tested Timesheet application in the cloud. As this is currently outstanding we would not be able to move to the Cloud.
  • Production Management have been advised that for this project a move to a Cloud Solution is deemed not in scope
  • Due to limited PM availability due to annual leave, other project commitments and also technical resource not available due to Industrial action the planning milestone has been revised and approved

Next Steps

  • Arrange technical workshop
  • Project brief approval and submission to WIS
  • Project plan and resource assigned

 

The project status is GREEN

 

 

INF150 - AP90-014

AppsUtil OS EOL build Centos 7 version

 

Milestones

 

Milestones Date
Review INF150 estimate 22-Nov-2019 - delayed
Dev Applications 17-Jan-2020
Test Applications 06-Mar-2020
UAT Milestone 17-Apr-2020
Deliver Applications 15-May-2020
DSOR 29-May-2020
Close 12-Jun-2020

 

RAG Status

GREEN

 

 

Report by Anne Mathison for December 2019

Achievements

  • Limited progress in December due to the industrial action and holidays
  • All 6 frameworks have been set up
  • Completed migrated bisso DEV server work (BOBBISSO)
    • Bisso  puppet code has been created and the existing service has been migrated over and run
      • there is an issue with the load balancer
  • Completed migrated Static Web DEV server work (STATICWEB)
    • Static Web  puppet code has been created and the existing services have been migrated over and run
      • Office 365
      • MyEd 
      • there is an issue with the load balancer
  • JAVAIFACE is part way through

Issues

  • Issue with load balancer for bisso and static web
    • The load balancer is problematic due to a netscaler issue and
    • there is no health check traffic  (I191211-264 both issues are  with ITI)

Next Steps

  • Continuing risk of industrial action in semester 2
  • Progress and complete setting up DEV servers
    • All DEV puppet coding expected to be completed by mid Jan
    • Completed migrated JAVAIFACE DEV server work (JAVAIFACE)
      • JAVAIFACE  DEV puppet code has been created and the existing service has been migrated over and run
    • JAVAWEB DEV
    • EUCLID Generator DEV
    • OAUTH application DEV
  • Review project estimate in January.
  • Re-plan project to take account of industrial action given delays in Nov/Dec

The Project RAG status is Green 

 

INF151

Encryption at Rest Rollout (Multiyear 1 of 2)

Discretionary 

Plan

13-Jan-2020

Deliver

31-Mar-2021

Close

15-Apr-2021

 

RAG Status

GREEN

 

Report by Sue Woodger for December 2019

Achievements in last period

  • Stefan Kaempf confirmed as project sponsor

Issues

  • None this month

Next Steps

  • First draft of brief to be circulated and team brought together to discuss

 

INF152

ColdFusion Upgrades CF11

 

Milestones

Suspension end 

 1 May 20

 

 

RAG Status PROJECT SUSPENDED

Report by Sue Woodger for December 2019

Achievements in last period

  • Project suspension extended to 1 May 2020 as new closure date for INF135 confirmed as 17 April 2020

Issues

  • N/A

Next Steps

  • Suspension completes 1 May 2020

 

 

INF153 ASTA Upgrade

Compliance / Core Funded

Milestone Due Date
Planning complete 13-Dec-2019
Delivery complete 29-May-2020
Closure 12-Jun-2020

Report by Karen Stirling for November 2019

 

Achievements since last report

  • Project initiated
  • Project website created and project manager assigned
  • Initial meetings held with:
    • PMO - actions list created
    • Dev Tech and Tech Man - to discuss upgrade paths
  • Meeting with Elecosoft arranged 7th November
  • Draft project brief issued out to PMO and Project Sponsor for initial review and comment

Issues

  • Project already aware of EOL for Infrastructure e.g. Windows Server and SQL Server, advised Application v13 support end of October 2019
  • Head of Production Management has asked for the project team to discuss options for moving to Cloud Solution if not within this project then possibly an annual planning proposal
  • Due to meeting with supplier not until 7th then planning milestone will have to be moved out to 15th November from 5th November to accommodate discussions and upgrade options

 

Next Steps

  • Arrange technical workshop
  • Project brief approval and submission to WIS
  • Project plan and resource assigned

 

The project status is GREEN

 

 

INF154 - AP90-015

Annual Upgrade of Development Tools + frameworks 19/20

 

Milestones

 

Stage Milestone Due Date
Execute P2- Migrate puppet master 4 to puppet master 5 17-Feb-2020
Execute P3 Puppet - test and fix puppet master 5 04-Mar-2020
Deliver P3 Puppet library code master 5 delivered 19-Mar-2020
Execute Python Acceptance Tested 27-Mar-2020
Deliver Python Delivered 08-Apr-2020
Deliver Oracle Grid Delivered 21-May-2020
Execute Bamboo Acceptance Tested 29-May-2020
Deliver Bamboo Delivered 11-Jun-2020
Execute Nexus Updated 16-Jun-2020
Deliver Nexus Delivered 25-Jun-2020
Execute Overall Acceptance Milestone 02-Jul-2020
Deliver Overall Deployment Signoff 24-Jul-2020
Close Close 31-Jul-2020

 

RAG Status GREEN

 

Report by Anne Mathison for December 2019

Achievements

  • Completed Sentry upgrade
  • Delivered Sentry upgrade  

Issues

  • No issues

Next Steps

  • Meeting with project sponsor to agree sequence of Development tools upgrades plans
  • Replan development tools upgrades as agreed
  • P2 to migrate puppet master 4 to puppet master 5 is likely to start early this year
    • Dates to be agreed

Green RAG status this month

 

INF155:  Annual Infrastructure Rationalisation Decommissioning

Milestones

Stage Milestone Due Date
Analyse Updates to Portfolio/Programme Managers 13-Dec-2019
Analyse Analysis complete & reports accepted (ASOR) 17-Jan-2020
Deliver Delivery point for final migrations 21-Feb-2020
Deliver Delivery complete (DSOR) 28-Feb-2020
Close Project Closure 13-Mar-2020

 

RAG Status GREEN

 

Report by Mark Downey for December 2019

Achievements

  • Updates to WIKI and new round of communications to owners of servers and services affected with End of Life dates emphasising repeatedly the end of life date of 14th January 2020 for Windows 2008 servers
  • Few more  servers now have definitive decommission dates and/or mitigation plans. Updated Wiki and working with technical resources to create Unidesk tickets for these switch off of servers events.
  • Updated Abacus database with information.

 

Issues

  • Not all service owners are providing mitigation or indeed feeding back. I am escalating this through the sponsor.

 

Next Steps

  • Continuation of work with servers and databases on the End of Life lists. A few more plans or mitigation required. Working with Sponsor and service owners to look at potential for extended security updates cover for individual servers without plans
  • Look into Linux server list for decommission more thoroughly as to date have been concentrating on the Windows 2008 servers, which are more pressing.
  • Organise decommission of any additional servers highlighted as unused from feedback from email communications.

 

 

Project Info Project Managers Commentary
INF140 Middleware patching process

Closure Report

Project Closed 2-Aug-2012

INF145 Protecting Data in the Enterprise Data Warehouse (EDW)

Closure Report

Project Closed 8-Aug-2019

   
   
   
   
   
   
   
   
   
   
   
   
   
   
Programme Status
RAG Status
Overall
AMBER
Has formal escalation taken place?
Yes
Escalated to
Escalation of INF135 to Stefan and also REDs on INF135 and INF152
RAG Commentary
Core Systems have conflicted on project manager, requiring replanning of several projects and possibly suspension. Technical issues on INF135 will impact on other projects and potentially budget for 19/20 and 20/21.