Art of BI: Hyperion Foundation OpenLDAP service terminated with service-specific error 19 – Win Server 2008

After attempting to install the basic foundation services and Essbase server on a Windows Server 2003 box there were several failures when registering with Shared Services. I also noticed that the openLDAP service was not started.  This is due to Windows 2008 not being 100% compatible with the full Hyperion 11x suite.   To get around this one forum user on the oracle forums found a solution. I image this solution was deduced by comparing either the Windows 2003 11x install with the Windows 2008 install or by looking at a previous version install on a 2003 server.  Either way it works…

http://forums.oracle.com/forums/thread.jspa?threadID=826355&tstart=0

 Apparently they didn’t add in a registry key required for OpenLDAP.

you’ll need to create OpenLDAP and Parameters keys probably:

HKEY_LOCAL_MACHINESOFTWAREOpenLDAPParameters

“ConfigFile”=”C:\Hyperion\products\Foundation\openLDAP\slapd.conf”
“URLS”=”ldap://:28089”
“DebugLevel”=dword:00000000

Once this is done I simply started OpenLDAP up, and did a reinstall of everything and it all seems to be working ok (touch wood anyway!)
Hope this helps.

Here is my registry editor after the fix.

_openldap_regedit_onwin2008_sm1

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

6 thoughts on “Art of BI: Hyperion Foundation OpenLDAP service terminated with service-specific error 19 – Win Server 2008”
  1. Hi,

    I am running in same issue. You have mentioned that we need to reinstall after doing this change. Do you mean reconfigure or reinstall whole EPM stuff?

    Uninstallation runs for ever when I tried to uninstall EPM? How did you uninstall it? I am trying to setup this on Vista.

  2. It looks like it gets a little further after doing this (it can find the LDAP port info), but it is still failing trying to seed a user. Error:nn(Aug 02, 2011, 05:44:35 PM), com.hyperion.hub.HubDBConfigurator, DEBUG, Execute command: C:HyperionproductsFoundationopenLDAPhssupdate.bat C:HyperionproductsFoundationopenLDAPn(Aug 02, 2011, 05:44:35 PM), com.hyperion.hub.HubDBConfigurator, DEBUG, Execute command: C:HyperionproductsFoundationopenLDAPldapmodify -D “cn=root,dc=css,dc=hyperion,dc=com” -a -c -h 11113sql -p 28089 -v -x -w ****** -f “C:HyperionproductsFoundationopenLDAPcss.ldif”n(Aug 02, 2011, 05:44:36 PM), com.hyperion.hub.HubDBConfigurator, DEBUG, ldapmodify return code = 1n(Aug 02, 2011, 05:44:36 PM), com.hyperion.hub.HubDBConfigurator, ERROR, Unable to delete entries in OpenLDAP, failed with result code 1n(Aug 02, 2011, 05:44:36 PM), com.hyperion.hub.HubDBConfigurator, ERROR, Error: njava.lang.Excepti

  3. You are Awasome boss..adding the registry entry resolved my issue. I could have saved 5hrs if I did find your answer earlier.