Configuration Description
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.