[Complete] SanJuan application server changes made this morning

Mike Carroll at Perpetual Technologies made some changes to our production report server this morning. It was done during our regular 5:30 a.m. maintenance window:

1) Cleaned up logs and cache directory
2) Created a new reporting server with security enabled by default: UPS_CASCADE_PROD
3) Enabled tracing on existing reporting server: rep_SanJuan_UpsForms

The changes were complete by 6 a.m. and the following apps were tested to verify the report server was working:

1) Direct report server call
2) Report server call from a Cascade form
3) Report server call from Famis
4) Report server call from BJP

Supervised Access feature added to Cascade

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

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.

[Complete] Maintenance Window 10/25/09

Updated 10/25/2009 @ noon — All production servers 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, October 25th, from 8:00 AM to noon.

From 8:00 AM to Noon, all services may be intermittently or entirely unavailable, including:

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

Maintenance Detail 10/25/2009

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

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

6/28/09 Maintenance Window Details

See the post in the “Maintenance Windows” catagory for the public communication.

This month the Sophos PMX servers were patched with the latest Linux patches, and upgraded to the latest PureMessage version.

We also did the following non-recuring tasks:

  • Upgraded Alexandria’s MD3000 Firmware
  • Upgraded AntiVirus to EPO on Webserver1 and Webserver2
  • Cleared stale VSS copies on SanJuan

Finally, all production Windows servers were patched:

  • Alexandria
  • BE1
  • BE2
  • BE3
  • CBORDFSS
  • CLTACC1
  • CLTACC2
  • CMS
  • DHCP-1
  • DM-1 to DM-8
  • EPO
  • FE1
  • FE2
  • ILLIAD
  • INTCHK
  • KEEPER
  • KRONOS
  • LENEL
  • MAURY2
  • MBS1
  • MBS2
  • MBS3
  • MEDIA
  • MERLIN2
  • MICROS
  • MSPROJECT
  • ODYSSEY
  • PROJECTS
  • SANJUAN
  • UPSCA03
  • VASHON
  • VERONICA
  • VIAWARP
  • VMMON
  • WEBSERVER1
  • WEBSERVER2

[resolved] Web forms was down this morning

Web forms was down this morning which included Cascade, Famis and Banner (a separate announcement has been posted to the Help Desk site for public viewing).
Patches were applied on the sanjuan server yesterday, and it wasn’t working after that. Paul fixed something in the configuration and bounced the server and now it’s working again.

5/31/09 Maintenance Details

See the post in the “Maintenance Windows” catagory for the public communication.  This post is to expand on what servers were patched, and basic changes.  All of the following patches were applied by noon.

The following windows servers were patched (Windows updates):

ALEXANDRIA

BE1

BE2

BE3

CLTACC1

CLTACC2

CMS

DHCP-1

DM-1 to DM-8

EPO

FE1

FE2

ILLIAD

INTCHK

KEEPER

MAURY2

MBS1

MBS2

MBS3

MEDIA

MERLIN2

PROJECTS

SANJUAN

VASHON

VERONICA

VIAWARP

VMMON

WEBSERVER1 (SP2 applied)

WEBSERVER2 (SP2 applied)

VMWare:

vmhost1

Linux (all available OS and Dell RAID FW/Drives as applicable):

orcas

tahoma

purgatory

styx

hades

gehenna

Additional changes on Sophos PMX servers:

Purgatory:

Turned Perc write cache on (write back), and changed linux readahead:

sudo blockdev –setra 8388608 /dev/sda
Rest:
policy on
adaptive read ahead