Appendix A       Upgrading from BuyerXpert 4.0 to 4.1


This appendix describes how to upgrade the BuyerXpert 4.0 data store to BuyerXpert 4.1. No actual data migration occurs, because you are only upgrading the Oracle schema and adding new business rules.

---

Note	This appendix only pertains to upgrading from BuyerXpert 4.0 to BuyerXpert 4.1. The preceding chapters in this manual describe how to migrate your BuyerXpert 3.x application and data to BuyerXpert 4.x.

---

It contains the following sections:

• Preserving BuyerXpert 4.0 Data

• Installing BuyerXpert 4.1

• Using the BuyerXpert 4.0 to 4.1 Upgrade Script

Preserving BuyerXpert 4.0 Data

---

This section provides an overview of how to preserve data from an existing BuyerXpert 4.0 instance when you upgrade from BuyerXpert 4.0 to BuyerXpert 4.1.

---

Note	No actual data migration occurs when you upgrade from BuyerXpert 4.0 to 4.1. You are preserving data from a BuyerXpert 4.0 instance and upgrading the schema and business rules for BuyerXpert 4.1.

---

To upgrade your BuyerXpert 4.0 system to 4.1, you must complete the following tasks:

• Back up your existing BuyerXpert 4.0 data.

• Install BuyerXpert 4.1.

• Run the BuyerXpert 4.0 to 4.1 upgrade script.

Backing Up BuyerXpert 4.0 Data

---

Ensure that the following BuyerXpert 4.0 information is backed up:

• Oracle database

• LDAP directory data

• Staged update files

• User customizations

If you have a database administrator on site, the Oracle database will have its own backup schedule. You also need to coordinate the backup of LDAP directory data, import files, customization files, and staging files before you begin uninstalling BuyerXpert 4.0.

Shutting Down BuyerXpert 4.0

You must stop your BuyerXpert 4.0 instance before you can install BuyerXpert 4.1.

To shut down your BuyerXpert 4.0, stop the KIVA shell script:

% IWS-ROOT/ias/bin/KIVAes.sh stop

See the BuyerXpert Installation Guide Chapter 6, "Shutting Down and Installing BuyerXpert," for more information about shutting down BuyerXpert 4.0.

Installing BuyerXpert 4.1

---

To install BuyerXpert 4.1, follow the instructions in the BuyerXpert 4.1 Installation Guide, chapter 4, "Installing BuyerXpert".

Choose the standard BuyerXpert 4.1 installation, and on the Sample screen choose option "O" - No sample data. During this installation setup, BuyerXpert points to the same Oracle and LDAP data stores as BuyerXpert 4.0.

Using the BuyerXpert 4.0 to 4.1 Upgrade Script

---

You can run the BuyerXpert 4.0 to 4.1 upgrade script to preserve your existing BuyerXpert 4.0 data after completing the following tasks:

• Backing up your BuyerXpert 4.0 data

• Shutting down BuyerXpert 4.0

• Uninstalling BuyerXpert 4.0

• Installing BuyerXpert 4.1

The upgrade script updates the BuyerXpert 4.0 schema by adding new tables and new business rules from BuyerXpert 4.1. The upgrade script will prompt you for the following parameters:

• Database parameters for upgrading the schema.

• HTTP server parameters.

• BuyerXpert system administrator with permission to upgrade the business rules.

Table A-1 lists the 4.0 to 4.1 upgrade utility script parameters.

Table A-1    BuyerXpert 4.0 to 4.1 Upgrade Utility Script Parameters

4.0 to 4.1 Upgrade Utility Script Parameter	Definition
iAS root directory	Installation directory for iAS. For example: /export/IPM60
Oracle SID	The Oracle System Identifier (SID) for your BuyerXpert Oracle instance.
Database user name	User name BuyerXpert uses for your database.
Database password	Password for database user name.
Database default table space	Default database table space BuyerXpert uses (Example: TS01)
HTTP server host name	Host name of your BuyerXpert HTTP server
HTTP server port	Port for your BuyerXpert HTTP server.
Authentication user name	User name for sysadmin who has permission to update business rules.
Authentication user password	Password for authentication user.
Authentication user organization	Organization for authentication user.

Running the 4.0 to 4.1 Upgrade Script

To run the BuyerXpert 4.0 to 4.1 upgrade script, do the following:

1. Go to the iAS buyer directory:

   % cd IAS-ROOT/buyer/bin

2. Run the upgrade script:

   % ./upgrade_to_4.1.sh

3. Respond to the upgrade utility prompts.

The following sample upgrade session log is from a sample upgrade session. User responses are shown in bold.

BuyerXpert 4.0 to 4.1 schema and rules upgrade

This script operates on existing 4.0 data

You should have an existing 4.0 data installed

You should have already backed this data up

You should have already installed the BuyerXpert 4.1 program

You will need the database username, password and SID information

You will need the database default tablespace name

You will need to specify the base location of the iAS install

Do you wish to continue?[yes/no] yes

Please enter the iAS installation root directory: /export/IPM60

Enter the ORACLE_SID [MYSID]: MYSID

Please enter database user name: bx4

Please enter database user password: bx4

Please enter database default tablespace: TS01

##############################################

## Begin Schema Upgrade

##############################################

Schema for contract

SQL*Plus: Release 8.1.6.0.0 - Production on Fri Feb 16 09:12:54 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production

With the Partitioning option

JServer Release 8.1.6.0.0 - Production

.

.

.

##############################################

## End Schema Upgrade

##############################################

Please enter HTTP Server host name: myhost

Please enter HTTP Server port: 8080

Please enter the authentication user name: admin

Please enter the authentication user password: admin

Please enter the authentication user org: mercury.com

##############################################

## Begin Rules Upgrade

##############################################

http://robinhood:8080 admin admin mercury.com

set classpath

set command

/export/IPM60/ias/usr/java/bin/java -classpath \
/export/IPM60/ias/classes/java/jdbc20.jar:\
/export/IPM60/ias/classes/java:/lib/classes.zip:\
/export/IPM60/ias/classes/java/SWING.JAR:/export/IPM60/ias/APPS: \
/lib/rt.jar:/export/IPM60/ias/../buyer/admin/lib/buyer4_admin.jar \
com.iplanet.buyer.admin.impexp.cmdLn.impExpCmd \
-u=http://robinhood:8080 -n=admin -p=admin -o=mercury.com \
/export/IPM60/buyer/schema/db/buyer/4.0_to_4.1_policy.imp

#1 /export/IPM60/buyer/schema/db/buyer/4.0_to_4.1_policy.imp

To continue session press 'Enter' or ^C to cancel

<Press Enter>

Import session ID: DefUser:_2-16-01_8:07:16_AM_PST_949

To stop import file processing press 'Enter'

Total number of errors: 0

To get full results report press 'R'

To get only errors press 'O'

Attention!!! If literal pressed is uppercase session data will be removed from database

To get Log file press 'L'

To process another file press 'A'

To cancel application press ^C

<Use ^C to terminate the import/export utility>