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.
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.
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
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.
Once you hit this error .
Remember ! Right click and start command prompt as "Run as Administrator"
and the launch the installTool.cmd
This small method does fix the issue.
Ensure you do the same when launching the configurator.
Other related issues are when you navigate to configuring EPMA even though
the default website exists it does not recognize.
Error encountered:
Failed to navigate from ProductTaskSeIectionState: IIS
"Default Web Ste" does not exist and configuration of
IIS products will fail! Please create "Default Web Ste"
or unselect configuration tasks for IIS products See
logs for more details
There could be many reasons for EPMA failed configuration or statup.
Generally EPMA issues are related to DB connectivity. Specially when only HFM & EPMA are not starting then it has to be DB.
One of the recent issues was very simple but had to hunt for every software and anti virus tools on the system . I received this error on the workspace.
Warning
Invalid URI: The hostname could not be parsed.
Code:
com hyperion awb web common DimensionServiceException
Description: An error occurred processing the result From the server
Actor: none
These were the steps for troubleshooting it.
1. Checked if db clients are installed
2. TNSPING <DBSID> is reachable
3. sqlplus <dbuser>/<dbpasswd>@<SID> is connecting
4. Check EventViewer for more details on the issue.
And the issue was with the 3rd one. I was able to connect but the
connection kept dropping from the database.
Solution: 1. Usually this could be due to the Firewall .
Looked for finer details and found that the client had another level
of firewall
setup on DB & APP server. Got it shut on both the sides and it worked !
Event Viewer Log Details:
(EPMA DimensionServer Startup) ERROR WR ERR SESSION MGR DATABASE
UNAVAILABLE:Session Manager could not start because database connectivity
could not be established.Hyperion.CommonSen.'ices.Exceptions.SessionManagerException
:Session Manager could not start because database connectivity could not be
established.
--0 Oracle.DataAccess.CIient.OracIeException: ORA-3135: connection lost contact
at Hyperion.DimensionServer.SessionManager.SessionManager.InitiaIizeSqIConnectionSt
ringO
- End of inner exception stack trace
at Hyperion.DimensionServer.SessionManager.SessionManager.InitiaIize
(BooIean restorePastInstanceSessions, Boolean enableCaching)
at Hyperion.DimensionServer.Process.Program.InitiaIizeSessionManagerO
at Hyperion.DimensionServer.Process.Program.StartDimensionServerO
at args)
