Calc Manager Connection refused: connect

We had a up and running environment, it was compact deployment running on 9000 port, later we redeployed all the components to individual ports. Everything was working fine, we were able to access all the components however when were are trying to access planning applications from Calc Manager were are getting following error:
http://<Server>:9000/HyperionPlanning/servlet/HspAppManagerServlet:
Connection refused: connect

Though we can access calc manager from workspace on 19000 port, we can see all three nodes under Calc Manager, but when we are expanding Planning node in calc manager we were getting above error in the Msg Box (as information), but after clicking ok, we can access all the rules listed under the planning applications.

Error was obvious its still trying to connect to planning at 9000 but planning can be accessed at 19000 or 8300 port! How can we make calc manager to check planning at 8300/19000 port not 9000.
Here are the parts of Calc Manager logs:

<oracle.EPMAWT.DATASOURCE.com.hyperion.awb.web.datasource.Service> <BEA-000000> <Connection refused: connect  java.net.ConnectException: Connection refused: connect

<oracle.EPMAWT.UTIL.com.hyperion.awb.web.util.RegistryUtil> <BEA-000000> <java.net.ConnectException: Connection refused: connect
com.hyperion.awb.web.common.BaseServiceException: java.net.ConnectException: Connection refused: connect

Now the solution part, what can cause this issue, from where its picking 9000 port of planning not 8300, I guess most of you know the answer its EPM Registry. So the first step will be to exporting registry and checking planning entry. To export registry we have a simple command that we need to run on the foundation server, its epmsys_registry.bat, can be found at below location:
<MIDDLEWARE_HOME>\user_projects\epmsystem1\bin


PLANNING_LWA (LOGICAL_WEB_APP): Object ID:   bee6d6feba94f924497fb41413d5e36a41dS7789
It was showing two childeren:
1. PLANNING_WEBAPP (PLANNING_WEBAPP): Object ID:   bee6d6feba94f924497fb41413d5e36a41S7782
2. PLANNING_WEBAPP (PLANNING_WEBAPP): Object ID:   bee6d6feba94f924Sf302b97140875f1ed3S6b01

Ofcourse one of them was pointing to 9000 and other one to 8300, all we need to do was to delete 9000 entry and run the registry clean up (about registry clean up) restart services and you are done.

So,
1. Port Issues -> Check EPM Registry!.
2. There is no harm in cleaning up the registry once in a while!

Cheers..!!
Rahul S.

Comments

Post a Comment

Popular posts from this blog

Multiple Navigation Flows are Active

Image
We have witnessed an issue where application migration or sometimes service restart in PBCS/EPBCS activates multiple navigation flows.  If multiple navigation flows are active you wont be able make changes in any of them, because in order to make change in navigation flow you have to make it inactive. Typically you may end up in following situation:  Solution is pretty simple: 1. Create a copy of any of the existing navigation flow:  2. Give it any desired name:  3. Now, you will see one additional navigation flow, with inactive status: 4.  Make it active: 5.  At this point of time you will have one active navigation flow and two inactive  6. Select the additional navigation flow you have created and delete it  7. Now you are back in business: Rahul S.
Read more

The Member Does Not Exists For The Specified Cube

Image
The member "" does not exist for the specified cube or you do not have access to it. Issue:  If you are running into a issue, where for a RTP member selection is throwing an error for a missing member, this regardless of the member you have selected in RTP or regardless of rule. You may be able to execute the rule from Calc Manager and not from Planning. Reason: You may run into this issue if: 1. You have added members in Planning and have not refreshed the cube 2. For the default value of a RTP in calc member you have a member which is not valid any more for planning application 3. For the default value of a RTP in calc member you have a member which is not valid any more for a plan type Solution: 1. Refresh cube 2. Update Default value of RTP which is causing issue to member which exists 3. Deploy the rule Rahul S.
Read more

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008

My MS-Office Components are Crashing After Installing Smart View on Vista, Windows 7, Windows 2008! This is one more one pretty common issue,   "Smart View handled an unknown exception thrown by Microsoft Office."   This is actually a known issue in version 11.1.2.1. If you look at the read me of Smart View you will find bug# 11696583 "On Vista, Windows 2008, and Windows 7 operating systems, Excel may terminate abruptly upon launching after you install Smart View. Workaround: Turn off “User Access Control” in User Accounts, available from the Control Panel." Here is the link to read me: http://download.oracle.com/docs/cd/E17236_01/epm.1112/readme/sv_1112100_readme.html When the User Access Controls are on Smart View faces problem in registering, when you set it off Smart View register itself like a charm. To have more information on UAC: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx Now, when y
Read more