Installing SR1 for v9

Updating v9 or v9.0.0.1 to v9 SR1 (or v9.0.1) is fairly straight forward.

For the Core Components (Engine, Designer, Web Client, etc) you simply need to do the follow:

Ensure that the Deployment Service and Engine Services are stopped (the install will do this if necessary).
Install the AppSight Service prerequisit - see below
Run the SR1 update, it will not ask any questions.
Delete everything from the eActiveEngine table
Run the required Database Scripts - See below
Start the Engine and Deployment Services

AppSight Service Install:

When you unpack the SR1 Core update you will find a "Redist" Directory. Contained in there is a AppSight Directory containing two versions of the AppSight Service; 7.1 and 7.5.1. 7.1 is intended for installation on Windows 2003 or earlier and 7.5.1 is intended for Windows 2008 or later.

Within both directories are batch files that will silently install the AppSight Service for you. You simple run the "InstallAppSight.bat" file and wait until it completes. You can tell it is complete when the Command Prompt window disappears.

Once installed you can continue with the SR1 update.

Database scripts:

After the SR1 update is complete you will need to run some DB scripts to update the respository to v9 SR1.

Important note: Before attempting to run the script you must delete the contents of the eActiveEngine table:

DELETE FROM eActiveEngine

The following is specified in the Release Notes:

For SQL Server:
• eWorkProcedures.sql
• AdminToolsProcedures.sql
• ProcessMetaDataProcedures.sql (if required)

For Oracle:
• eWorkTypes.sql
• eWorkPackage.sql
• eWorkProcedures.sql
• ProcessMetaDataPackage.sql (if required)
• ProcessMetaDataProcedures.sql (if required)
• MBPM_ADMIN_PKG.sql
• MBPM_ADMIN_BODY.sql
• MBPM_ADMIN_SP.sql

Practically speaking, unless you have already modified the Metastorm install to add the ProcessMetaData component of the enigne you will only have to to run:

For SQL Server:
• eWorkProcedures.sql
• AdminToolsProcedures.sql

For Oracle:
• eWorkTypes.sql
• eWorkPackage.sql
• eWorkProcedures.sql
• MBPM_ADMIN_PKG.sql
• MBPM_ADMIN_BODY.sql
• MBPM_ADMIN_SP.sql

Note that the eWork scripts are found (by default) in:

C:\Program Files\Metastorm\BPM\Engine\Database

And the Admin scripts are found (by default) in:

C:\Program Files\Metastorm\BPM\Administrative Tools\Database

Find more posts tagged with

BPM

Comments

Eden Mack

We are currently evaluating v9 and expecting to follow the Side-by-Side upgrade path. This means that I will have to maintain procedures in version 7.6 while developing/migrating solutions in v9. On my development machine I have the 7.6 developer and v9 developer running together (neither engine is installed).

Is there a way to upgrade the v9 developer to SR1? The upgrade package fails to find the engine and halts installation.

Tony Guzzardo

We have recently acquired licensing for Metastorm, and our consultant installed V 9 on a W2K3 server, to allow our developers to begin creating workflow processes. It worked fine and they were able to access using the designer for about 4 weeks. The consultant then recently recommended installing the SR1 and after performing the upgrade we are unable to successfully start the Process Engine.

Any Ideas?

Paul Denton

Hi Eden, welcome to the Community...

How did you install the v9 Designer? The most straightforward method I believe is to just drag the "C:\Program Files\Metastorm\BPM\Designer! directory and contents on to the version 7.6 machine.

As the Designer is a self contain application this will work just fine.

In order to update this I would update the original install to SR1 and the copy that over the previously copied Designer directory replacing all the files (making sure the Designer is not running at the time of course).

Paul Denton

@TonyG

Have you run the version 9 SR1 database scripts to update your Metastorm Repository (see the SR1 release notes)?

Tony Guzzardo

Hi pdenton,

Yes followed the instructions as listed above in this note. Ran the both the eWorkProcedures.sql and AdminToolsProcedures.sql. When attempting to start the process engine, it errors out saying the service "stated then stopped. Some services stop automatically if they have no work to do, etc..."

When trying to log into the web client we get a "no engines available" message.

Thx

Paul Denton

@TonyG

Are you getting an new meesages in the Application Log (Event Viewer) on the Server when the enigne fails to start?

I would suggest contacting the helpdesk to have a member of the support team assist you with this. The will be able to track the problem down.

Tony Guzzardo

I do get a .Net error...looks like something is missing. I'll be contacting the helpdesk later this a.m....thanks.

Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5000
Date:  5/21/2010
Time:  7:54:59 AM
User:  N/A
Computer: WRKFLSVR
Description:
EventType clr20r3, P1 dllhost.exe, P2 5.2.3790.3959, P3 45d6967a, P4 ework.engine.scripthost, P5 9.0.0.0, P6 4bd6e5ba, P7 49, P8 10, P9 system.io.filenotfoundexception, P10 NIL.

Andri_Siswanto

I got error on deploying/redeploying solution in designer after upgrade to SR1.
Here is the error message from designer:
" Error 6/17/2010 11:05:21 AM An internal error has occurred within the Deployment Service. This error has been logged by the server. Please contact your System Administrator. "

Here is the error message from windows event viewer:
"Fatal -> System.NullReferenceException: Object reference not set to an instance of an object. at Metastorm.Deployment.Core.DeploymentService.DoDeploy(IEntity rootEntity, IEnumerable`1 entities) at Metastorm.Deployment.Core.DeploymentService.Deploy(IEntity root, IEnumerable`1 entities) -> 6/17/2010 4:05:21 AM "

Anyone can fix this problem?

Regards,
Andri

Paul Denton

Hi,

I have not seen that specific error before but I would start with the DeploymentService.exe.config in "C:\Program Files\Metastorm\BPM\Deployment". Check the the Data Base connection string is correct.

I take it that the deployment and process engine services start without any problems?

Paul...

Andri_Siswanto

Hi Paul,

The DeploymentService configuration is already correct, but the error still happen.

The Deployment and process engine service is started.

Any other idea?

Regards,

Andri