Followers

Sunday, August 18, 2019

Oracle Hyperion Issue: Port number in WebLogicCluster parameter specified in httpd.conf is not an integer less than 65535

Recently we faced one issue, which is related to weblogic cluster details on httpd.conf (mod_wl_ohs)

While doing regular maintenance activities, we have restarted all services over weekend. We have environment of 5 servers, but one of the server services not working in workspace, even services are up and running in particular. We have reporting and analysis, FR in that server, we got startup document error, no Explore button in workspace.



If we click okay, startup document error popup page. Next Internal error popup.




When i click Show details, i found below error msg.

<HTML><HEAD><TITLE>Weblogic Bridge Message</TITLE></HEAD> <BODY><H2>Failure of server APACHE bridge:</H2><P><hr><PRE>Port number in WebLogicCluster parameter specified in httpd.conf is not an integer less than 65535, or servers are not specified correctly. Cannot continue.</PRE><P>
<hr> </BODY></HTML>

Before proceeding with any changes here, please take proper backup and proceed..!!


Check out below files in Foundation server (if OHS configured along with Foundation), Otherwise in OHS server.



Solution:

When i verified httpd.conf file and mod_wl_ohs file, in mod_wl_ohs file, whatever services we have in this reporting server, that is not correct. How it got updated in that file we don't know.

Replaced that hostname with correct hostname and restarted services.

Now issues resolved..!!

Thanks,
Mady

Monday, July 15, 2019

Essbase BSO and ASO Cube and Backup Scripts

BSO Cube =
exec_maxl "alter database ${APP}.${DB} archive to file '${BACKUP_PATH}/${APP}_${DB}.arc';" "1056023";

ASO Cube =
exec_maxl "export database ${APP}.${DB} level0 data to data_file '${BACKUP_PATH}/${APP}_${DB}.txt';" "1013270";

Do not forget the artifacts:
/usr/bin/zip-q -D ${BACKUP_PATH}/${APP}_${DB}_${TIME_STAMP}.zip  ${ARBORPATH}/app/${APP}/${DB}/* -x *.pag *.ind *.tct *.inn *.pan *.otn *.app *.dmf *.dbb *.db *.esm *.apb *.dat *.org *.dbd  *.jar  *.xml *.keep


Monday, July 1, 2019

Financial Reporting Migration Tool : FR Reports migration from HFM to FCCS

Kscope19 updates on Hyperion On-Premise:

The Financial Reporting Migration Tool (FRMT) is a utility that accelerates the migration and conversion of financial reports built in Oracle Hyperion Financial Management (HFM) into financial reports that are compatible with Oracle Financial Consolidation and Close Cloud (Oracle EPM Cloud).


The Financial Reporting Migration Tool (FRMT) is a utility that accelerates the migration and conversion of financial reports built in Oracle Hyperion Financial Management (HFM) into financial reports that are compatible with Oracle Financial Consolidation and Close Cloud (Oracle EPM Cloud).  This utility reduces the time and effort needed for report conversion by automating many of the manual tasks associated with the process.


The main features of the Financial Reporting Migration Tool include:


Maps dimension and member names to the new Financial Consolidation and Close model


Preserves the report formatting and layouts

Converts reports in bulk

Provides ready to use reports for Financial Consolidation and Close

The download includes the utility, full documentation, and examples.

Developers and implementer can extend and enhance the utility by editing the provide Python script to match specific use cases.











Reference links:

https://cloudmarketplace.oracle.com/marketplace/en_US/listing/50393071

https://kscope19.odtug.com/e/in/eid=32&s=2851&print=1&req=info


Thanks,
Mady

Friday, June 21, 2019

Oracle Hyperion Performance Tuning: Changing Heap size in UNIX machine

For UNIX machines or as an alternate method for Windows machine,
change the heap size of a managed server in the product start script:

On the machine hosting the product whose managed server you want to modify, open the product's custom start script in a text editor:

Go to below mentioned PATH for deploymentScripts

EPM_ORACLE_INSTANCE/bin/deploymentScripts/setCustomParamsManagedServerName.sh

For example, to change the heap size for the Foundation Services managed server, open EPM_ORACLE_INSTANCE/bin/deploymentScripts/setCustomParamsFoundationServices.sh.

For example, to change the heap size for the Planning managed server, open EPM_ORACLE_INSTANCE/bin/deploymentScripts/setCustomParamsPlanning.sh.

For example, to change the heap size for the EssbaseAdminServices managed server, open EPM_ORACLE_INSTANCE/bin/deploymentScripts/setCustomParamsEssbaseAdminServices.sh.

Modify the entry that looks like this:

set USER_MEM_ARGS=-Xms128m -XX:PermSize=64m -XX:MaxPermSize=256m -Xmx512m
and edit the value for –XmxValuem to a value appropriate for your environment.

If  you want to change Xmx value to 8GB then mention as
set USER_MEM_ARGS=-Xms128m -XX:PermSize=64m -XX:MaxPermSize=256m -Xmx8192m



Save the file.

Rerun the script for the product after making changes.

Complete these steps for each managed server on each machine in the deployment.

Thanks,
Mady

Oracle hyperion Performance Tuning: Changing the Heap Size in Windows

To change the heap size of a managed server:

For Windows machines, use Windows Registry Editor to change the heap size of the Windows service:

On the machine hosting the product whose managed server you want to modify, open Windows Registry Editor: Select Start and then Run, enter regedit, and then click OK.

In Registry Editor, select HKEY_LOCAL_MACHINE, then SOFTWARE, then Hyperion Solutions, then ManagedServerName, and then WindowsServiceName_InstanceName.

For example, if you deployed a single managed server, select HKEY_LOCAL_MACHINE, then SOFTWARE, then Hyperion Solutions, then EPMServer0, and then HyS9EPMServer_InstanceName.

If you scaled out a single managed server, on the scaleout machine, select HKEY_LOCAL_MACHINE, then SOFTWARE, then Hyperion Solutions, then EPMServer1, and then HyS9EPMServer_InstanceName.

For example, if you deployed Oracle Hyperion Planning, select HKEY_LOCAL_MACHINE, then SOFTWARE, then Hyperion Solutions, then Planning0, and then HyS9Planning_InstanceName.

Right-click JVMOptionX (where X is 1, 2, ...) whose value starts with -Xmx, and then select Modify. In Value data, change the value to a value appropriate for your environment.
-XmxValuem

For example, to set the heap size to 8 GB, enter the following:
-Xmx8192m

Start EPM System by selecting Start, then All Programs, then Oracle EPM System, then Foundation Services, and then Start EPM System.

Complete these steps for each managed server on each machine in the deployment.

Thanks,
Mady