Hyperion On-Premise, Cloud and OneStream

Wednesday, September 4, 2019

FDM to FDMEE Migration White Paper

FDM to FDMEE Migration White Paper
FDM to FDMEE Migration White Paper
FDM to FDMEE Migration White Paper
FDM to FDMEE Migration White Paper

https://knowepmbi.files.wordpress.com/2015/11/fdmtofdmee_migration.pdf

22659123 - FDM CLASSIC TO FDMEE MIGRATION UTILITY V 1.1 (Patch)

Thanks,
Madhusudhan

Thursday, August 22, 2019

Hyperion Log file Locations

Here, you can find log locations for Hyperion components:

Essbase Logs:

https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s12.html

Planning Logs:
https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s14s01.html

HFM Logs:
https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s14s02.html

Smartview Logs:
https://docs.oracle.com/cd/E12825_01/epm.111/epm_install_troubleshooting/frameset.htm?ch03s07s04.html

Foundation Logs:
https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s10.html

Thanks,
Mady

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