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...