How to Update Database Connection in Shared Services Registry Using the EPMSYS_REGISTRY.bat Utility

How to Update Database Connection in Shared Services Registry Using the EPMSYS_REGISTRY.bat Utility [ID 1212454.1]
		Modified 19-SEP-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
HOW TO CHANGE PRODUCT DATABASE CONNECTION DETAILS USING EPMSYS_REGISTRY.BAT

---

Applies to:

Hyperion Financial Management - Version: 11.1.1.1.00 to 11.1.2.0.00 - Release: 11.1 to 11.1
Hyperion Planning - Version: 11.1.1.1.00 to 11.1.2.0.00 [Release: 11.1 to 11.1]
Information in this document applies to any platform.

Goal

This is a guide by example on how to directly update a product-specific database connection in the EPM registry using the command line utility EPMSYS_REGISTRY.bat.

Solution

HOW TO CHANGE PRODUCT DATABASE CONNECTION DETAILS USING EPMSYS_REGISTRY.BAT

Introduction:

This small guide will take you through updating the Calc manager database connection server name from vm0rpianese64 to cm0rpianese11 as an example but the procedure could be applied on any other EPM system product. One instance where using the configuration utility may fail to update the database connection details is when alias name is being used for the database server name instead of the physical server name.

Procedure:

Start a command prompt and change directory to \hyperion\common\config\9.5.0.0 on the shared services server
Execute the following command to view the specific product component details. In this example, we are using CALC MANAGER, and take note of the Ids of the following component:
- DATABASE_CONN -> af46278784e183e27f77898d11edadbe2cb7a49

Use the following command, while using the DATABASE_CONN ID value, to view the database connections component details. Looking at the details below, two entries are of interest:
- NAME
- PROPERTIES -> dbJdbcUrl
And as a final check we will view the last node in the screen below to ensure that the changes have been taken into account (CHILD COMPONENTS - Child 1)

Now we will update the database connection details by changing the database server name from vm0rpianese64 to vm0rpianese11.
The following command shows the currently stored database connection details (note: the property name is case sensitive):

The updateproperty command is then used to change the server name in the connection string from vm0rpianese64 to vm0rpianese11

The following command will change the NAME property so that the server name is updated

Perform a check by running the following command to make sure that the Database connection for Calc manager ahas been updated in the list of Database connection by querying the ID field of the CHILD COMPONENTS – Child1 (from 2nd screenshot above)

Launch the HTML registry report by running the epmsys_registry.bat and make sure that the following have been udpated

NOTE:

Special note when running the above epmsys_registry in a Linux environment:

When running the epmsys_registry with view option with ID on Linux the following error will show:

“java.lang.ArrayIndexOutOfBoundsException: 1 at com.hyperion.hit.registry.regedit.RegEditUtility.main(RegEditUtility.java:112) An error occured duringthe operation. Detailed Message is– 1”

This is because in Linux/UNIX environments, the # character needs to be escaped with a \character. To prevent this error, use \ID. If you will add the same in the doc it will be really helpful.

Ex: Instead of epmsys_registry view # af46278784e183e27f77898d11edadbe2cb7a49

use

epmsys_registry view \#af46278784e183e27f77898d11edadbe2cb7a49

Related Products Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management Middleware > Enterprise Performance Management > Planning > Hyperion Planning Errors ERROR USE

Back to top

Rate this document