FDMEE connection issue
Event Viewer Error
Added entry TNSNAMES.ora for AIF_ORCL
Sunday, September 7, 2014
Tuesday, August 19, 2014
Opatch command to update only inventory and not Filesystem
A number of times Oracle inventory gets corrupted. It shows blank inventory even if you are certain that patch was applied.
In my case:
Environment was patched to 11.1.2.3.500
A few months later when I checked the inventory it was blank.
So in cases like these where I am sure which patch is applied. I can do the following to update only the inventory and not the File system
opatch apply -no_sysmod <patchnumber>
Specifies that OPatch need not update the files in the system, only the inventory. It also does not execute the pre and post scripts.
In my case:
Environment was patched to 11.1.2.3.500
A few months later when I checked the inventory it was blank.
So in cases like these where I am sure which patch is applied. I can do the following to update only the inventory and not the File system
opatch apply -no_sysmod <patchnumber>
Specifies that OPatch need not update the files in the system, only the inventory. It also does not execute the pre and post scripts.
Unable to open calculation manager post SSL configuration
Problem: Unable to open calculation manager in SSL environment.
Description: Calculation manager opens up fine in non-SSL, http protocol but has throws below error in when using https protocol.
Logs:
[2014-08-18T05:31:55.547-07:00] [CalcMgr0] [NOTIFICATION] [] [oracle.bi.bifndnepm.calcmgr.common.GenericLogger] [tid: 19] [userId: <anonymous>] [ecid: 00iNrnMw4RXFw0zwBG0Ezz00bai3j1my00000t00000AS,0:1:1] [APP: CALC#11.1.2.0] [URI: /calcmgr/modules/com/hyperion/calcmgr/web/filterview/Adf.do] [SRC_CLASS: com.hyperion.calcmgr.common.CalcMgrODLLogger] [SRC_METHOD: logStackTrace] Unable to process the request.[[
The session is not authenticated. com.hyperion.calcmgr.excp.UnauthorizedSessionException: Unable to process the request.
The session is not authenticated.
From the logs it was clear that the authentication token is not being passed between workspace window and calculation manager.
Solution:
This issue might occur in SSL enabled servers. I was not able to replicate the issue in production server. It was present only in development environment.
Run the following command from the EPM_INSTANCE_HOME/bin directory in order to add the missing property
epmsys_registry addProperty /CALC_MANAGER_PRODUCT/@BINDOWS_ENABLED true
Description: Calculation manager opens up fine in non-SSL, http protocol but has throws below error in when using https protocol.
Calculation This content cannot be displayed in a frame To help protect the security of information you enter into this website, the publisher of this content does not allow it to be displayed in a frame. What you can try: Open this content in a new window
Logs:
[2014-08-18T05:31:55.547-07:00] [CalcMgr0] [NOTIFICATION] [] [oracle.bi.bifndnepm.calcmgr.common.GenericLogger] [tid: 19] [userId: <anonymous>] [ecid: 00iNrnMw4RXFw0zwBG0Ezz00bai3j1my00000t00000AS,0:1:1] [APP: CALC#11.1.2.0] [URI: /calcmgr/modules/com/hyperion/calcmgr/web/filterview/Adf.do] [SRC_CLASS: com.hyperion.calcmgr.common.CalcMgrODLLogger] [SRC_METHOD: logStackTrace] Unable to process the request.[[
The session is not authenticated. com.hyperion.calcmgr.excp.UnauthorizedSessionException: Unable to process the request.
The session is not authenticated.
From the logs it was clear that the authentication token is not being passed between workspace window and calculation manager.
Solution:
This issue might occur in SSL enabled servers. I was not able to replicate the issue in production server. It was present only in development environment.
Run the following command from the EPM_INSTANCE_HOME/bin directory in order to add the missing property
epmsys_registry addProperty /CALC_MANAGER_PRODUCT/@BINDOWS_ENABLED true
Wednesday, July 9, 2014
INST-08010: Error in validing the port range for auto port allocation
OBIEE 11.1.1.7 Port conflict
Error message : INST-08010: Error in validing the port range for auto port allocation. At Least 2 ports should be free within the range 7500-7500 for the Adminserver and Adminserver SSL
Reason: Host file does not have entry for localhost
Solution:
1. Go to windows Run > drivers
2. Open etc/hosts file
3. Add entry
127.0.0.1 localhost
127.0.0.1 hostname
**If it is not letting you save. Open notepad as "Run as administrator" , open host file > edit and save it.
4. Save and exit
Start the installer again. It successfully installs this time around.