Report for October 2021

Report Date
October 2021
Programme Status Report for COM Programme

Report compiled by David Watters (Programme Manager) for Alex Carter (Programme Sponsor)

 

Section 1: Programme Summary

Programme Manager's Commentary

 

The month of October has been another mixed one for the COM programme, with some progress being made on the continuing projects, some sticking points on others and some new projects not being started as planned:

  • COM045  was due to deploy the IDM database upgrade earlier in the month, but this had to be postponed because of the recurrence of an issue in TEST. This has received a lot of attention from our technical teams and it looks like it will be resolved soon. The deployment is now being planned for December.
  • COM055 should hopefully be closed by the time you read this! Thanks to Tim for getting this done.
  • COM059 is continuing with the build of the new Sharepoint solution and the reports coming back from the project team are all positive. Some changes to milestones are in discussion
  • COM061 has been progressing, with UAT completed and the upgrade being deployed (out of hours) in LIVE. We may have to undertake a second upgrade on advice from Atlassian.
  • COM062 has managed to get Qlik Sense upgraded in DEV and TEST. UAT is expected to start soon.
  • COM063 (Serengeti) has not been able to fully start because of the unavailability of resources in Project Services. We are looking at another way of running this project with Production Management taking a lead. Discussions with the vendor are also ongoing.
  • COM064 (Business Objects) has just started with the initiation documentation being prepared and going to Apps Review in early November. The planning of this project will commence and is expected to be finalised by the end of November.
  • COM065 (Accessibility Statements) has not been able to start because of the unavailability of resources in Project Services.

Looking ahead, we are planning to deliver the IDM DB Upgrade and the JIRA Upgrade in October. The Programme is also hoping to resolve the issues round the start of the Serengeti and Accessibility Statements projects.

Programme Resource Position

 

Programme RAG Overview & Forward Look

 

Section 2: Projects Not Started

Project Info
Programme Manager's Commentary
COM066 - Bi-Annual Grouper Upgrade Due to start 08/11/2021
COM067 - Wiki: Annual Upgrade Due to start 15/11/2021
COM068 - API Upgrade Due to start 14/02/2022
COM069 - Committees’ Intranet: Update end of life components and tightening of security and compliance Due to start 07/02/2022

 

Section 3: Projects in Progress

Projects Project Manager's Commentary

COM045

IDM Database Upgrade

Compliance

Milestones

Milestones

Deploy to LIVE 07-Dec-2021
Deployment Sign Off Review 07-Jan-2022
Project Closure 18-Feb-2022

 

RAG Status

AMBER

Report by Chris Konczak for October 2021

Achievements this period

  • 4 indexes and SQL profiles added to IDMTEST. This is in relation to resolve the timeout issue in SOA/IDM
  • Benchmark testing carried out with indexes applied and removed. The indexes  made significant improvements in general processing.
  • Monitoring scripts created to observe issues.

Issues

  • The deployment scheduled for the 12/10/2021 had to be cancelled as SOA jobs were found to be failing intermittently with what appears to be a timeout issue when connecting with IDMTEST. 
  • It is unclear if the index changes will have resolved the timeout issue. This will need a period of time to see if the issue materialises.
  • The upgrade to Oracle 12 will now happen in December. Dates to be confirmed with Student Systems. Milestone dates are indicative of what we could expect.
  • There has been annual leave in October with the Tech team and the Project Manager, milestone replanning will happen in November, the milestones below are indicative of what we expect.
  • Expected scope change to allow the project to continue to upgrade to Oracle 19 after Oracle 12c is completed. Oracle 12c is end of life in March 2022. Further milestones will be added after Deployment Signoff Review.
  • The project team used 19 days during October to investigate and put in place fixes to try and resolve the issue. This has increased the budget past the agreed level so will require a further budget review.

Next Steps

  • Monitor the impact of the changes to the indexes to see if the SOA timeout issue occurs
  • Replan the deployment to Oracle 12 for December

COM055

O365 Staffmail Migration

Compliance

Milestones

Project Closure 28-Oct-2021

 

RAG Status

GREEN 

Report by Tim Gray for October 2021

 

Achievements this month

  • Project closure report drafted and circulated for comment
  • Project closure milestone approved by the project team

Issues

  • No issues to report

Next Steps

  • Project submitted for closure to Apps Review on 05.11.2021

RAG Commentary

  • Project RAG is GREEN

 

COM059

VRS Rewrite

Compliance

Milestones

Integration and Microservices (Dev) 06-Aug-2021
Interim Build Review 1 24-Aug-2021
Python App( IDM Functions) and Functionals (Sharepoint) 17-Sep-2021
Integration and Microservices (Test) 28-Sep-2021
Interim Build Review 2 28-Sep-2021
Interim Build Review 3 19-Oct-2021
Build Review 02-Nov-2021
Integration Review 10-Nov-2021
UAT Start 12-Nov-2021
Integration and Microservices (Live) 10-Dec-2021
UAT Complete 10-Dec-2021
Acceptance Review 22-Dec-2021
Delivery 13-Jan-2022
Delivery Review 28-Jan-2022
Closure Review 25-Feb-2022

RAG Status

AMBER

Report by Colin Watt for October 2021

Achievements this period

  • Draft landing page now added to SharePoint UI build, and built-in SharePoint search functionality enabled.
  • API calls now in place (dev).
  • Interim Build Review 2 milestone achieved.
  • Dialogue ongoing re: Library functionality.
  • Dialogue with RIS and P&M to determine any short term expectations around visitor accounts.

Issues

  • No major issues.
  • SW Dev resource availability is presenting challenges to the scheduling of the IDM actions python development, and development of enhanced logic layer around the microservices. Scheduling is not a showstopper but it may be necessary to release parts of the replacement VRS service in stages (with a parallel running of some backend aspects of the legacy system for a period).

Next Steps

  • Continue the SharePoint build
  • Progress Data Migration tests
  • Progress UAT plan
  • Complete the IDM components

 

 

 

 

COM061

Annual JIRA Upgrade

Compliance

Milestones

Deployment Review 03-Nov-2021
Closure Review 12-Nov-2021

RAG Status

GREEN

 

Report by David Watters for October 2021

Achievements this period

  • Upgrade applied to TEST
  • UAT completed
  • Upgrade successfully deployed in LIVE

Issues

  • Deployment into LIVE had to be moved to out of hours at request of P&M programme

Next Steps

  • Review and sign off deployment
  • Prepare closure report
  • Close project

 

 

COM062

Qlik-Sense and Qlikview Annual Upgrade

Compliance

Milestones

QlikSense UAT on Test 10-Nov-2021
DeployQlik Sense to LIVE environment 16-Nov-2021
QlikSense Deployment Signoff 22-Nov-2021

RAG Status

Green

Report by Chris Konczak for October 2021

Achievements this period

  • Brief signoff achieved
  • DEV and TEST upgrades completed, although the tech team will need to add in web connectors as this was noted to be required after the DEV upgrade. Dev Tech to review whether we need to set up SSO for web connectors. This will be rolled out to DEV and TEST.

Issues

  • Initial upgrade to DEV did not work so a rollback was required. Anti Virus disabled resolved the issue and QlikSense was redeployed successfully.
  • The new addition of web connectors was noted to be required after the DEV upgrade, and was not estimated at the planning stage.  Although DEV and TEST are upgraded, they cannot be fully signed off yet until the web connectors are applied. This is currently in progress

Next Steps

  • Web connectors applied to DEV and TEST
  • UAT to be completed on QlikSense
  • QlikSense deploy to LIVE

COM063

Serengeti Bi Annual Upgrade

Compliance

RAG Status

RED

Report by David Watters for October 2021

Project was due to start in Sep/Oct, but due to additional resource being provided to P&M, we do not have capacity within Project Services to start the project as planned. The delay in starting the project may impact Apps overall plan for 21/22 resulting in key projects not being delivered."

COM064

Annual Business Objects Upgrade

Compliance

Milestones

End of planning: 26/11/21

RAG Status

AMBER

Report by David Watters for October 2021

Project was due to start in Sep/Oct, but due to additional resource being provided to P&M, we did not have capacity within Project Services to start the project as planned. The delay in starting the project may impact Apps overall plan for 21/22 resulting in key projects not being delivered.

A PM has now been assigned and the project initiation is being submitted to Apps Review in early November.

COM065

Accessibility Remediation

RAG Status

RED

Report by David Watters for October 2021

Project was due to start in October, but due to additional resource being provided to P&M, we do not have capacity within Project Services to start the project as planned. The delay in starting the project may impact Apps overall plan for 21/22 resulting in key projects not being delivered.

 

Section 4: Closed or Withdrawn Projects

Project Info Project Manager's Commentary

COM057 Wiki Crowd Implementation 

Closure Report

Closure Milestone

Closed on 15/09/2021

AttachmentSize
Image icon 21oct-figures.jpg181.75 KB
Image icon 21oct-fl.jpg203.15 KB
Programme Status
RAG Status
Overall
GREEN
Has formal escalation taken place?
No