eFlow 5.x - Clearing Ghost Processes and releasing licenses from Database

Question / Problem: 

We are having an issue where autorun is only starting up 22 stations when we have 25 configured.

AutoRun configuration lists 25 stations.

Answer / Solution: 

Solution Provided

1 - Stop / close all running stations, including Autoruns.

2 - Then go to the SQL Server instance being used by on the eFlow_Management database, run these commands:

delete

 FROM [eFlow_Management].[dbo].[L_LicenseFeaturesUsage]

delete

 FROM [eFlow_Management].[dbo].[L_NodeHash]

delete

 FROM [eFlow_Management].[dbo].[E_Node]

and on the _workflow database, run this command:

delete

 FROM [E_Session]

3 - Start stations and autoruns.

 

This will clear rogue stations and their license usage as well.

Enter How to here:

1. How to Step 1
2. How to Step 2
3. How to Step 3

 

Applies to:  

Product	Version
eFlow	5.x