Athena Build Installation Guide 04-00-00 - .pdf

Build Installation Guide 1

Athena v04.00.00 Build Installation Guide

Not subject to the ITAR/EAR: This publication does not contain information which falls under the purview of the U.S. Munitions List (USML), as defined in the International Traffic in Arms Regulations (ITAR), 22 CFR 120-130, and is not export controlled. This publication does not contain information within the purview of the Export Administration Regulation (EAR), 15 CFR 730-774, and is not export controlled. This publication is not intended for distribution outside of the NASA community. Release to the public requires approval through the appropriate NASA Release Process (e.g., FOIA, NASA STI, etc.).

Build Installation Guide 2

Athena v04.00.00 Build Installation Guide

Purpose The purpose of this document is to provide installation instructions for deploying the Athena application. This guide identifies the prerequisite software and the steps required to move the software build from development to the production environment.

Responsibility/Authority Configuration Manager

Special Considerations

Server Environment

• Web server: Windows Server 2008 R2 or higher running IIS 7.5 or higher with Microsoft .NET Framework 4.6.2 or higher and IIS Web Platform Installer

• Production – webserver-prod.jsc.nasa.gov

• Integration - webserver-int.jsc.nasa.gov

• Database Server: Windows Server 2008 R2 or higher running IIS 7.5 or higher with Microsoft .NET Framework 4.6.2 or higher and SQL Server 2016

• Production – sqlserver-prod.jsc.nasa.gov

• Integration - sqlserver-int.jsc.nasa.gov

Client Environment

• IE 11.0 or higher

• Chrome 71.0.3578.98 or higher

• Firefox 60.4.0esr or higher

External Application Dependencies

• Mail server - mrelay.jsc.nasa.gov for outgoing mail

• Mail service - https://mail-server.nasa.gov/EWS/Exchange.asmx for incoming mail

Inputs Entry Criteria

• Source code

• SQL Server database structure and data

• Coding and user acceptance testing complete for the release

Outputs Exit Criteria

• .Net active server pages (asp, .aspx),

• custom controls (.ascx),

• application object (global.asax, global.asa),

• web pages (.htm),

• image files (.bmp, .gif, .jpg),

• cascading style sheets (.css),

• JavaScript libraries (.js),

• server side program library (.dll),

• Excel templates (.xls)

• Software successfully installed to the production environment

• Updated SQL Server database

Build Installation Guide 3

Notes:

Build Installation Guide 4

Activities – take these actions on the target platform (Integration or Production)

Step 1.

(developers)

Notify stakeholders:

• Civil Servant: John Doe

• Application Owner: John Smith

Step 2.

(infrastructure)

Make the ATHENA application unavailable.

Step 3. (SKIP)

(DBA)

Make a backup of the Athena database to use if a back out becomes necessary.

Step 4.

(Infrastructure)

Make a backup of the Athena web application folder as a zip file to use if a back out becomes necessary.

Step 5.

(infrastructure)

Run the following SQL scripts to update the production database:

AthenaImport$\AthenaRelease\4.00.00\AthenaDatabaseScripts

1. Data.sql

Step 6.

(infrastructure)

If there are any errors in executing the scripts, do not continue with the next steps until the issue has been resolved. Each script should execute successfully. If there are any errors when the scripts are executed, please note the error and contact the Athena development team so that the issue can be resolved. If the issue cannot be resolved immediately, then a restore of the production database will need to be performed.

Step 7.

(infrastructure)

Take the following actions:

1. Using File Explorer, browse to the folder

AthenaImport$\AthenaRelease\4.00.00\AthenaWeb

2. Select all of the files and folders

3. Copy the files

4. Browse to the inetpub\wwwroot\Athena folder on the appropriate server (Production or Integration)

5. Paste the files allowing Replace or Overwrite

Step 8.

(infrastructure)

Enable TLS 1.2, and disable TLS 1.0 and 1.1 on the Production server.

Step 9.

(infrastructure)

Make ATHENA application available. Notify the Athena development team.

Step 10.

(Athena Admin)

Navigate to Administration -> Code Tables -> Data Types and update the Proc Var and Proc Var Cum formulas to :

(PLAN_COST+OPRF_COST+PLAN_MAT+OPRF_MATL+PROC_TVL_PLAN)-

(ACT_COST+ACT_MATL+PROC_TVL_ACT+OPRF_LBR_ACT+OPRF_MATL_ACT)

Build Installation Guide 5

Step 11.

(developers)

Navigate to the appropriate platform to verify the application installation.

Production - https://fodbit.jsc.nasa.gov/Athena/View/ExecutiveView.aspx Integration - https://fodbit-int.jsc.nasa.gov/Athena/View/ExecutiveView.aspx

Navigate to various pages to ensure they load correctly. Verify that the correct version numbers are displayed in Athena.

Step 12.

(developers)

Notify Stakeholders that the application is back on line.