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