E-Business Windows App Installation Plan



Delta Dental of California

DeltaCare USA Individual Web Enrollment

Version 6.1.0

Installation Plan

Project #: 40298

Version 1.2

Project Name: CAIPF Enhancement for 2 new plans

Date Aug 20 2009

Table of Contents

Table of Contents ii

Revision History 1

Product Overview 2

Support Programs 2

Dependencies 2

Release Build for CA-IFP 3

Release Details 3

Overview 3

Features in this Release 3

Build File Location 3

Build Files 3

Components in this build 4

Components removed in this build 5

Pre-Installation Requirements 6

(This section describes all Pre-deployment requisites and steps – see sample below) 6

Backup 6

Installation Server 7

Installation Location 7

Installation Procedure 8

Post-Installation Requirements 13

Contingency Procedure 14

Appendix 15

Revision History

|Date |Version |Description |Author |

|08-20-2009 |1.0 |Installation Plan for CA-IFP |Ali Raza |

|08-21-2009 |1.1 |Update after review with Shahab |Ali Raza |

|08-21-2009 |1.2 |Update after the review with Dev/Release Team |Ali Raza |

Product Overview

(This section provides brief description and overview of the application/product - see sample below)

California’s individual/family plan (IFP) project is the enhancement of the existing application. It allows user to select between two plans CA “high plan” (CAA54) and a “low plan” (CAA55) that meet different customer needs and price points

Support Programs

(Indicate here any supporting programs for the application - see sample below)

SQL Server 2000 database server, IIS 5.0 or higher (Internet Information Services)

Dependencies

(Specify all depencies/pre-requisite needed for the application deployment - see sample below)

• Existing PMI database and DTS Package database in SQL Server 2000.

• Modification of existing DTS Package

• Add new Tables

• Add new ASP Pages

Release Build for CA-IFP

Release Details

Overview

(Provide Release description/overview here – see sample below)

IFP restricted facilities and incorporation into the existing Web Enrollment application’s enrollment and renewal processes.

Features in this Release

(Describe feature and noted changes in this Release – see sample below)

• New enrollees to have a choice of two plans.

• Add restricted Facility Feature.

• User-input Retention

Build File Location

(Note relevant Build File location, if any – see sample below)

\\sacprefps201.deltapre.ent\releasedropzone\ESP - Metavance Releases\ESP - Maintenance\ESP.MNT.5.70.1\web\PMI_USA\

Build Files

(Note relevant Build Files information, if any – see sample below)

1. Added and modify existing ASP Files.

• ChargeA_Main_I.asp

• ChargeProcessA_I.asp

• ConfirmSubmit_inc_CA_I.asp

• DependentUpdate_inc_CA_I.asp

• Disclosure Form.pdf

• DisplayEntry_inc_I.asp

• RenewDate_Alt_I.asp

• SqlCheckInclude.asp

• ValidationErrorPage_CA_I.asp

• Validation_Main_CA_I.asp

• benefits_CA_I.asp

• checkout_CA_I.js

• deltacare_CA_I.css

• enroll_CA_I.css

• facility_CA_I.asp

• form_CA_I.asp

• plans_CA_I.asp

• pmiUSABuildEmail_inc_CA_I.asp

• processFacility_CA_I.asp

• processRenew_I.asp

• reset_CA_I.css

• vbsFunc.asp

2. Modified Import DTS Package

3. Add new Tables and Modify existing Tables

Components in this build

(Note any relevant components added in this build – see sample below)

On Web Server

Web Component Files (ASP):

• Added

1. ChargeA_Main_I.asp

2. ChargeProcessA_I.asp

3. ConfirmSubmit_inc_CA_I.asp

4. DependentUpdate_inc_CA_I.asp

5. Disclosure Form.pdf

6. DisplayEntry_inc_I.asp

7. RenewDate_Alt_I.asp

8. SqlCheckInclude.asp

9. ValidationErrorPage_CA_I.asp

10. Validation_Main_CA_I.asp

11. benefits_CA_I.asp

12. checkout_CA_I.js

13. deltacare_CA_I.css

14. enroll_CA_I.css

15. facility_CA_I.asp

16. form_CA_I.asp

17. plans_CA_I.asp

18. pmiUSABuildEmail_inc_CA_I.asp

19. processFacility_CA_I.asp

20. processRenew_I.asp

21. reset_CA_I.css

• Modified

1. vbsFunc.asp

On Database Server

PMI database:

• Added

o productGroups (For each plan, which groups are allowed)

o RestrictedFacilities (Routing File)

o RestrictedFacilitiesTemp (Work File)

o PMIFacilityTemp (Work File)

• Inserting Data into

o productGroups

o premium

• Modified Tables

o PMIFacility (Added date closed to Enrollment and Facility Name)

o PMIAcctNbr (Added one new field Last Assigned Facility)

o PMIAcctNbrTemp (Work File)

• Modify Existing DTS Packages:

o PMI40TripleImports

Components removed in this build

(Note any relevant components removed in this build – see sample below)

None

Pre-Installation Requirements

(This section describes all Pre-deployment requisites and steps – see sample below)

Backup

Application Installer:

1. Existing ASP Pages from Production Server WWW1, Existing Production Folder name D:\Web\Prod\Apps\PMIusa\

Database Administrator:

a. Make a backup of PMI Database, Server Name is DMZW2KSQL02

b. Make a backup of DTS Package – PMI40TripleImports, Server Name is DMZW2KSQL02

Installation Server

(Provide relevant Environment/Server Information, if any – see below)

|Environment |Servers |Description |

|MOT |sfointwebforms2 |Windows 2003 Web Server |

| |(IP = 192.168.55.238) | |

| |SAC-W2K-SQLD01 |SQL Server 2000 Database Server |

| |(IP = 192.168.66.48) | |

|Production |WWW1 and WWW2 |Windows 2003 Web Server |

| |DMZW2KSQL02 |SQL Server 2000 Database Server |

| |IP = 192.168.132.42 | |

Installation Location

(Provide relevant server/application directories – see sample below)

Database Server:

Production SQL Server - DMZW2KSQL02

Production Database Name - PMI

Web Server:

Production Server Name – WWW1 and WWW2

Production Application Folder - D:\Web\Prod\Apps\PMIusa\

Installation Procedure

(This section describes and will include detailed instructions on how to install the current build – see sample below)

Installation servers for Production environments are defined in Installation Servers section. Application Installer or Database Administrator must refer to this section.

|Description |Responsible |

|Product Packages | |

|See Build File Location and Build Files under the Release Details section | |

|Copy ASP files from \\sacprefps201.deltapre.ent\releasedropzone\ESP - Metavance Releases\ESP - |Application Installer |

|Maintenance\ESP.MNT.5.70.1\web\PMI_USA\pmiusa and placed it to D:\Web\Prod\Apps\PMIusa\ on WWw1 and www2 | |

|Get and run sqlScript.txt script file on Production SQL Server from the location of |Database Administrator |

|\\sacprefps201.deltapre.ent\releasedropzone\ESP - Metavance Releases\ESP - Maintenance\ESP.MNT.5.70.1\web\PMI_USA\pmiusa\dbScript. | |

| | |

|Database Table, View, and Stored Procedures Installation / | |

|DTS Package Installation | |

|Log on to Database Server with system administrator account: |Database Administrator |

|1. Also, get the file (DTS) package “PMI40TripleImports.dts” from the location \\sacprefps201.deltapre.ent\releasedropzone\ESP - Metavance | |

|Releases\ESP - Maintenance\ESP.MNT.5.70.1\web\PMI_USA\pmiusa\dbScript | |

| | |

|2. Run the self-extracting executable build file to unzip/extract the SQL scripts and DTS package files to a working folder. This build | |

|file contains 1 SQL script files and One DTS package files to be installed described below. | |

| | |

|3. Open the SQL Server Enterprise Manager | |

| | |

|4. Open the PMI database using the system admin account | |

| | |

|5. Open SQL Query Analyzer, Select Database PMI, Copy the SQL Script mentioned in CAIFP_SQLScript.txt file and paste it on SQL Query | |

|Analyzer and run the statements. | |

| | |

|6. Log on to database server using system administrator account and do the following steps to install the One DTS packages to the target | |

|database server one at a time: | |

|Select and open the Data Transformation Services folder | |

|Right-mouse click on the Data Transformation Services folder to open the menu | |

|Select the Open Package option from the menu, then select the DTS package file listed below from the working folder mentioned in the | |

|earlier step | |

|And then select the Package menu and Save As option from DTS package opened window to save the DTS package to the target SQL Server (e.g., | |

|select MOT server if installing the DTS in MOT, or select PROD server if installing the DTS in PROD) | |

|1. PMI40TripleImports | |

|DTS Package should look like this | |

|[pic] | |

| | |

| | |

|Change the Properties | |

| | |

|Select each text file source and change the location | |

| | |

|[pic] | |

| | |

|File name from C:\Data\IFP\Legacy File\PMIRestrictionExtract to E:\PMI\Import\ PMIRestrictionExtract | |

|Similarly for other text files icon for broker from C:\Data\IFP\Legacy File\PMIBrokerExtract to E:\PMI\Import\ PMIBrokerExtract | |

|For Facility File from C:\Data\IFP\Legacy File\PMIFacExtract to E:\PMI\Import\ PMIFacExtract | |

|For member file from C:\Data\IFP\Legacy File\PMIAcctNbrExtract to E:\PMI\Import\ PMIAcctNbrExtract | |

|Also, Change the Server and database for each Microsoft OLE DB Provider [pic] | |

|From 192.168.66.48 to 192.168.132.42, and change Username from julanr to sa and use Production password as shown below | |

| | |

|[pic] | |

| | |

|After making the change Run DTS package. | |

|Checkout | |

|Verify/confirm the changes. |E-Business Customer |

|If the checkout is not successful, do Contingency Procedures section. |Service |

|If it is successful, notify the Installation Coordinator that the checkout is completed. | |

|Notify all the involved team members and the project managers that the installation is complete. |Installation/Release |

| |Coordinator |

Post-Installation Requirements

(This section details any post-deployment steps or requirements – see sample below)

Database Administrator:

If ASP and Database Script run successfully then run CreditCardDBScript.txt (This Script modifies1st 11/12 digits to Zeros) by using Query Analyzer. The location of this file is \\sacprefps201.deltapre.ent\releasedropzone\ESP - Metavance Releases\ESP - Maintenance\ESP.MNT.5.70.1\web\PMI_USA\pmiusa\dbScript

Contingency Procedure

(This section details all relevant instructions and requirements in an event a Roll Back process needs to be implemented – see sample below)

|Description |Responsible |

|If problems are encountered during the installation checkout which require a restore of the original files, the | |

|following contingency procedures will be implemented. | |

|Log on to Web Server: |Application Installer |

|Restore the original production files from the backup copy mentioned in the Pre-Installation Requirements | |

|section. | |

|Log on to Database Server with system administrator account: |Database Administrator |

|Restore from the backup for the PMI database mentioned in the Pre-Installation Requirements section. | |

|Restore the back from DTS Package PMI40TripleImports mentioned in the pre-installation Requirements section. | |

| | |

Appendix

(This section is for Appendix and Appendices information, if any – see sample below)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download