Configuration description

This document provides guidelines for re-hosting BI+ System 9 server components into anotherenvironment. It is not an officially supported methodology. While it is thought to be free fromdefect, Hyperion Corporation makes no representations or warranties. It should be used at theclient's own risk.Here’s a brief source and destination systems’ configuration description:

Source system Destination system

Host name HOST1 HOST2

Database type Oracle 9i/10g1 Oracle 9i/10g1

Database server DBSERVER1DBSERVER2

Database port used DBPORT1 DBPORT2

Oracle SID SID1 SID2

DB username DBUSER1 DBUSER2

DB password DBPASSWORD2 DBPASSWORD2

HYPERION_HOME HYPERION_HOME3 HYPERION_HOME3

BIPLUS_HOME BIPLUS_HOME3 BIPLUS_HOME3

Source Application Server Any4 Any4

Note 1: Both DB servers’ versions must match each other

Note 2: Source and destination systems’ database passwords must be equal

Note 3: Source and destination systems’ HYPERION_HOME and BIPLUS_HOME paths must

be equal.

Note 4: UI components movement is possible only for Tomcat 5.0.x application server. In othercases UI components must be reconfigured on target system from scratch

Backup all data of source system (file system, database) before performing any actions.

Preparing target system

Create a database user on the target database

Create a database user on the target database with the same password as you used on the source database. Database must be clean before installing, or drop existing ones before installing.The reason you need to use the same password is because the encrypted password in configuration files and database cannot be altered manually. You can change the Password afteryou successfully moved the BI+ System 9 components to the target system.The steps of Changing the Database Password can be found in the Foundation Administrator'sGuide.

Install and configure BI+ System 9 on the target machine

1. Install BI+ System 9 on the target machine with the new database user into the same

directory as the source system.

During the installation use the same component list, the same installation directory and

Hyperion home directory as on the source system.

2. Configure Repository components, Web Components and FR Services on target system

(do not register into Shared Services).

During configuration the same CLS, HSS and the same port numbers as on the source

system must be used.

Migrate system

Stop all services on both target and source system before migration process.

Migrate database data

Using command line, issue following commands

> exp system/<password>@TNSNAME1 file=<dmp-file-name> owner=DBUSER1 consistent=y

> imp system/<password>@TNSNAME2 file=<dmp-file-name> fromuser=DBUSER1 touser=DBUSER2

Validate that importing/exporting process is finished without errors.

Start sqlplus session with the new database to make sure all the tables were created. You can useother Oracle tools.

Copy server-side folders

• Remove the following files and folders from destination system:

1. <BIPLUS_HOME>/common/config/

2. <BIPLUS_HOME>/data/

3. <BIPLUS_HOME>/install/

4. <BIPLUS_HOME>/InstallableApps/config/

5. (UNIX)

_ <BIPLUS_HOME>/bin/*.sh

_ <HYPERION_HOME>/common/ODBC/Merant/5.1/odbc.ini

_ <USER_HOME>/vpd.properties

6. (WINDOWS)

_ <BIPLUS_HOME>\bin\*.(cmd|bat)

_ <WINDIR>\vpd.properties

• Copy source system files and folders to destination system:

1. <BIPLUS_HOME>/common/config/

2. <BIPLUS_HOME>/data/

3. <BIPLUS_HOME>/install/

4. <BIPLUS_HOME>/InstallableApps/config/

5. (UNIX)

_ <BIPLUS_HOME>/bin/*.sh

_ <HYPERION_HOME>/common/ODBC/Merant/5.1/odbc.ini

_ <USER_HOME>/vpd.properties

6. (WINDOWS)

_ <BIPLUS_HOME>\bin\*.(cmd|bat)

_ <WINDIR>\vpd.properties

Edit configuration files

1. Set properties in <BIPLUS_HOME>/common/config/config.dat the following way:

Host=HOST2

JDBC_URL=jdbc:hyperion:oracle://DBSERVER2:DBPORT2;SID=SID2

Login=DBUSER2

2. Edit <property name="userName"> section of

<BIPLUS_HOME>/common/config/config.xml:

<property name="userName">DBUSER2</property

3. Edit <property name="jdbcUrl"> section of

<BIPLUS_HOME>/common/config/config.xml:

<property

name="jdbcUrl">jdbc:hyperion:oracle://DBSERVER2:DBPORT2;SID=SID2</property>

4. Edit <property name="host"> sections of <BIPLUS_HOME>/common/config/config.xml

(two occurrences):

<property name="host">HOST2</property>

5. Replace all occurrences of <host> in <BIPLUS_HOME>/common/config/server.xml to:

<host>HOST2</host>

6. Replace all occurrences of <username> in

<BIPLUS_HOME>/common/config/server.xml to:

<username>DBUSER2</username>

7. Replace all occurrences of <dburl> in <BIPLUS_HOME>/common/config/server.xml to:

jdbc:hyperion:oracle://DBSERVER2:DBPORT2;SID=SID2</dburl

8. For Web Analysis only: Set properties in

<BIPLUS_HOME>/InstallableApps/config/WebAnalysis.properties

db.alias=//DBSERVER2:DBPORT2;SID=SID2

db.user=DBUSER2

db.password=DBPASSWORD

db.password-encrypted=false

ConfigURL=

9. For Web Analysis only: Run

<BIPLUS_HOME>/InstallableApps/config/EncryptPasswordUtil.sh (or bat)

Update database tables

Run SQL below for target database:

Change host and port for services (GSM):

update V8_PROP_VALUE set VALUE0='DBUSER2' where

PROP_NAME='com.brio.one.services.mgmt.usage.dbusername';

update V8_PROP_VALUE set VALUE0='HOST2' where

PROP_NAME='ConfigurationManager.gsmHost';

update V8_INSTALL_SVC_GSM set GSM_HOST_NAME='HOST2';

update V8_INSTALL_SVC_LOG set HOST_NAME='HOST2';

update V8_DOMAIN_PROPS set VALUE='HOST2' where NAME='GSM HOST';

update V8_HOST set HOSTNAME='HOST2';

If the appserver has changed hosts

update V8_SERVLET set HOSTNAME=’HOST2’;

update V8_DBSERVER set APP_USERNAME=’DBUSER2’;

Change Repository database access URLs

update V8_JDBC set JDBC_USERNAME='DBUSER2' where JDBC_USERNAME = ‘DBUSER1';

update V8_JDBC set JDBC_URL=’jdbc:hyperion:oracle://DBSERVER2:DBPORT2;SID=SID2’

where JDBC_URL = ’jdbc:hyperion:oracle://DBSERVER1:DBPORT1;SID=SID1’;

If Shared Services is rehosted:

Update V8_PROP_VALUE set VALUE0=’NewSharedServicesHost’ where

PROP_NAME=’ConfigurationManager.hubHost’

Update V8_PROP_VALUE set VALUE0=’NewSharedServicesPort’ where

PROP_NAME=’ConfigurationManager.hubPort’

Update V8_PROP_VALUE set VALUE0=’NewSharedServicesURL’ where

PROP_NAME=’ConfigurationManager.cssConfigURL’

commit;

Update UI (Web) Services

Moving UI Services is possible only on Tomcat 5.0.x. UI services must be reconfigured fromscratch if deployed in other application server.

Remove <BIPLUS_HOME>/AppServer directory on target system.

Copy <BIPLUS_HOME>/AppServer directory from source to target system.

Update properties in

<BIPLUS_HOME>/AppServer/InstalledApps/Tomcat/5.0.28/Workspace/webapps/workspace/W

EB-INF/config/ws.conf

WebClient.UserInterface.Login.RMServer=HOST2:GSMPORT

WebClient.Diagnostics.Log.LoggingService=HOST2:GSMPORT

Start target configuration

Start target configuration (Register BI+ to the Shared Services) and verify migrated data availablethrough UI.

Comment [SM1]: Configuration notes

section below lists the process of

updating servlet information using the UI.

This update statement can be removed.

They might have new port etc, using the

UI is better.

Comment [SM2]: This table should

not be updated as part of the move. This

stores the user name of the data source

DB not the services meta data DB.

Configuration notes

• For a successful job execution the target machine needs to have the same configuration

for the specific job (database client settings, ODBC data sources, (DSNs, connection

strings) location of SQR and others)

• This write up assumes that the source and target HPS directories are the same. It is

possible to move HPS into different directory but more steps are involved. Customer

Support can assist you with this task.

• If you installed the servlets into another server than perform the following to update theserver name in the smartcut of email notifications: login to HPS from the browser -> goto Tools->Administer-> Smartcut -> update Host name. Then restart HPS.

This will fix up entries in v8_servlet table.