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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- e business windows app installation plan
- business to business media source inc
- business databases your library
- chapter 2 dod activity address code dodaad
- sin 541 5 integrated marketing gsa advantage
- electronic business registration guide
- catalog of federal domestic assistance cfda number
- 4 case scenarios for crime scene investigation
Related searches
- create windows 10 installation media
- create windows 7 installation disk
- repair windows with installation media
- windows 7 installation tool usb
- windows 10 installation media creation tool
- free windows 10 installation software
- create windows 7 installation dvd
- create windows 7 installation usb
- create windows 10 installation usb drive
- download windows 10 installation file
- windows 10 installation files location
- minecraft windows 10 installation folder