Category Archives: Database

[Complete] Production Maintenance Window 5/23/10 from 8:00 AM to 4:00 PM

Posted on by

Updated 5/23/2010 at 3:58 PM:  All services are now back online, including password synchronization.

Updated 5/23/2010 at 3:15 PM:  Currently all applications are available again, but desktop and email password changes are not currently syncing to Cascade; we expect this issue to be resolved by 5:00 PM.

The next production maintenance window is Sunday, May 23, from 8:00 AM to 4:00 PM.

This month some database applications will be unavailable during the outage window including Cascade and Banner.  All other services will remain available throughout the maintenance window.

[Complete] Production Maintenance Window 3/28/10 from 8:00 AM to Noon

Posted on by

The next production maintenance window is on Sunday, March 28th, from 8:00 AM to noon.

From 8:00 AM to 9:30 AM all services may be off-line intermittently due to network upgrades, including:

  • E-mail
  • Personal and departmental file shares (on Alexandria and Merlin2)
  • Web services (including www.pugetsound.edu and cs.pugetsound.edu)
  • Database Applications: Cascade, FAMIS, Millennium, and Banner

Please note that Database Applications may continue to be unavailable until noon.

Supervised Access feature added to Cascade

Posted on by

A new feature of the Account Management application allows supervisors to “unlock” an employee’s work session from a supervisor’s management page. Lockable systems are Cascade Web and Cascade database.

The following components were installed 1/27/2010 5:30-6am:
COM.INFORMATION_SYSTEM.TAB
COM.INFORMATION_SYSTEM.CON
COM.INFORMATION_SYSTEM.DML
COM.CAMPUS_ROLE.TAB
COM.CAMPUS_ROLE.CON
COM.PERSON_CAMPUS_ROLE.DRP
COM.PERSON_CAMPUS_ROLE.TAB
COM.PERSON_CAMPUS_ROLE.CON
COM.ROLE_LOCK_VIEW.VW
COM.ROLE_LOCK_VIEW.SYN
COM.ROLE_LOCK_VIEW.GRT
COM.ROLE_LOCK_API.PKS
COM.ROLE_LOCK_API.PKB
COM.ROLE_LOCK_API.SYN
COM.ROLE_LOCK_API.GRT
COM.PRIVCMD.PKS
COM.PRIVCMD.PKB
COM.DAY_TEXT.FNC
COM.DAY_TEXT.SYN
COM.DAY_TEXT.GRT
COM.DATE_TEXT.FNC
COM.DATE_TEXT.SYN
COM.DATE_TEXT.GRT
WEB.PRIVWEB.PKS
WEB.PRIVWEB.PKB
WEB.WEBSEC.PKB
WEB.CASCADE.PKB
COM.CASCADE_IS_LOCKED.FNC
COM.CASCADE_IS_LOCKED.SYN
COM.CASCADE_IS_LOCKED.GRT
COM.LOGON_DENY_LOCKED_USER.TRG
WEB.SUPERVISE_ACCESS.PKS
WEB.SUPERVISE_ACCESS.PKB
WEB.SUPERVISE_ACCESS.SYN
WEB.SUPERVISE_ACCESS.GRT
WEB.WEB_APP_MENU.DML

Maintenance Window 11/29/09

Posted on by

All production databases were patched successfully.  If you experience any issues with Puget Sound systems, please contact TechHelp at (253) 879-8585.

The next production maintenance window is Sunday, November 29th, from 8:00 AM to noon.  From 8:00 AM to noon, all database services may be intermittently or entirely unavailable, including:  Cascade, FAMIS, Millennium, and Banner.

Maintenance Detail 10/25/2009

Posted on by

The following systems were patched today between 8am and noon:

  • sthelens
  • baker
  • Tahoma
  • userweb
  • purgatory
  • styx
  • hades
  • gehenna
  • moodle
  • quixote
  • mysql
  • oraweb
  • orcas
  • vmhost1
  • Alexandria
  • BE1
  • BE2
  • BE3
  • CBORDFSS (VENDOR DC)
  • CLTACC1
  • CLTACC2
  • CMS
  • DHCP-1
  • DM-1 to DM-8
  • EPO
  • FE1
  • FE2
  • ILLIAD
  • INTCHK (VM)
  • KEEPER
  • KRONOS (VENDOR DC)
  • LENEL (VENDOR Security)
  • MAURY2
  • MBS1
  • MBS2
  • MBS3
  • MEDIA
  • MERLIN2
  • MICROS (VENDOR DC)
  • MSPROJECT
  • ODYSSEY (VENDOR DC)
  • PROJECTS
  • SANJUAN
  • UPSCA03
  • VASHON
  • VERONICA
  • VIAWARP (VM)
  • VMMON (VM for now)
  • WEBSERVER1
  • WEBSERVER2
  • CISCOWORKS (VM)

[Complete] Maintenance Window 9/27/09

Posted on by

Updated 9/27/2009 at 2:30pm

All maintenance is completed as planned without any unexpected problems.  Most services were available by noon and all services are available as of 2:30pm.

The next production maintenance window is Sunday, September 27th, from 8:00 AM to 4:00 PM.

All services may be intermittently or entirely unavailable from 8:00 AM to 4:00 PM, including:

  • E-mail
  • Personal and departmental file shares (on Alexandria and Merlin2)
  • Database Applications:  Cascade, FAMIS, Millennium, and Banner

[Resolved] Millennium database down

Posted on by

The Millennium database was down this morning for a few hours because the archiver was stuck because the archive logs have not been getting purged like they should.
Space was cleared on the drive so archiving could resume and the database would be accessible again, and we will follow up on the log purging issue so this doesn’t happen again.