EPMLCM:13000 service not available when importing Planning

I ran in to this issue a couple of times, every time the reason was different and the solution was different.

We get this error when we try to take LCM export of the application from Hyperion Shared Services. When shared services try to connect to Hyperion Planning, it internally calls the following servlet:
http://<Server>:<Port>/HyperionPlanning/servlet/HspLCMServlet

You may get this error when this call fails, it can be because of:
1. Time out the request,
2. Something is blocking this url,
3. Wrong server or port information in the EpmSystem Registry,
4. Because of an internal bug,
5. Something else! :)

Here I will be talking about point 3.

Situation: My OHS was configured to direct all the traffic using 19000 base port,  its the default port for OHS for EPM system. Because of some reasons I have to reconfigure OHS to 19001 and I have reverted it to 19000. Every thing else was working fine, I can access HSS, Planning Application, Essbase application, reports etc. until I realize that I cant take LCM export.

I checked the LCM logs and found:
[SRC_CLASS: com.hyperion.lcm.common.LCMLogger] [SRC_METHOD: log] Service currently not available.
[SRC_CLASS: ?] [SRC_METHOD: ?:?] Failed to connect to "http://rahul:19001/HyperionPlanning/servlet/HspLCMServlet" while performing explore/listing of application - "CVI_PLAN". Received status code - 500 with error message - "HTTP Post Execution error occurred during - "WebPlugin.getArtifactListing". Exception : Connection refused"

When I tried access the url: http://rahul:19001/HyperionPlanning/servlet/HspLCMServlet , I got a blank page with regular error message.

When I pulled the EPM system Registry I got to know that HSS port for LCM is still pointing to 19001:




I used the following command to update the registry information:

./epmsys_registry.sh updateproperty \#f84129f6224a3e2fS41b1ba0e14e27c39e30S7ffc/@port 19000

Worked like a charm:


Now when I test the same servlet URL, it got:



There is also a bug floating (which is fixed!) : This issue is caused by unpublished Bug 18327819 - LCM IMPORT FAILS WITH "MAX ERRORS THRESHOLD" SET AS ">5000" IN MIGRATION OPTIONS
Cheers..!!
Rahul S.

Comments

  1. KalaiJanuary 12, 2017 at 12:18 PM

    Great work and thanks for sharing with us.

    ReplyDelete
  2. AnonymousMay 31, 2017 at 8:24 AM

    fyi, we got this message because our IDs did not have planning access. So check your security first!

    ReplyDelete

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