Report for July 2019

Project Info

Project Manager's Commentary

INF135

CF10 Updates

Milestones

RAG Status GREEN

Report by Sue Woodger for July 2019

Achievements in last period

• Project timescales were revised due to resourcing issues. We now have resource in place from 5 August when project will fully recommence.
• We have had intermittent software dev resource in July to work on the outstanding jiras

Issues

• None this month

Next Steps

• Build for Windows machine  to be completed
• Outstanding jiras completed to allow Linux build to be completed

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

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

AP89-018

Milestones

No further milestones

RAG Status

 BLUE

Report by Anne Mathison for July 2019

Achievements

PMP

• PMP has been completed successfully in TEST
• PMP in LIVE will be carried out by Tech Man in August 
  • At meeting on 17-Jul with Tech Man, Apps Supp and Project Manager agreed PMP in LIVE will be completed in August within support (less than 2 days effort) 

Oracle Grid

• Oracle Grid only exists in LIVE and so the TEST Signoff was withdrawn
• Tech Man has successfully completed all the security patches
• Tech Man successfully completed the upgrade in LIVE
• Oracle Grid went Live on 25-July

General

• Overall Acceptance signed off
• Overall Deployment signed off
• Closure completed, reviewed and signed off
• Budget reduced for INF139 to 120 days (from 140 days)
• Project passed to WIS for Closure on 29-July
• Close project

Issues

• No issues

Next Steps

• No next steps

BLUE RAG status

INF140 - Middleware Patching Process

Milestones

RAG Status

AMBER

Report by Karen Stirling for July 2019

Achievements in Last Period

• Consul completed in Dev, Test and Live
• MS SQL Server completed in Test as part of WSUS package
• Closure report completed and reviewed / signed off by project team
• Closure submitted to WIS for approval 

Issues

• 8 Outstanding strategies to be completed under next project as agreed in project closure meeting with key project team members and project sponsor
• Unspent budget of 36 days (20 +16 on closure) returned to INF programme as per agreement with Project Sponsor and Programme Manager, approved budget now showing as 34 days.
• WIS submission not approved as Development Services SOM advised he has not seen any of the documents, he needs to agree that the project is fit for purpose. Subsequent meeting held with SOM to discuss project output and agree points to allow closure, awaiting confirmation that he is happy to sign off

Next Steps

• Re-submit closure to WIS

This project is AMBER as closure approval via Internal Application process not approved, review outstanding points with Development Services SOM for them to confirm closure and resubmit.

INF142 (18-19 Project)

Move IS based Oracle databases to VMs and stretched cluster

Milestones

RAG Status: GREEN

Report by David Watters for July 2019

Achievements

• Build of VMs and CentOS version of database still being carried out
• Clarification round resources required in ITI Unix team

Issues

• Some tasks have needed to be revisited as more is discovered about what we are doing

Next steps

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

INF143 - MySQL Environment Migration

Milestones To Be Replanned

RAG Status

RED

Report by Maurice Franceschi for July 2019

Achievements in Last Period

• Technical challenges have been experienced with loss of access to the Dev environment and  despite a number of escalations this has delayed the project
• Key technical resource absence has also compounded the delay

The original plan and of this project was to move to a virtualised environments and to use MariaDB in preference to MySQL. As a by product of the project, the University would stop using MySQL and avoid a £27000 licence maintenance renewal. The project scope did not include decommissioning of the MySQL environments.  However, as of 30th July 2019 clarification has been received from Oracle, the licence owner of MySQL, that to avoid the licence renewal liability, all MySQL environments must be decommissioned. This must be accomplished by Mid October 2019. The impact of this objective change increases pressure on the project to deliver the full decommissioning .  

A change request has been raised to increase the overall project priority from Higher to Highest. A further change request needs to be documented to add a number of additional deliverables including;

• The migration of ALL MySQL applications from the current MySQL servers to a Virtual Server running Maria DB
• The migration of ALL other applications running on these servers to ‘somewhere else’
• Decommission of DEV /TEST / LIVE  Linux 6 Platforms used by MySQL / file shares.  
• Closing down the servers by 25/10 (so that Oracle will not charge for licensing

Other contingency mitigation options have been considered but no recommendation  has been put forward.  These include;

• Mariabackup
• SQL Dumps
• File System Snapshots
• LVM

Issues

• Absence of technical resources impacting the delivery of the project 

Next Steps

• PICCL amending the scope and deliverables of the project
• A analysis of all applications that must be migrated from the environment
• Confirmation of the date of notice of termination of MySQL licence contract
• A  decommissioning plan for the environments
•  
• Complete Puppet and Bamboo configuration to enable build automation
• Build Test, Staging and Live environments for the pilot application (EdWeb)
• Migrate  pilot application to Test servers
• Commence testing

INF145 (18-19/19-20 Project)

Protecting Data in the EDW

Milestones

RAG Status

Green

Report by Kevin Hone for July 2019

Achievements

• Successful deployment to trial, development and test environments achieved.
• Preparations for go-live were completed.
• Go/No Go decision was taken at a project review meeting with agreement to implement on the 1st August.
• Change record raised to allow for a suitable warranty period with project closure now moved to Mid-august.

Issues

• Bug identified but a work around is in place and project team agreed this wasn't a showstopper to prevent go-live. 

Next Steps

• Oversee project closure.

Closure Report

Project Closed 12-Oct-2018

Closure Report

Project Closed 3-May-2019

Closure Report

Project Closed 3-May-2019

Closure Report

Project Closed 3-May-2019

Closure Report

Project Closed 14-June-2019

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

Closure Report

Project Closed 29-July-2019

Closure Report

Project Closed 12-July-2019

Closure Report

Project Closed 2-Aug-2019

Closure Report

Project Closed 2-Aug-2019

Project Closed 2-Aug-2019