Need Help! Metastorm BPM v9.1 SR1 - Metastorm Process Engine and Deployment Service will not start

Daniel Stallworth

After upgrading to Metastorm BPM 9.1 SR1 the Metastorm Process Engine and Deployment Service will not start. I've tried everything I've found in blogs and installation guides to no avail. I'm still getting the same result...

 

Source: Metastorm Process Engine
Category: eDatabase
Unable to open table while doing initialisation.  Table name: eActiveEngine.  Additional info: Source=OraOLEDB - Error=ORA-04063: package body "METABPM.EWORK" has errors
ORA-06508: PL/SQL: could not find program unit being called: "METABPM.EWORK"
ORA-06512: at "METABPM.ESP_REMOVE_MARKS_FOR_ENGINE", line 5
ORA-06512: at line 1.

 

Source: Metastorm Process Engine
Category: eServerConfigurer
The .NET database connector failed to initialize: System.NullReferenceException: Object reference not set to an instance of an object.
   at eWork.Engine.ScriptHost.ScriptHostLoader.createObject(String assemblyName, String typeName)
   at ManagedConfiguration.StopCoreServices(HStatus* ).

 

Source: Metastorm Process Engine
Category: eServerConfigurer
A problem occurred during initialisation.  The Metastorm Process Engine is shutting down.

 

Source: Metastorm Deployment Service
Category: None
Service cannot be started. Metastorm.Common.Addin.AddInException: A start-up command failed with an unhandled exception.
 Command Type: CheckDatabaseConnectivity
 Exception Type: FileNotFoundException
 Exception message: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. --

-> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file

specified.
File name: 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20,

Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
File name: 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, P...

Jerome_Pearce

Have you changed the database login details since the first installation? If so, you need to update these in the registry, and in various XML files dotted about your system.

 

Have you run the correct database scripts after the upgrade?

achopra

It has been awhile, but I seem to recall that you are supposed to remove the row from the eActiveEngine table before starting up the Engine for the first time after the upgrade from 9.0 to 9.1.  I believe that it is stated in the release notes.  I'd give that a try.

Daniel Stallworth

Thank you, Ari. Yes, I ran the sript to remove the row from the EACTIVEENGINE table according to the guide. Should I have updgraded to version 9.0 before upgrading to 9.1 SR1? The previous version was 7.6 SR2.

Daniel Stallworth

Thank you, Jerome. The database details have changed. I made the edits to the registry as well as to the various xml files.

achopra

Yes, I believe you have to upgrade to v9.0 before going to 9.1 if you are coming from 7.x.  Double check the installation guilde pdf to be sure.

Jerome_Pearce

I am not quite sure what you mean, Ari. There is no actual 'upgrade' from 7.6 to 9.0 or 9.1 as far as I can see. All that is available is a new installation, and if you wish to migrate from 7.6, you then perform the migration. Do let me know if that is wrong.

 

As far as having to migrate to 9.0  then upgrade to 9.1, I have not found this to be the case at all. There seems to be no such limitation in 9.1, and you can migrate directly from 7.6 to 9.1. Once again, do let me know if that is wrong.

 

To mee it sounds like this is a configuration error that will need to be referred to Support.

---

Ari Chopra wrote:

Yes, I believe you have to upgrade to v9.0 before going to 9.1 if you are coming from 7.x.  Double check the installation guilde pdf to be sure.

---

Brian Mellert

When I reinstalled my dev servers (built an updated OS) and built my QA and production environments, I did a direct 9.1 install without issue following the directions, so installing 9.0 then installing 9.1 is not needed.

achopra

I stand corrected...perhaps I had a little too much egg nog...