Personnel:
- Prabhu E Pilli, DBA verification
- Sandra Stewart, QA verification
Communication
- server: irc.freenode.net
- channel: #ucdsakai
During Maintenance Window
Pre Implementation tasks
- (Prabhu) Run the following queries to compare with the results after the fix implementation.
select mothraid,kerberos_name,deleted from cm_dev.mothra_person where mothraid in ('00133387', '00344830', '00600118', '00655505', '00589927', '00618662',
'00597123', '00396833');
Expected Results:
MOTHRAID KERBEROS_NAME DELETED
===============================================00133387 dhfeldma/DELETED N00344830 abarnes/DELETED N00396833 zee/DELETED Y00589927 jjhicks N00597123 zee N00600118 jazhicks N00618662 dhfeldma N00655505 abarnes N
0133387 dhfeldma/DELETED N
00344830 abarnes/DELETED N
During the Implementation rollout (all times are PST)
- (4:00 am, Prabhu) Backup current mothra package body from SAKAIEXT schema on banner production.
- (4:00 am to 4:15 am, Prabhu) Download https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakaiext_ban_prod/sakai_external_plsql.sql and run mothra feed package body. Make sure no errors returned.
- (4:20 am – 4:35 am, Prabhu) Execute the Mothra feed Package
Data Verification Testing
- (4:40 – 4:50am, Prabhu)
- Run the following queries to compare with the results after the fix implementation.
select mothraid,kerberos_name,deleted from cm_dev.mothra_person where mothraid in ('00133387', '00344830', '00600118', '00655505', '00589927', '00618662',
'00597123', '00396833');
Expected Results:
MOTHRAID KERBEROS_NAME DELETED
===============================================00133387 dhfeldma/DELETED Y00344830 abarnes/DELETED Y00396833 zee/DELETED Y00589927 jjhicks N00597123 zee N00600118 jazhicks Y00618662 dhfeldma N00655505 abarnes N
Vote on to go
- (4:50 – 5:00, Sandra Stewart) .
Rollback
- (5:00 am – 5:10 am Prabhu ) Run the mothra feed package body from the backup.