Implementation Plan, April 10, 2009
Special upgrade time, Friday April 10, 2009, 05:00 - 07:00
- (05:00 Prabhu) Make a backup copy of MOTHRA_PERSON and UNEX_ENROLLMENT tables
- (05:05 Prabhu) Run the following DB SQL scripts to modify mothra_person table, insert desired records and recompile objects.
                https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2619_collect_missing_mothra_info.sql
                https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2619_insert_missing_mothra_info.sql
                 https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2646_alter_unexenrollment_table.sql
                 https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2619_recompile_dependencies.sql
- (05:12 Prabhu) Run the following to modify the mothra_feed and unex_feed procedures
                 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakai_2-4-x/plsql/ucd_mothra_p.sql
                 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakai_2-4-x/plsql/ucd_unex_p.sql
          (05:15 Prabhu) Mothra feed and unex feed is scheduled to run (cron job) at 5:15. Make sure this goes fine
         (06:00 Prabhu) Table switch script scheduled to run(cron job "TB") at 6:00. Make sure to identify the increased count in enrollments
         (06:15 Sandra) Verify a few course sites with rosters from smartsite-test/bricker
-
- CHE 118C ARO,A01-A07. A10-A19SP08
- ART 129 001SP08
- (07:30 Kirk) Verify that Users added manually in Jira's SAK-2107 (00454926), SAK-2691 (00390599) and SAK-2618 (00525838) are now available after this upgrade and remove the user entries if they are no longer needed.
Fall-back Procedure (If needed)
- (00:00 Prabhu) Switch the synonyms to "TA" tables
- (00:05 Prabhu) Delete records from mothra_person where "DELETED" is "Y". Redefine the mothra_person table by dropping the "deleted column"
- (00:00 Prabhu) Run the following DB SQL script to recompile objects.
           https://mware.ucdavis.edu/svn/ucd-sakai/maintenance/db-scripts/SAK-2619_recompile_dependencies.sql
- (00:00 Prabhu) Run the following to reset the changes made to mothra_feed and unex_feed procedures
            https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakai_2-5-x-prod/plsql/ucd_mothra_p.sql
            https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakai_2-5-x-prod/plsql/ucd_unex_p.sql
         (00:00 Prabhu) Run the mothra_feed and unex_feed manually
          (00:00 Prabhu) Run the table switch ("TA") script manually