12 Replies Latest reply on Jul 22, 2019 9:08 PM by iArchSolutions-Joe

Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh Apr 19, 2019 5:15 AM

Hi All,

Would like to get advise on the below.

We are going to change the Db domain name to different domain name for our Hyperion application, example from hyperion_user.world to hyperion_user.company.com.

From what I checked through the Hyperion application, we need to do the below:

1. changes on all the weblogic db connection string

2. Run the configtool.sh to reconfigure the DB

3. Run the configtool.sh to re-deploy the all application.

4. If there is any customise script that using the connection string, then make those changes.

Other than this, could anyone share any proper steps/sequence for this DB domain changes on Hyperion? Thanks!

1. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

BillHack-Oracle Apr 19, 2019 5:03 PM (in response to Hploh)

Can you please try the following community? This forum is specifically for FDMEE/Data Management.

https://community.oracle.com/community/groundbreakers/business_intelligence/performance_management_applications/epm_system_infrastructure
Like Show 1 Likes(1)

Actions
2. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh Apr 24, 2019 2:38 PM (in response to BillHack-Oracle)

Hi, noted. I moved it to your suggested space, thanks!
Like Show 0 Likes(0)

Actions
3. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh Apr 24, 2019 2:45 PM (in response to Hploh)

I just did those steps.
1. changes on all the weblogic db connection string <done>
2. Run the configtool.sh to reconfigure the DB <done>
3. Run the configtool.sh to re-deploy the all application. <done>
4. Started hyperion application
5. Verify by login to the ODI console, we lost all the configuration. Checking the details of Global context and other things, the created time shown today date. It seem the data been created.
*note, during the configure domain using configtool.sh, it ask about reuse or drop db, I selected the reuse option.

I not sure if I run any incorrect steps? I checked with oracle, and as per update, the configtool.sh will not overwrite anything.

Anyone have the similar issue? Please advise, thanks!
Like Show 0 Likes(0)

Actions
4. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

JohnGoodwin Apr 24, 2019 3:15 PM (in response to Hploh)

It might be related to "EPM System Configurator for FDMEE database clears ODI information (Doc ID 2229338.1)", I am sure one of the latest patches fixes that issue though it depends which patch release you are on.

Cheers

John
Like Show 2 Likes(2)

Actions
5. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh Apr 25, 2019 5:57 AM (in response to JohnGoodwin)

Hi John, thanks for the metalink. Appreciate!
Do you know if this also affect the planning, Financial reporting, etc by running the configtool.sh to reconfigure db, and application deployment? Thanks!
Our FDMEE is at 11.1.2.4.210.012
Like Show 0 Likes(0)

Actions
6. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

JohnGoodwin Apr 25, 2019 7:19 AM (in response to Hploh)

It shouldn't affect the other products.
Like Show 1 Likes(1)

Actions
7. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh Apr 25, 2019 8:25 AM (in response to JohnGoodwin)

Thanks! Good to know. Our team will verify the other product for the meantime.
I have a support ticket with Oracle but haven't get the solution yet.
You mentioned about the possible patch, I tried to search around the patch but maybe my used keyword is not the correct, I didn't get any recommended patches.
Do you have keyword for me to search it? thanks!
Like Show 0 Likes(0)

Actions
8. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

JohnGoodwin Apr 25, 2019 9:20 AM (in response to Hploh)

It might have been resolved in 11.1.2.4.220 though I can't be certain.
Like Show 0 Likes(0)

Actions
9. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh Apr 26, 2019 1:16 AM (in response to JohnGoodwin)

thankyou!
Like Show 0 Likes(0)

Actions
10. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

Hploh May 15, 2019 7:46 AM (in response to JohnGoodwin)

HI John,

Need some advise, do you aware run the configtool.sh will causing the FDM's (FinancialReporting, FoundationServices, Planning, CalManger,etc) setCustomParamsComponent.sh be overwritten?

The setCustomParamsComponents that i refer to is:
setCustomParamsFinancialReporting.sh
setCustomParamsFoundationServices.sh
setCustomParamsPlanning.sh
setCustomParamsRaFramework.sh

I mean some of the custom parameter that added prior to running configtool.sh seem be missing.
Like Show 1 Likes(1)

Actions
11. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

iArchSolutions-Joe Jul 12, 2019 2:16 AM (in response to Hploh)

Hi Hploh - yes - whenever you run the configTool.sh setCustomParam files do get "touched" and often times reset to defaults. Same is true for certain OHS files like the httpd.conf, ssl.conf, mod_wl_ohs.conf. If SSL enabled EPM environment I always grab the keystrokes and Oracle Wallets as well. Better to error on the side of caution.

Always backup those files, grab a copy of the EPMSystem registry (epmsys_registry.sh) EPM Topology Report (epmsys_registry.sh report deployment) before you run the config or installer. Just a good best practice.

Do you need help with any of the missing settings?

-Joe
Like Show 0 Likes(0)

Actions
12. Re: Oracle Enterprise Performance Management System Workspace, Fusion Edition - Hyperion Planning, EPM Workspace, FInancial Reporting, FoundationService, calc, FDM, eas, Analytic provider, OHS, essbase)

iArchSolutions-Joe Jul 22, 2019 9:08 PM (in response to Hploh)

Hi Hploh - hope all is well!

Once you're good with this question please let us know by marking it answered so others in the community know you're all set.

Any other questions, please don't hesitate to ask!

-Joe
Like Show 0 Likes(0)

Actions

Go to original post