Report for June 2019

Report Date
June 2019

IS Applications Infrastructure Programme Report for Programme Owner Stefan Kaempf

 

Section One: Programme Commentary, RAG and Resources Update

Overall Programme RAG: RED

All projects planned, start dates set, continuing projects as planned or allocated budget for unplanned. Requests for project managers made and PM's have been assigned to all projects. Additional projects INF144 and INF145 added to programme.

However, an increasing number of projects are reporting lack of resource and conflict of resource - if there are no resolution in May 2019 then programme will have to re-consider viability of delivering many of its benefits in 18/19 (Risk raised)

 

 

 

 

 

 

 

 

Section Two: Projects Not Started  

Project Info Programme Manager's Commentary
   
   

Section Three: Projects in Progress

 

Project Info

Project Manager's Commentary

INF134 AP89-023

Logging Data Retention

Milestones              

End of Planning 29-Apr-2019
Delivery 28-Jun-2019
Project Closure 12-Jul-2019

                                                                            

RAG Status

Green

Report by Ian Mitchell for June 2019

Achievements

Milestones completed successfully:
  • Feasibility of using Centralised Logging ** -24 June : Meeting held with ITI as regards strategy for use of ITI's central logging service for services managed by IS Apps, outcome seen here:

https://secure.projects.ed.ac.uk/unpublished/project/inf134/milestones/feasibility-of-using-centralised-logging

  • Delivery - Agree Retention Policy

Recommendations for selected key Technologies

Milestones outstanding
  • Recommendations for selected key Technologies - still in progress at time of writing, expected complete by 5 July.
  • Project closure

Issues

none

Next steps

Complete milestone 'Recommendations for selected key Technologies' proceed to closure – ‘Project Closure’ due 12 July.

INF135

CF10 Updates

 

Milestones

Build -DEV

30-Aug-2019  

Migration - TEST

23-Sep-2019

Acceptance

16-Oct-2019  

Delivery

25-Oct-2019

Close

06-Nov-2019

 

 

RAG Status GREEN

Report by Sue Woodger for June 2019

Achievements in last period

  • Project is now fully resourced and resources are approved and assigned. This means however that the project is carrying over to next year and this and been approved by project sponsor and programme manager and the total cost for 19/20 is 275d and this includes completion of INF135 at 75d and 200d for the CF11 upgrades. (piccl 17 refers). Spend for 18/19 to date is 68d.
  • Revised dates for the project have now been considered and have been approved by the team and WIS

Issues

  • Support for CF10 ran out on 16 May 2019 therefore no patching will be done on CF10

Next Steps

  • Complete build

Project is GREEN again as resourcing has been confirmed and revised milestone dates agreed.

 

INF138 AP89-017

Annual DR Review and Tests

Milestones              

 

End of Planning 29-Mar-2019
Delivery 14 Jun-2019
Project Closure 28-Jun-2019

                                                            

RAG Status

BLUE

Report by Ian Mitchell for June 2019

Achievements

Milestones completed successfully:

  • Delivery - DR documentation complete
  • Close     Project Closure

Final Documentation now stored here.

Closure Report here.

 

Outcome

 No.

 Description

 Priority

 (MoSCoW)

 Outcome

O1 To establish the set of components which are used by the priority services Applications    
D1.1 Review all applications and components which make up the Top and Medium priority services Must Have Achieved
O2 To review and update a Disaster Recovery plan, where required, for each of the applications noted as top and medium priority services     

 D2.1

 Establish a DR position for each top priority application, where required 

 Must Have

Achieved

D2.2 Establish a DR position for each medium priority application, where required Must Have Achieved
D2.3 For each Top and Medium priority service, if none already available, produce a DR document/plan. This must include a written document, if none already available, on how to recover each application. This may link to other documents Must Have Achieved
O3 Review Disaster Recovery plans in established central repository and communicate any changes to appropriate support teams    
D3.1 Review storage and access to Master Documentation containing DR position for each component and detailing each Top and Medium priority Service DR Document / Plan  Should Have Achieved

 

Key Learning Points

  1. An agreement that going forward this documentation is maintained as a BAU activity by Technology Management.
  2. 18 recommendations for DR documentation process delivered in report. The DR documentation can be found on the IS Applications System Documentation Dashboard SharePoint site.

Issues

none

Next steps

  • none, project closed
  • Close     Project Closure date was 28 June

INF139 Annual Upgrades of Development Tools + frameworks 18/19 (18-19 Project)

AP89-018

Milestones

Stage Milestone Date
Accept PMP Build / Acceptance Signoff 28-Jun-2019
Deliver PMP Deployed Signoff 12-Jul-2019
Accept Oracle Grid Acceptance Signoff 12-Jul-2019
Deliver Oracle Grid Deployed Signoff 18-Jul-2019
Accept Over All Build / Acceptance Sign Off 22-Jul-2019
Deliver Overall Deployment Sign-Off 31-Jul-2019
Close Close 02-Aug-2019

RAG Status

 GREEN

Report by Anne Mathison for June 2019

Achievements

Sentry

  • Sentry UAT completed in June
  • Sentry went Live 13-June

Bamboo

  • Bamboo  completed UAT in June
  • Bamboo  went LIVE on 25-June

ASTA

  • ASTA discussed and PMO Manager has decided that this work cannot be completed in INF139
  • The 2 ASTA milestones have been withdrawn

PMP

  • Work has been planned for Tech Man and is in progress

Oracle Grid

  • Dev Tech cannot accommodate this work
  • Tech Man will plan this work

General

  • Discussed and agreed with Tech Man and Dev Tech how some applications are upgraded
  • Where point release - complete via support
  • Where server upgrade - complete via project
  • This should be agreed in the Brief of the next project to decide which applications fall into this category

Issues

  • No issues

Next Steps

Oracle Grid

  • Meeting planned for mid July to see if Oracle Grid is feasible in 2018/19 Project
  • Tech Man will be implementing Oracle Grid in July if possible

PMP

  • PMP Completing UAT
  • PMP Live Planned for July

General

  • Overall UAT signed off
  • Overall Deployment signed off
  • Prepare draft closure report
  • Close project

GREEN RAG status

 

INF140 - Middleware Patching Process

Milestones

Milestones

Initial Patch Cycle Complete 10-Jul-2019
Patch Strategies Complete 19-Jul-2019
Delivery 22-Jul-2019
Project Close 02-Aug-2019

 

RAG Status

GREEN

Report by Karen Stirling for June 2019

 

Achievements in Last Period

  • Plan activity for Consul and MS SQL Server completed 
  • Milestones reviewed and approved at WIS

Issues

  • Patching activity can happen in parallel with remaining patching strategies to be completed
  • Dev Tech resource not allocated for agreed slot however review with resource manager they have now been assigned in line with the revised milestones
  • WIS have requested sight of patching strategy on delivery of project
  • Unspent budget of 30 days returned to INF programme as per agreement with Project Sponsor and Programme Manager, approved budget now showing as 70 days. Further review of budget will be completed and returned to programme in due course.

Next Steps

  • Complete remaining strategies
  • Complete Consul patching in all environments
  • Complete MS SQL Server patching in all environments

 

The project is GREEN.

 

 

 

INF141 (18-19 Project)

Milestones

Close Closure

12

Jul-2019

 

 

 

RAG Status

GREEN

 

 

 

Report by Maurice Franceschi (for Nigel Binns) for June 2019

 

It has been agreed with heads of Production and Development to close the project, with a new project in 19-20 to continue the SVN work. Development Team will need to re-assess their approach and commitment to availability accordingly.

 

Achievements this period

  • resource clarification and assignments - not achieved
  • VSS completed

Issues

  • software development resources still not booked

Next Steps

  • closure of project  

INF142 (18-19 Project)

Move IS based Oracle databases to VMs and stretched cluster

Milestones

Analyse Systems Analysis 02-Aug-2019
Build Build & Test Prototype 02-Aug-2019
Integrate Replanning & Estimation 23-Aug-2019
Execute Build progress checkpoint 04-Oct-2019
Execute Build of Virtual Servers 08-Nov-2019
Deliver Migration progress checkpoint 1 17-Dec-2019
Deliver Migration progress checkpoint 2 11-Feb-2020
Deliver Migration to VMs complete 27-Mar-2020
Deliver Transfer to MSC complete 24-Apr-2020
Deliver Decommissioning Complete 22-May-2020
Deliver Delivery complete 05-Jun-2020
Close Project Closure 26-Jun-2020

 

 

RAG Status: GREEN

 

Report by David Watters for June 2019

Achievements

  • Build of VMs and CentOS version of database ongoing
  • Work continued on analysis of server estate and licences required

Issues

  • Some tasks taking a bit longer than anticipated; issues being worked through

Next steps

  • Build of VMs and CentOS version of database to continue
  • Final version of DEV and TEST database servers (for Wiki) to be built

INF143 - MySQL Environment Migration

Milestones

Plan End of Planning 14-Nov-2018
Analyse         Application Register Complete 11-Jan-2019
Design Infrastructure Design Complete        01-Feb-2019
Build Acceptance Sign-off 09-May-2019
Build Infrastructure Build Complete 14-May-2019
Deliver Delivery sign-off 31-Oct 2019
Close Project Close 15-Nov-2019

 

RAG Status

GREEN

Report by Geoff  Cropley for June 2019

 

Achievements in Last Period

  • An Additional 100 days and an extension of the project into the academic year has been approved
  • Test servers for pilot applications have been built and configured with Puppet
  • Maria DB has been installed and configured on the pilot application Test Environment including encryption at rest
  • As the result of SME absence, these milestones were slightly behind of schedule but the time has been recovered during the reporting period

Issues

  • None

Next Steps

  • PICCL amending Delivery and Closure milestones to reflect uplift in budget and extension into 2019-2020
  • Complete Mirroring
  • Commence Performance Testing
  • Complete Bamboo configuration  
  • Build the test environments for the remaining services
  • Migration of pilot applications to Test servers and commence system testing

INF145 (18-19 Project)

Protecting Data in the EDW

Milestones

Build Deployment to Test Environment 08-Jul-2019
Accept

Test Completion Sign-off

12-Jul-2019
Deliver

Deployment Go-live Sign-off

22-Jul-2019
Deliver DSOR Sign-off 31-Jul-2019
Close Project Closure 02-Aug-2019

 

 

 

RAG Status

AMBER

Report by Kevin Hone for June 2019

 

Achievements

  • The project is making steady progress with issues raised on Jira and assigned to other team members.
  • To ensure timely completion, additional resource have been assigned to work alongside the DB Administrator leading on this assignment.

Issues

  • Problems have been encountered with the set-up of the trial environment with a help call raised to IS Support.
  • Consideration was given to raising the project priority as a consequence of resource conflicts. This was escalated and has since been resolved with more time allocated to the DB Administrator. 

Next Steps

  • Regular weekly meetings have been diarised to monitor project progress and pursue delivery to planned timelines.
  • Prepare for implementation.

 

Section Four: Closed or Withdrawn Projects

 

 

Project Info Project Managers Commentary

INF127 (17-18 Project)

LAMP / WIMP Platform Upgrade

Project Closed 12-Oct-18

Closure Report

Closure Milestone

Project Closed 12-Oct-18

(INF136) Annual Business Technology End of Life Analysis Withdrawn Feb 2019
INF144 Encryption at Rest - Analysis

Closure Report

Project Closed 3-May-2019

INF121 - Migrate core databases to Oracle 12c

Closure Report

Project Closed 3-May-2019

INF129 - Wiki Database Resilience Improvement

Closure Report

Project Closed 3-May-2019

INF137 - Annual Infrastructure Rationalisation Decommissioning

Closure Report

Project Closed 14-June-2019