Workflow Server Maintenance

Last updated 3 months ago

Learn maintenance tasks for the Workflow Server.

What you'll learn

Operate the workflow server

Prerequisites

Having a CoreMedia system

Time matters

Reading time: 5 minute

Should I read this?

This guide is for Developers, Administrators.

Table of Contents

Uploading Process Definitions
Updating the Workflow Server
Clearing the Workflow Server

Uploading Process Definitions

If you need to upload new or modified process definitions, there are some things you should keep in mind.

If a modified process definition is re-uploaded and still uses the same name (e.g. StudioSimplePublication) the older definition will not be overwritten. A new definition with a new id is created and both definitions share the same name.
The older definition is disabled automatically, the newer version is enabled instead. The now enabled workflow definition is used when the Workflow Server creates new processes or retrieves a process definition by name.
It is not necessary (and in fact not possible using the API) to delete older process definitions. On the contrary it is recommended to keep them, in case there are still running processes that depend on the older definition. Deleting a definition at the database level while there are still running processes can cause severe errors.

Updating the Workflow Server

After the Workflow Server has been updated to a new version of the CMS, the parsed and serialized process definitions might no longer fit the currently deployed classes. This might cause the Workflow Server to raise an error when a process definition is first accessed. To update the parsed and serialized process definitions, call the tool cm workflowconverter before restarting the Workflow Server after the update.

Clearing the Workflow Server

If you need to delete all processes instances in a Workflow Server database schema, perform the following steps in exactly this order:

Stop the Workflow Server.

Delete all records from the following tables using SQL:

DELETE FROM WFVARIABLES;
DELETE FROM WFTASKINSTANCES;
DELETE FROM WFPROCESSINSTANCES;

Start the Workflow Server and restart all attached clients and services.

If you need to clear the entire Workflow Server database including the definitions, proceed as follows.

Stop the Workflow Server and all attached clients and services.

Execute the following SQL statements:

DELETE FROM WFVARIABLES;
DELETE FROM WFTASKINSTANCES;
DELETE FROM WFPROCESSINSTANCES;
DELETE FROM WFTASKS;
DELETE FROM WFDEFINITIONS;
DELETE FROM WFPROCESSES;

Start the Workflow Server and restart all attached clients and services.
Upload all process definitions.

Is this page useful?