Forum Stats

  • 3,783,118 Users
  • 2,254,734 Discussions
  • 7,880,280 Comments

Discussions

Explanation on epmsys_registry tool 11.1.2.1

Detlev
Detlev Member Posts: 463
edited Jan 27, 2012 8:19AM in EPM System Infrastructure
Hello,
after installing and configuring a second frameworkserver (and changing the path to the RM1 folder to a networkshare) I was missing all relevant framework menu's (like explorer and administer) in workspace.

I succesfully followed the instructions from reportID [ID 1325933.1] But I have not any idea what the epmsys_registry tool is doing. Perhaps someone can explain this a bit. That would be very welcome. :-)

1. Stop FoundationServices and RA framework webapps, and RA agent services
2. Execute the following query against the Shared Services registry database:
3. select application_id from css_provisioning_info where lower(application_id) like 'hava%';
o note this application id, e.g. HAVA:0000012b3072bf63-0000-6717-0acc1bac
4.Using the epmsys_registry tool, execute:
o epmsys_registry updateproperty RA_FRAMEWORK/@applicationId <the application Id returned from the query above>o example using ID above:_e.g. epmsys_registry updateproperty RA_FRAMEWORK/@applicationId HAVA:0000012b3072bf63-0000-6717-0acc1bac
5 Restart the processes above and try the user login to workspace again

Thanks in advance


Detlev

Best Answer

  • John A Booth
    John A Booth Member Posts: 1,508
    Accepted Answer
    Hi Detlev,

    The commands you are doing with the registry tool corrects the registry. A second reporting and analysis framework install clobbers the HAVA entry created by the first install -- this was quite painful in the first weeks of 11.1.2.1 for high availability installations.

    The registry is stored in your relational database and contains key configuration and security information.

    The commands you ran were the work-around before the formal patch that Kash references.

    Regards,

    John A. Booth
    http://www.metavero.com

Answers

  • Have you seen this:

    For EPM System Release 11.1.2.1, Reporting and Analysis services are installed on multiple boxes and share the repository on a shared drive. After the second set of Reporting and Analysis services is configured, Workspace does not show the Explorer listing after logging in. What is the cause of this issue?
    This is a defect in EPM System Configurator in Release 11.1.2.1.

    You need to apply Patch Set Exception 12552933 and follow the steps in the patch Readme.

    In file: http://www.oracle.com/technetwork/middleware/bi-foundation/epm-tips-issues-73-up-399995.pdf
    In Whitepaper Library: http://www.oracle.com/technetwork/middleware/bi-foundation/resource-library-090986.html
  • Detlev
    Detlev Member Posts: 463
    Hi Kash,

    thanks for paying attention to the several patches. I will start applying them soon.
    Although my problem was all allready solved by runnnig the registryupdate-tool.

    Detlev
  • John A Booth
    John A Booth Member Posts: 1,508
    Accepted Answer
    Hi Detlev,

    The commands you are doing with the registry tool corrects the registry. A second reporting and analysis framework install clobbers the HAVA entry created by the first install -- this was quite painful in the first weeks of 11.1.2.1 for high availability installations.

    The registry is stored in your relational database and contains key configuration and security information.

    The commands you ran were the work-around before the formal patch that Kash references.

    Regards,

    John A. Booth
    http://www.metavero.com
  • Detlev
    Detlev Member Posts: 463
    edited Jan 27, 2012 3:05AM
    Thanks for the usefull post John. I also bookmarked your company site, which seems interesting! :-)

    Edited by: Detlev on Jan 27, 2012 9:05 AM
  • John A Booth
    John A Booth Member Posts: 1,508
    Hi Detlev,

    I'm guessing you are looking at my blog (an outlet at times when I have some free time). Obviously I am partial to my company web page as well which you see a few links to from the blog.

    In addition to a creative outlet, I use my blog links to hit common oracle reference location rather than bookmarks or share things I find interesting.

    Regards,

    John A. Booth
    Blog: http://www.metavero.com
    Company: http://www.emergenow.com
This discussion has been closed.