RSIG Release 35 schedule - April 2023
- Dave Alburger
- xu.zhou
- Guofeng Lin (Unlicensed)
- Elliott, Stephen (TC TC) (Unlicensed)
Status | Date | Tasks | Team Members |
Complete | March 3rd | Request Data Management approval for DB changes (approve data model changes (if any) Once approved, CC to Data Warehouse group (André Roy) with the latest approved model. (Done on April 27th this time. should be earlier) | Xu – Done. Submitted March 3rd, Approved March 6th. |
Complete | March 16th | Send Invite for UAT Testing | Annick – Done March 16th. Reminders sent since. |
In progress | March 24th - April 6th | Feature Freeze, Testing/Bug Fixes & Regression Testing | Honglei, Ewa, RSIG Team |
Complete | March 13th | Sent Request to Refresh ACC DB and prepare scripts for ACC. | Xu – done |
Complete | April 27th | Send email to Data Warehouse group (André Roy) for schema change for RSIG release and RSIG_ACC is ready for their ETL job testing.
Inform them the PROD release date if applicable. | Xu - done but should be earlier notice next time. |
Complete | March 15th | Prepare for UAT Testing | Honglei – Done |
Complete | March 15th | Create ACC ticket | Entai – Done |
Complete | March 23rd | ACC Desktop deployment is ready, package provided to Citrix Team | Entai – Done |
Complete | March 29th | Determine UAT sign-off criteria. | Allison, Ann Marie, Steve, Annick |
Complete | March 27th – 29th | Testing of ACC build – citrix & desktop | Completed by Honglei March 29th |
Complete | Started March 21st
To be done by Wednesday April 12th | UAT testing / Regression Testing | Honglei – in progress RSIG Users have conducted some regression testing as of March 29th. Rest of RSIG team is performing regression testing. |
Holiday | April 7-10 Easter long weekend |
|
|
Complete | Wednesday April 12th | UAT Sign-off (historically 2-3 weeks before release) | Anne Marie, Allison, Steve |
Complete | Wednesday April 12th | Code Freeze | Honglei closes the ticket under the ACC ticket. C255827 |
Complete | Friday April 14th | Change Management Activities | Entai – SMGS ticket for production release has been prepared in advance on March 27th. Dave to submit when we are ready to do so. Deadline is Friday April 14th. C255883 |
Complete | Friday April 14th | Release package for both Desktop and Citrix are provided | George |
Annick isn’t available, this won’t be done. | Monday April 17th - Due By Thursday April 20th
| Create user-friendly release notes | Annick |
| Monday April 17th -Thursday April 20th | Find two “smoke testers” to test the production environment on the day of release. | Annick |
| Tuesday April 25th
| Advise users that RSIG will be offline from April 28th – to morning of May 1st | Annick |
Complete | Tuesday April 25th | Update RSIG start-up message | Shu Zi |
| Wednesday April 26th | Send Shu Zi “smoke tester” names. | Annick |
| Friday April 28th
| Release Day - Coordinate “Smoke Test” (Desktop) | Honglei |
| Friday April 28th
| Release Day - Help Desk sends out release notes to users. | Annick |
| Friday April 28th | Release Day (Desktop and Citrix) - Coordinate with database group. | Xu |
Complete | Friday April 28th | Release Day (Desktop and Citrix) - Coordinate deployment note: work with server group to ensure accuracy (shared Services) | George |
| Saturday April 29th | Release Day (Citrix) - Test Citrix and release when ready | Honglei, Xu |
| Monday May 1st | Let users know they can install the updated version of RSIG and ensure they have the correct version. | Annick |
| Monday May 1st | Done Finished |
|
Release Day Activities
2-3 days prior to Release
Item | Status | Time (Estimate ONLY) | What to Do | Team |
|---|---|---|---|---|
00 | Complete |
| Contact DBA team to make sure whoever run script on release day has account in TC008. | Xu |
Release Day (April 28th, 2023) (Friday)
Item | Status | Time (Estimate ONLY) | What to Do | Team |
|---|---|---|---|---|
1 | Complete | 7:00am-7:30am | Lock PROD | Xu |
2 | Complete | 7:00am-7:30am | Confirm regular user cannot launch RSIG. | RSIG QA (Honglei) |
3 | Complete | 7:00am-7:30am | Let DBA Know that can start Release process | Xu |
4 | Complete | 7:30am | Back Up PROD and run scripts. Once done, please let Xu Know. | TC DBA (Andree) |
5 | Complete | 8:00 | Deploy updated TSB SSIS to PROD and let Xu know. | TC DBA (Andree) |
6 | Complete | 8:10 | Validate SSIS package ad hoc run | Xu |
7 | Complete | 8:20 | Schedule SSSI daily run at 5am. | TC DBA (Andree) |
8 | Complete | 8:40am | Verify PROD DB for DB setting, schema compare, Release message, version attribute set up, permissions, etc. | Xu |
9 | Complete | 8:40am | Verify PROD DB for Data Update | Xu and Shuzi |
10 | Complete | 9:00am | Let George know when PROD DB is ready | Xu |
11 | Complete | 8:30am | Coordinate web group for Desktop version deployment | Entai - Dave and George will fill in in Entai’s absense |
12 | Completed | 9:00am | Update Version | George Note: need more info on exactly what gets updated. |
13 | Complete | 9:00 am | Quick testing in PROD. And let Xu know if issues or not. 1) Can access via Web? 2) Download? 3) Version? 4) Download Folder? 5) Others?
Notify the ROFs team that the database is ready. | Honglei |
14 | Complete | 9:00 | Update minimum version in WR203 parameter CD in ATTR1420 and ATTR1430 to the release version 1.35.0.0 | Xu |
15 | Complete | 8:30 am | Let TC DBA know PROD is ready for a backup and refresh Servicedesk with PROD backup | Xu |
16 | Complete | 8:30 am | TC DBA refresh Servicedesk with PROD Copy and let us know once done. | Xu |
17 | Complete | 9:10 am | ServiceDesk Build and version number update. | George |
18 | Complete | 9:30am | In SD, Data set up. 1) Attributes 2) Roles/Tasks 3) User recreate, Permission scripts 4) Remove start up message 5) Unlock the system | Shu Zi, Xu |
19 | Complete | 10:00am | SD Sanity Test and let Honglei know can start smoke testing | Xu |
20 | N/A | 11:50am | Let Help Desk know they can start smoke test | Honglei |
21 |
| 10:00am | Smoke testing | RSIG QA, Helpdesk, Users |
22 | Complete | 3:00 pm | Update SD SSIS scripts to
| Xu |
23 | Complete | 9:00am | TC DBA refresh RSIG_TRAINING with PROD Copy | Xu and TC DBA |
24 | Completed | Anytime | RSIG Training Build | George |
April 29th, 2023 (Saturday)
Item | Status | Time (Estimate ONLY) | What to Do | Who |
|---|---|---|---|---|
25 | Complete | Morning | Coordinate with Citrix team. Citrix testing and let team know if testing is done. Close SMGS Ticket. | Honglei |
26 |
|
| Option: Consult with Manager and TL if there is any concern. | Dave, Xu |
27 | Complete |
| Unlock RSIG. Let team and Helpdesk know RSIG is released. Close SMGS tickets. | Xu |
28 | Complete |
| Inform Data warehouse Group (André Roy) for release | Xu |
29 | Complete |
| Inform Trevor for release | Xu |
May1st, 2023 (Monday)
Item | Status | Time (Estimate ONLY) | What to Do | Who |
|---|---|---|---|---|
30 |
|
| Close SMGS tickets. | Entai (Dave to do this in Entai’s absence) |