Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

EPM System Management Pack


cannot reconfigure database Hyperion foundation 11.1.2.1-option greyed out


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

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.

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.

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


Related Links

How to add Web Symphony in HFM
Security issue-Hyperion shared services console
calc manager error in EPM
after upgr to 9.3.3 can not login as admin and Shared Service native accoun
EPM 11.1.2.1 HFM issue with Oracle Database 11g
FInancial reports Export Import error
Datasource drop down is not available when trying to deploy epma app
Cann't see Explore or Homepage in workspace
EPMA for Essbase 11.1.1.3
upgrade from System9 to EPM 11.1.1.2
EPMA Redeployment Error: Server.TaskOutOfMemoryException
EPM services error :Timeout while waiting for port tcp/6801
Hyperion EPMA 11.1.1.3 Services Sequence
ERPi Suppressing zero balance accounts
ODI to EPMA integration
ASO app using EPMA doesn't move member