Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Rprkrishnan

Member
Registered:
Posts: 49
Reply with quote  #1 
Hi,
I have a system stage where it moves the folder to the next stage is a specified time in my map. I have some of my folder which got stuck-ed in system stage and I am not sure about the reason for it. To my knowledge this problem was there in the V6.6 and we have migrated to V7.5 before a year and we were not facing this issue after the upgrade. But we have observed that some of the folders are stuck-ed but for the newly created folder it is working as expected. Can any one help me out to move the orders got stuck-ed in the system stage. Thanks in advance.


__________________
RK.
0
Arkady

New Member
Registered:
Posts: 6
Reply with quote  #2 
Did You checked a eLog table? Probably You have (or had) an error in script on action or on next stage. If there is an error, folders will be stuck on system stage.

You can add  user action to this system stage and move all folders manually. This is really simple, but You must change a map.

Normally I add flag action to system stage to move stuck-ed folders, but You
can't do that, because this action will be not available for old case. I'm not sure about conditional action.

Cheers.



0
Rprkrishnan

Member
Registered:
Posts: 49
Reply with quote  #3 

Thanks Arkady for your reply. We can have a user stage and move the order to the next stage but we are trying to do it if possible without making changes to the map. As I remember there were some SQL script in V6.6 which will help to move the order got stuck-ed in the system stage. Is there any script available for V7.5?


__________________
RK.
0
Nappy

Avatar / Picture

Guru
Registered:
Posts: 1,087
Reply with quote  #4 
In sql you have to do some hacking (usefull if it's loads of folders) not sure what needs to be "fixed" of the top of my head but it can mess up BPM

If it's a handfull use the manual method. Advantage there is that it's visible and accountable

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

PS that's for V6/7 for V9 the problem is V9 at the moment ;)
0
Pete

Senior Veteran
Registered:
Posts: 315
Reply with quote  #5 

You could insert a manual action and if there are a lot of stucked folders you could invoke this user action programmatically with the freeflow-DLL


__________________
If you want the job done right, hire a professional.
0
Crash

Member
Registered:
Posts: 17
Reply with quote  #6 
There is a stored procedure example that you can download from the Metastorm Knowledgebase - Article # 1277 but it does require that a conditional action be added to the from stage. The stored procedure creates eWait entries for all folders at the specified stage.

If there is an ongoing problem with stuck folders then you could use the Auto-forward Folder feature in a Common Stage that's applied to the problem stages. There would be various techniques, of course, for specifying the desired destination stage for the auto-forward

- Frank
0
Doogal

Avatar / Picture

Guru
Registered:
Posts: 1,564
Reply with quote  #7 

I think the best approach would be to modify the map. If you absolutely can't modify the map, you can manually update the eStageName in the eFolder table. This won't update the alerts for the folder though, which would require some fiddling around with the eAlert table. It also won't set up any timed actions etc on the new stage, so really is only useful as a last resort.

0
billyG

Member
Registered:
Posts: 45
Reply with quote  #8 
Conditional actions have stopped processing on our live server - no warning, no error messages, no new publications.  Folders are delayed by several hours before we are alerted by a user.  We note the entries in eWait.
But why does this happen in a stable system?

v7.5 sqlserver 2005
0
kjanicki

Member
Registered:
Posts: 19
Reply with quote  #9 
We saw something similiar but timers were also not firing.

To remedy the problem, we modified the engine server registry for the poll interval:

The following registry settings can be configured on each engine:
Poll Interval (secs)
Key: HKEY_LOCAL_MACHINE\SOFTWARE\Metastorm\e-work\Engine\Event manager
Name: Poll Interval (secs)
Type: DWORD
Value: By default, set to 0. If the value is set to a non-zero value, engine will pro-actively look for any events (timers, conditionals, flags) which need processing every n seconds.

 
Make sure to restart engine and check eeventmangervalue column value in eactiveengine table.
 
Seems to have done the trick for now.
0
RogerP

Member
Registered:
Posts: 12
Reply with quote  #10 
To move a folder stage, from the back-end (SQL server)

Locate the folder iD :
Select efolderID From efolder where efoldername = 'the stuck folder'

Update efolder Set estageName = 'New Stage Name' where efolderid = 'efolderid from above statement'

Update eAlert set estagename = 'New Stage Name' where efolderid = 'efolderid from above statement'

This will push the folder to the new stage name - As Doogal pointed out though, this will not create any conditional, timed or flagged actions from the new stage - and the eAlert table will not be rebuilt for the roles of the new stage.

The correct way to do this would be to place a manual action onto the system stage to the new stage - then use Services Manager to put the folder on your to do list - and then initiate the action from your Metastorm UI.

Hope that helps
0
nickym

Avatar / Picture

Senior Member
Registered:
Posts: 52
Reply with quote  #11 
Not sure if this is too simple but maybe just check if there is not something on the stage to where the folder should be going (or even on the action leaving the system stage) that could be causing an error and therefore the folder is trying to go down that path but is rolling back due to the error and remaining in the system stage. If there was more than one conditional off the system stage and one of the conditional actions was blank (with the highest priority, of course) then all the folders would route that way.
Just a thought because sometimes it can be a very simple thing that trips us up and we tend to over look those and seek out a "bigger" issue.

__________________
Nicky
0
harsh

New Member
Registered:
Posts: 1
Reply with quote  #12 
Can anyone help with query to identify stuck folders in metastorm using stored procedure.
0
nicholsmarkd

New Member
Registered:
Posts: 2
Reply with quote  #13 
So what's the downside of simply updating eFolder.eStagename, particularly for a single folder? I just tested it and though the change isn't reflected in the watch/todo lists, once it's out of the stuck stage I (admin) simply advance it on to where I want it and everything is good. Also, if I really need the lists updated I could just update the eAlert table stagename and caption appropriately.
Am I missing something?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #14 
Quote:
Originally Posted by Doogal

I think the best approach would be to modify the map. If you absolutely can't modify the map, you can manually update the eStageName in the eFolder table. This won't update the alerts for the folder though, which would require some fiddling around with the eAlert table. It also won't set up any timed actions etc on the new stage, so really is only useful as a last resort.

What Doogal said .....


__________________
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!