Have any one did Essbase clustering in EPM 11.2 version?

Vasantha Kumar

We are trying to perform it but the Essbase OPMN is not getting started. After configuration, we have updated the opmn.xml files on both the server as we update normally for the active/passive clustering. When we try to start opmn, it fails and no logs are being reported as well. Any idea?

Madhusudhan. M

Vasantha,

I faced kind of issue before, check out below you can try the solution as mentioned.

http://hyperionplanningandmore.blogspot.com/2015/02/unable-to-start-opmn-and-eventually.html

Thanks,

Madhusudhan

Vasantha Kumar

Thanks Madhusudhan for your quick response. Tried this and it didn't work.

Madhusudhan. M

Have you tried to check to below logs

Essbase Not Starting Using OPMN, Receive Fatal Error: "Cannot open essbase.log file" (Doc ID 1574200.1)

http://blog.checkpointllc.com/essbase-and-opmn-what-if-opmn-crashes

https://docs.oracle.com/cd/E57185_01/EDBAG/failover.html

Thanks

Madhusudhan

Stefanie Riley-Oracle

Thank you for your post!   For your protection, however, I need to temporarily remove the content from public view, as it may contain information that is considered sensitive or personally identifiable (as documented in our Oracle Community Guidelines).

If this information is required in order to successfully describe or troubleshoot your problem, please instead submit a service request in My Oracle Support.  Otherwise, you can edit this post to remove the flagged content (Log file sensitive information ) and resubmit.  The ‘Edit’ link is located in the Actions menu on the right side of your screen.

Thank you for understanding!  Our MOSC contributors look forward to helping you with your initial inquiry.

iArchSolutions-Joe

Try to clear (backup and delete) your state directory under opmn.  See if you can run the "opmnctl startall" command then to see if it generates a new state folder for not. If not then there's likely an issue with your opmn.xml file.  Start there and see what happens.  I often find stepping through the config process over again helps (which you've likely done already) but sometimes a typo will pop up at me.  You can also try checking your opmn.xml in IE our other XML checker to ensure no syntax errors.  If it won't open in IE (blank) then there's likely a syntax issues and that would certainly cause open to fail and not log anything.

if you can, check your opmn.xml file and post it or snd it, feel free!  Just the out anything personal/identifying first.

Joe Malewicki

Certified Cloud Architect

[email protected]

203-880-4268

***Please don’t forget to mark comments as helpful or answered so others in the community can better resolve the same issues if it is encountered.***

iArchSolutions-Joe

Good morning is this issue still open or do you require further assistance?

Joe Malewicki

Certified Cloud Architect

[email protected]

203-880-4268

***Please don’t forget to mark comments as helpful or answered so others in the community can better resolve the same issues if it is encountered.***

UR N

Hi All,

We are trying to configure active/Passive clustering in EPM 11.2 (SQL server 2016 as EPM repository with HA).

We configured as similar to the steps as listed in https://blogs.perficient.com/2020/04/21/building-an-active-passive-essbase-cluster-in-a-hyperion-high-availability-ha-environment-2/

Then we ended up with the error in leasemanager.log shows the error:

[ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid: 1442854174685,0] [tid: 140298866731328] Attempt to connect to database failed with error [[DataDirect][ODBC lib] Data source name not found and no default driver specified].

[ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid: 1442854174685,0] [tid: 140298866731328] Attempt to connect to database failed with error [[DataDirect][ODBC lib] Data source name not found and no default driver specified].

We tried copying the 7.1 ODBC drive from old servers as specified in https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=212270245144199&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2059632.1&_afrWindowMode=0&_adf.ctrl-state=bwq6k97ox_4

but it doesn't help.

Can someone update if they face similar issues while configuring active/passive clustering in EPM 11.2.

User_47EDD

I need to ask....why setup an Essbase Cluster? This provides no real HA and some headaches