Oracle DRM Blog

17 Oct, 2007

How to Solve Hyperion DRM Startup Problem

Posted by: Daniel In: Oracle Data Relationship Management

If you tried or installed Oracle Data Relationship Management for the first time, you may sometimes encounter a problem starting the service on your server.

The symptom is the service is getting stopped automatically when you tried to start the Hyperion DRM console. It starts and stops automatically. When you checked in the log, you will see something like “Exception, Init failed, Process manager is not initialized, access violation at address xxxxxx in module “mdm-ntier-process-manager.dll”

To solve this issue, here’s a few quick tips:

  • Check that you have created all the system users in W2K3 using CMD and run lusrmgr.msc. Make sure you have user ‘mdm_db’ and ‘mdm_system’ created with ability to access ‘Administrators’ group privilege. Also it’d be useful to use DRM’s default password ‘Welcome!’ for these accounts. It’s also important to deselect the need to change password on the next login, and make sure check password never expires.
  • Go to database settings. Set engine login as ‘mdm_system’ and use the default password ‘Welcome!’. For database login use ‘mdm_db’ and ‘Welcome!’ as the password. Don’t forget to test the database connection.
  • Make sure you have executed all the SQL scripts manually if you didn’t do that during your installation. This ensures the database tables are properly setup.
  • When running the Data Relationship Management server installer for a Complete installation on
    Windows 2000 SP4, there is a scenario where the installer displays the “interrupted prior to
    completion” message. All components appear to have been installed successfully but the
    database is not created and the config.xml file is not fully populated. Running the installer
    again and selecting Repair corrects the problem and the server will start successfully.

Now try restarting the service in the DRM console. If all goes well, the service will remain green, and not changed to red as soon as it’s started.

The above tip is based on a local machine install using MS IIS app server and MS SQL 2005 server for the database.

Visitors who read this post, also read:



Tags: , , , , ,

22 Responses to "How to Solve Hyperion DRM Startup Problem"

1 | Anmol Agarwal

September 22nd, 2008 at 8:34 am

Avatar

Hi,

I have followed all the steps you have mentioned above. Many thanks for the help. After I followed all the steps, my DRM service issue is solved, but I am still finding issue in getting MDM gateway page.
Please let me know how to fix it.

Thanks
Anmol Agarwal

2 | Daniel

September 25th, 2008 at 11:02 am

Avatar

Anmol, I looked at your screen shot and it looks like it’s an IIS issue. Try doing Start | Admin Tools | IIS Mgr then select Web Site -> Default Web Site -> mdm_ntier. Then select the file VersionMgr.asmx and right click for Properties. Select the File Security tab and select EDIT. Then you need to check that anonymous access is checked. You should also have IUSR_MACHINENAME as the user and a hidden password. If you see this then you’re good. Chances are this has not been setup. Let me know how you go…

3 | Venkat Iyer

October 5th, 2008 at 11:59 pm

Avatar

Hi Daniel,

I have done all the pre requisites and post installation checks after the installation of DRM 9.3.2. I have also ensured that everything is as per the tips list mentioned above. However, I still get some errors. Please find them given below.

MDM Ntier Service – Exception in Data Relationship Management Service: EOleException: The object invoked has disconnected from its clients

MDM Ntier Service – Init failed.

MDM Ntier Process Manager – Exception Emdm_Exception with message ‘Process manager is configured with invalid username and/or password.’

MDM Ntier Process Manager – Exception Emdm_Exception with message ‘Process Manager is not initialized.’

MDM Ntier Process Manager – Exception Emdm_Exception with message ‘External Exception EAccessViolation with message ‘Access violation at address 7C84AFB2 in module ‘ntdll.dll’. Write of address 00000034′. Check server application log for detailed bug report.’

DB – Oracle 10.2.0.3.0
O/S – Win 2003 R2 SP2

Not sure if I’m missing something. Hope the above errors provide some information to you.

4 | Daniel

October 13th, 2008 at 9:43 am

Avatar

I cannot help without being on-site. The error pointed to process manager user or password error. Have you created the right user on the windows box and check in console the right user/password for mdm_system etc?

5 | Ruud Verdaasdonk

November 3rd, 2008 at 3:36 am

Avatar

Hi Daniel,

I’ve fot the same problem as described by Venkat Iyer. With the following descriptions:

MDM Ntier Engine – Exception Emdm_Exception with message ‘External Exception EAccessViolation with message ‘Access violation at address 005C926A in module ‘ntdll.dll’. Write of address 0000001C. Check server application log for detailed bug report.’

MDM Ntier Service – Exception in Data Relationship Management Service: EOleException: The object invoked has disconnected from its clients

MDM Ntier Service – Init failed.

MDM Ntier Process Manager – Exception Emdm_Exception with message ‘Process manager is configured with invalid username and/or password.’

MDM Ntier Process Manager – Exception Emdm_Exception with message ‘Process Manager is not initialized.’

MDM Ntier Process Manager – Exception Emdm_Exception with message ‘External Exception EAccessViolation with message ‘Access violation at address 7C84AFB2 in module ‘ntdll.dll’. Write of address 00003740. Check server application log for detailed bug report.’

DRM – 9.3.2.0.0
DB – Oracle 10.2.0.3.0
O/S – Win 2003 R2 SP2

I’ve checked all the user password for mdm_system and mdm_db.

This problem is only occuring by connecting to a specific database (Acceptance) in our environment. Connecting to a production / test en development database is working Ok?

6 | Venkat Iyer

November 5th, 2008 at 2:01 am

Avatar

Hi Daniel,

Thank you for your reply. I was using the new password (DRM fresh installation), instead of using the old password as it was an upgrade from 9.2 Now that I have restored the password everything works fine. Thank you very much for your assistance.

Regards,
Venkat Iyer

7 | Daniel

November 6th, 2008 at 1:54 pm

Avatar

‘Process manager is configured with invalid username and/or password.’ — the system don’t lie. Try doing a TNSping or use SQLPlus/SQL developer to connect on the server that you install DRM on. Most of time I find network or driver issues to be the cause. Let me know how that goes.

8 | Venkat Iyer

November 10th, 2008 at 12:06 am

Avatar

Hi Ruud,

As Daniel mentioned you have to check the password of the mdm_system. In case if you are unable to connect with the default passwords eventually that indicates that the password has been changed. As a workaround you can try using a different username / password and start the server.

Hope this info helps.

Thanks,
Venkat Iyer

9 | GP

March 11th, 2009 at 2:36 pm

Avatar

Hi , I installed MDM Migration setup.exe on the server box and un-installed it. After this I get an error connecting to the mdm gateway. When I start up DRM I get an error “A String literal was expected, but no opening quote character was found. Line 20 Server Error in ‘/. Can anyone please help!

10 | Daniel

March 11th, 2009 at 4:34 pm

Avatar

Maybe you want to install it back. There should not be a reason to uninstall it, is there? There’s definitely issue with the install, my guess is the IIS settings. You can go into the IIS manager and look underneath ‘Default Web Site’ where web services aspx are registered. You know what, reinstalling the server software mdm_setup.exe maybe your other option. There’s no harm in it because you still have the backend SQL Server or Oracle where all the master data are stored. You just need to jog down all the settings such as mdm_system account login/password etc. Just don’t reinstall the database scripts because that may create tables that already exist. The reinstall should put everything on the server side back to the way it should be.

11 | Suhail

June 24th, 2009 at 8:13 am

Avatar

Hi Daniel

I have installed DRM 11.1.2 , The server runs successfully. But When I am trying to access it client , I am getting an error as “Unable to connect http://localhost/mdm_ntier.
And in the server window I am getting the error as “Exception Emdm_Exception with message ‘Process Manager is not initialized.’ ” . Please help me on this . It is very urgent issue to be resolved for me . Kindly help !!!

12 | Murali

July 19th, 2009 at 11:29 am

Avatar

Hey,

Are you able to work with DRM now,Could you just compile all the steps involved while installing DRM on Oracle DB and post,it willl be useful for most,

Thanks!

13 | Daniel

July 31st, 2009 at 5:09 am

Avatar

Have you considered using SmartView which is easier to install (it has its own separate installation package with smaller footprint). Yes you have to teach the users but if this is the future direction from Oracle Hyperion, you’d just have to bite the bullet.

14 | Phillip Stone

August 18th, 2009 at 9:02 am

Avatar

Hi Daniel,

Here’s a summary…
The error is:
1. Could not create event mgr.
2, Exception in Data Relationship Management Service: EOleSysError: The server process could not be started because the configured identity is incorrect. Check the username and password

My DB is Oracle 11g.

I’ve just done a new install of 11.1.1.2 of Hyperion DRM and started the DRM Console.

I followed your advise…
• Check that you have created all the system users in W2K3 using CMD and run lusrmgr.msc. Make sure you have user ‘mdm_db’ and ‘mdm_system’ created with ability to access ‘Administrators’ group privilege. Also it’d be useful to use DRM’s default password ‘Welcome!’ for these accounts. It’s also important to deselect the need to change password on the next login, and make sure check password never expires.
• Go to database settings. Set engine login as ‘mdm_system’ and use the default password ‘Welcome!’. For database login use ‘mdm_db’ and ‘Welcome!’ as the password. Don’t forget to test the database connection.

The database test is successful but, I’m still getting the error above when I try to start the server.

Any ideas?
Thanks, Phil

15 | Phillip Stone

August 18th, 2009 at 10:51 am

Avatar

Regarding the post… The error is:
1. Could not create event mgr.
2, Exception in Data Relationship Management Service: EOleSysError: The server process could not be started because the configured identity is incorrect. Check the username and password

I solved this issue by
1. creating the mdm_system and mdm_db users on the Windows Server and added to admin group.
2. Re-installed DRM and used the new mdm_system user id on the Windows Com + Logon screen changed my parameters to:
Domain or Machine Name: [machinename]
Account: mdm_system
Password: ***** (used default)

Now, there are no errors in the Event Log.

16 | Daniel

August 19th, 2009 at 2:27 pm

Avatar

Excellent, glad you’re able to resolve your issue !!! Yes, sometimes you can fix the problem and do a re-install and the problem goes away with a clean slate…

17 | Rajender

November 13th, 2009 at 1:05 pm

Avatar

We installed DRM 11.1.1,I checked all the above steps mentioned.every thing is perfect but strucked with the following errors,
1. MDM Ntier Process Manager – Exception Emdm_Exception with message ‘External Exception EAccessViolation with message ‘Access violation at address 7C84AFB2 in module ‘ntdll.dll’. Write of address 00003740. Check server application log for detailed bug report.’

2.MDM_Ntier_Engine: Exception Emdm_Exception with message ‘Could not create a JVM. Error: ‘Class not registered”

18 | Ravi

December 2nd, 2009 at 3:35 am

Avatar

Hi !,

Just i installed MDM server, trying to start the services & it

Starts and automatically stops after few seconds.

It shows the following error:

“Exception EOleException with message ‘Could not create a JVM. Error: ‘The specified module could not be found” ”

Any idea ! Thanks in-advance…..

19 | Daniel

January 27th, 2010 at 9:04 am

Avatar

You rpobably have not configured the Windows components yet.

20 | Daniel

January 27th, 2010 at 9:06 am

Avatar

You need to check the console for more details of the messages. The process manager doesn’t start usually is because of the app server setup or not able to connect to the database. I need more info to troubleshoot further for you.

21 | ramesh

February 16th, 2010 at 7:59 am

Avatar

Can anyone please help me with any documentation for migrating from MDM version 8 to 11.

Thanks in advance.

22 | Daniel

March 3rd, 2010 at 1:37 pm

Avatar

There isn’t any documentation as such from version 8. The DRM database structure is very different, you will have to rebuild it. Shouldn’t be too hard. Let us know how we can help.

Regards,
Daniel Poon

Comment Form

Categories

Archives

Search


  • Daniel: Ravi, yes there're a couple of properties needed for Essbase. If you are using v11 DRM, you should have the templates available already. Just check it
  • Daniel: Hi Tonia, use 9.3.1 add-in and it'll work fine unless you absolutely need version 11 features. In that case, we maybe able to help offline. Regards,
  • Daniel: There isn't any documentation as such from version 8. The DRM database structure is very different, you will have to rebuild it. Shouldn't be too hard

About This Blog

My name is Daniel Poon. I am a multi-disciplined business intelligence professional with a strong dynamic career leading Financial Processes, People, BI Systems and Global Projects to accomplishments. Known for passion in implementing process excellence, quality BI solutions and creative innovations. Thanks for visiting my special interest blog.

 Subscribe This Blog For Free Now

Disclaimer: The words, ideas and opinions here are my own. Please don't assume they represent the opinion of my employer, any other person or organization. Do read the Terms of Use. If you would like to quote me, please ask me first or provide a link back.

Copyright © 2007-2009 by Daniel Poon. All Rights Reserved. No part of content published here shall be copied or printed elsewhere without expressed permission from me.