Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #1 

Moving 'Stuck' Folders from a System Stage

Last edited: 28 Feb 2005


The information in this article applies to product: e-Work 6.x

Issue

  • Folders are entering a system stage, but they're not moving on to the next stage as expected.

Resolution

  • The attached stored procedure was created for use with SQL Server and will need to be modified for Oracle. In addition, it is only for use with system stages where conditional actions move the folder on. If timed actions are used, this stored procedure will not work.

    If conditional actions are used, do the following to recreate the eWait records and move the folders to the next stage:
    1. The attached file creates a stored procedure with 'dbo' as the owner. If necessary, this should be changed so that the e-Work Engine has access to the stored procedure.
    2. Run the SQL to create the stored procedure.
    3. Run the stored procedure. It has 2 input parameters: stagename, mapname. So you would run it (e.g. in Query Analyzer) as 'EXEC StuckFolders @Stage = stagename, @Map = map' where 'stagename' and 'map' are the appropriate values.
    4. This will create the necessary records in the eWait table. If the folders need to be moved on immediately, then restart the Engine.                                                 Otherwise, the eWaits will be processed when the Engine processes another conditional or timed action.

Keywords: kb498


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
 


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!