To generate and edit the Oracle EPM System Registry report, navigate to your instance’s bin directory and execute the epmsys_registry utility. Running the command without parameters generates an HTML deployment report, while appending flags like updateproperty or viewencryptedproperty allows administrators to safely modify database connections and component configurations from the backend
epmsys_registry utility in Hyperion or EPM is used to generate the report and edit it
How to generate epm registry report in Hyperion
You create the report by running the epmsys_registry utility with no parameters
cd /d d:\Oracle\Middleware\user_projects\epm_system1\bin
epmsys_registry
An HTML formatted report is saved to:
<Middleware_Home>\user_projects\\epm_system1\diagnostics\reports\deployment_report.html
This registry report will contain all the information stored in the registry.
How to edit the epm registry in Hyperion
We have various options available with the epm_registry utility to edit the information in the registry
- view
- updateproperty
- removeproperty
- addencryptedproperty
- updateencryptedproperty
- addfile
- updatefile
- removefile
- createlink
- removelink
- createcomponenthierarchy
- deletecomponent
- updatehost
- viewencryptedproperty
- viewhierarchy
- addproperty
The most common of use in view and update property. It is highly recommended to take backup of Shared services schema before editing it. You can use expdp to take the backup. Incase of any mistakes and issues, we can restore this backup, Here is the expdp and impdp command
CREATE OR REPLACE DIRECTORY "EXP_DIR" as '/u01/dumpfileloc';
expdp system/<pass> DIRECTORY=EXP_DIR dumpfile=Shared_schema%U.dmp schemas=<shared services schema> parallel=3
CREATE OR REPLACE DIRECTORY "IMP_DIR" as '/u01/dumpfileloc';
impdp system/<pass> DIRECTORY=IMP_DIR dumpfile=<dump files> schemas=<shared services schema> TABLE_EXISTS_ACTION=REPLACE parallel=3
View examples
If we need to see all the properties of the component
D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view <component id> example D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view #89698696ghdhddd
If we need to see a particular property of the component
D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view <component id>/@<property> example D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat view #89698696ghdhddd/@filesystem.artifact.path
updateproperty examples
If we need to update a particular property of the component
D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat updateproperty <component id>/@<property> <new value> example D:\Oracle\Middleware\user_projects\epm_system1\bin>epmsys_registry.bat updateproperty #89698696ghdhddd/@filesystem.artifact.path e:/oracle/temp
viewencryptedproperty examples
If you want to view the password stored in epm registry, then this option can be used
epmsys_registry.bat viewencryptedproperty aif_product/database_conn/@dbPassword
deletecomponent example
epmsys_registry.bat deletecomponent #componentID
I hope you like this article and it helps you