This discussion is archived
3 Replies Latest reply: Sep 29, 2012 1:47 AM by 911519 RSS

cannot reconfigure database Hyperion foundation 11.1.2.1-option greyed out

963170 Newbie
Currently Being Moderated
Hello,
Installing Oracle EPM 11.1.2.1.
After configuring foundation services, i get the following error message when trying to start the service : 'HSS_COMPONENT_TYPES' not valid'
I want to configure again the foundation database but option is greyed out in the EPM configuration tool.
Anyone knows where i can reactivate the ability to configure foundation database again?
thanks & regards
  • 1. Re: cannot reconfigure database Hyperion foundation 11.1.2.1-option greyed out
    741513 Explorer
    Currently Being Moderated
    The only workaround I've seen to this is by renaming the EPM Instance "epmsystemx" folder under <Drive>:\Oracle\Middleware\user_projects. I say rename in case you want to keep your existing folder as a backup.

    When you run the configurator, it will ask you to create a new instance and all your previous configuration will be gone.
  • 2. Re: cannot reconfigure database Hyperion foundation 11.1.2.1-option greyed out
    Vivek Chetiaparath Pro
    Currently Being Moderated
    My suggestion would be the following

    1.Ensure that all the pre-requisite are met for the Database as per the start install guide (majorly with permission)
    2.Get a new schema for HSS
    3.Delete user_projects folder
    4.Do the reconfiguration again.

    The above if this is a fresh installation with no data.
  • 3. Re: cannot reconfigure database Hyperion foundation 11.1.2.1-option greyed out
    911519 Newbie
    Currently Being Moderated
    Hello,

    For an EPM 11.1.2.1 implementation, the configurator would create a set of tables for the Foundation Shared Services and Essbase schemas. Assuming you are using two separate schemas as recommended by Oracle docs..

    Now all that the configurator does is create a set of tables, stores some environment related configuration data into them and also adds the admin user in CSS_USERS table. Of course it creates a lot more DB objects but we need not go into that now.

    So theres nothing to 'reconfigure' in the Foundation database but can create a new instance from scratch as @luisrcastillo has pointed out. Now I haven't used this option before but my understanding is that once you do this ... your EPM instance components in epmsystemX folder will now start reading/writing to the newly configured DB instance. I guess then you could go ahead and drop the older schema.

    Also when and where do you see that error..? What scripts are you using to start the services..?


    Thanks,
    Kent

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points