eZair Overview from Jay

Players

Chris McConnell - Installed EAR on WebSphere, and configured user account
David Risley - Installed schema, inserted data and created accounted
Jayakumar - was original SME (Subject Matter Expert)

Kristen Tonks - Organizer
Diana Fernan - Main tester, questions
Scott Harrington - Project Manager
Teresa - being pulled in part-time to help
Richard Anderson (PCL) - Project Manager, originally Jay's counterpart

Overview

Using real SABRE inventory for testing.  All code changes need applied by PCL.

Chris from HAL systems did setup and Tara was contact from PCL Apps.

  • Ear file from PCL
  • DDL from PCL
  • Database Schema - ezAir
  • Data Inserts from PCL
  • Webshphere configuration Doc from PCL in Sharepoint
  • Log File is a shared mount from WebSphere

.

Adobe Life Cycle ACL – Setup with Web Methods

Jay has setup three environments {development, test and production}

Each environment should have 4 folders, following this naming convention \chipdev.dinghy.hal.testDcmscommunicationcopy

  • copy - where you drop the files to introduce them to the system
  • work - used by listener, moves from copy to here in order to process the file
  • done - when processing finished, the file is versioned and kept for 7 days
  • error - were Web Methods places the file, it fails to process

Server locations:

  • (dev) \chipdev.dinghy.hal.testDcmscommunicationcopy
  • (tst) \haltadobelc01.dinghy.hal.testDcmscommunicationcopy
  • (prd) \halpadobelc01.dinghy.hal.testDcmscommunicationcopy

Overview:

Files are dropped into the copy folder, and eventually loaded into Web Methods memory.  A filter is put in place to only load *.xml files, the service that starts the process in Web Methods is cacheALCData.

Here's the test interface:

http://haltadobelc01.dinghy.hal.test:5555/BuildALCEmail/emailCommValidation.dsp

Use "Views" COMMUNICATION_DATA and filter by CODE_CO and LANGUAGE_CODE to get some test data.  The ID_COMMUNICATION_DATA is a unique id for a single guest communication.

All of the tables that make up the above view start with STORE_*

SBN PrelimFinal FTP process broken

From: Ruckman, Maurice (HAL)
Sent: Sunday, January 01, 2012 7:24 PM
To: HAL Service Request Center (HAL); Doan, Thomas (HAL Contractor)
Cc: De Vera, Marlon (HAL); Harris, Tyrone (HAL); Hofsetz, Therron (HAL); Augustine, Anila (HAL)
Subject: SBN PrelimFinal FTP process broken, Need UNIX help to resolve
Importance: High

SRC,

Please call out to the Unix, it will be necessary to have them delete some files to allow a schedule task to start again on the half hour. Please see attached email for previous example that happened on 12/16/2011 where Marlon opened a ticket to resolve. Please copy all recipients of this email with the work order.

Unix Team,
Please do the following, NOT on the half-hour, because a crontab is setup to run the scripts on the half-hour, such as 7:30pm, 8:30pm etc., just don’t want you in the middle of cleanup when the next job starts, and feel free to call me if there are any questions 206.650.7576:

Step #1:
Check if any bash jobs are running in HALPRDWAS02, named : 'LoadPrelimFinalDocs.sh' or 'LPFD*'. If so end task(s).

Step #2:
Delete all of the files in the following folder on halprdwas02
/prod/sbndocs/transfer/final/*
There are currently 68 files with a date/time stamp 12/31/2011 9:30am to 12/31/2011 9:32am

Step #3:
Delete the following lock file on halprdwas02
/prod/scripts/LoadPrelimFinalDocs.lock

Thomas,

Would you complete the necessary “emergency” documentation on Tuesday?

All,

The FTP Job failed on 12/31/2011 @ 10:30AM and its lock file was left in place, subsequently there are PDF files date stamped 12/31/2011 @ 9:30AM+ which were not processed. Have verified that all files in RRD archive folder are both on the production PDF server and exists in the Oracle database. Symptom emails “untitled” has been sent on the hour since that time with the message body of “LoadPrelimFinalDocs.sh IS STILL RUNNING! EXITING NOW!” when two of those happen back-to-back, it normally means there’s a problem.

Thanks,

Maurice Ruckman
Voice: (206) 626-7497 x67497
Cellular: (206) 650-7576

How to Disable Global Menu in Ubuntu 11.10

To disable the Global Menu, use the following Terminal command. Once done, log out or restart your system for changes to take effect.

sudo apt-get autoremove appmenu-gtk appmenu-gtk3 appmenu-qt

This process is completely revertible and the changes can be undone by re-installing the package from the below given command. Once the package is installed, restart your computer.

sudo apt-get install appmenu-gtk3 appmenu-gtk appmenu-qt

Installation of VirtualBox in Ubuntu 11.10

You will need to add your username to vboxusers group

open a terminal
sudo gedit /etc/group
vboxusers:x:125:mruckman
reboot Ubuntu to make sure it picks up the new changes

You will also want to install VBoxGuestAdditions_4.1.2
mount the ISO image inside the virtual appliance

You can download various versions of the software here:
http://download.virtualbox.org/virtualbox/4.1.2/

Turn off "Enable absolute pointing device" to have better response during shutdown and reboot.

When the virtual appliance is turned off, do the following:
Settings, System, uncheck the "Enable absolute pointing device"

SSH For SCP Fix

From: Turner, Andrew (HAL)
Sent: Tuesday, January 03, 2012 11:36 AM
To: Lee, Scott (HAL); Hoggard, Chad (HAL); Hofsetz, Therron (HAL); Siwek, John (HAL)
Cc: Mounagurusamy, Jayakumar (HAL); Harris, Tyrone (HAL); Augustine, Anila (HAL); Ruckman, Maurice (HAL)
Subject: RE: FAILURE FAILURE FAILURE Environment - prod : Error -- CC Applied Onboard Failed SCP For File WEBC20111229CC.txt

Here are my notes to fix the issue:

Open Dos Window

ntrights +r SeAssignPrimaryTokenPrivilege -u cyg_server ntrights +r SeCreateTokenPrivilege -u cyg_server

--restart CYGWIN sshd service using the following net stop sshd net start sshd

From: Turner, Andrew (HAL)
Sent: Thursday, February 02, 2012 10:06 AM
To: Siwek, John (HAL); Hoggard, Chad (HAL); Lee, Scott (HAL); Ruckman, Maurice (HAL); Harris, Tyrone (HAL)
Cc: Mounagurusamy, Jayakumar (HAL); Augustine, Anila (HAL); Hofsetz, Therron (HAL)
Subject: RE: FAILURE FAILURE FAILURE Environment - prod : Error -- CC Applied Onboard Failed SCP For File EDBC20120124CC.txt

Hi John

The user name is cyg_server

This is a local user on the HALRES01 box that runs the SSHD service.

Dummy Credit Cards

Attachment:

Dummy test credit cards

From: Mounagurusamy, Jayakumar (HAL)
Sent: Wednesday, December 14, 2011 12:47 PM
To: HAL DistList: IT Website Team
Subject: Emailing: Dummy test credit cards

The attached document has the dummy credit card and expected results that can used in webdev and  webtst environments. This document is also available at below SharePoint location.

Link to Sharepoint

Your message is ready to be sent with the following file or link attachments:

Dummy test credit cards

Note: To protect against computer viruses, e-mail programs may prevent sending or receiving certain types of file attachments.  Check your e-mail security settings to determine how attachments are handled.

Web Application Architecture Diagrams

Attachments:

From: Hofsetz, Therron (HAL)
Sent: Tuesday, December 13, 2011 1:21 PM
To: Thompson, Sonya (HAL); Augustine, Anila (HAL); Fillman, Eric (HAL); Ruckman, Maurice (HAL); Phatak, Sheetal (HAL); Sankar, Kousalya (HAL); Bojja, Sridhar (HAL Contractor); Mirza, Masood (HAL Contractor); Mounagurusamy, Jayakumar (HAL); Smith, Robert (HAL Contractor); Gong, Raymond (HAL Contractor)
Subject: Web Application Architecture Diagrams

Here are a set of Architecture diagrams that were put together for the Web.  I found out recently that we not everyone has seen these or has access to them.

Jay – also please send the link to these files on the IT SharePoint site where they are located.

Therron

From: Mounagurusamy, Jayakumar (HAL)

Sent: Tuesday, December 13, 2011 1:25 PM
To: Hofsetz, Therron (HAL); Thompson, Sonya (HAL); Augustine, Anila (HAL); Fillman, Eric (HAL); Ruckman, Maurice (HAL); Phatak, Sheetal (HAL); Sankar, Kousalya (HAL); Bojja, Sridhar (HAL Contractor); Mirza, Masood (HAL Contractor); Smith, Robert (HAL Contractor); Gong, Raymond (HAL Contractor)
Subject: RE: Web Application Architecture Diagrams

Hello,

Below is the SharePoint link. I just dropped the Combined Architecture diagram file there too: Architecture Diagrams

Jay