Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
RMiranda

Member
Registered:
Posts: 25
Reply with quote  #1 

Hey,

I'm stuck with something for the past couple of days.

He have a child-parent functionality implemented vai Flags (not via clone or anything metastorm outofthebox)

Shortly, in a specific Stage there's a User Action that does a %RaiseFlag and goes back to the same stage.
At the respective Flagged Action (child creation) that was raised i do a select with nolock to the metastorm table to get all the fields from the parent. This is when the workflow just stops, with putting any error to elog table. Also the child folder is not inserted in the metastorm folder

The thing is, this only happens in Production Env, Development and Quality/Testing works great, i even used the exact same data of the folder from Production in Development and it still works.

We have very limited privileges in Production, so i can't see if there's any deadlock, but don't think so because i'm using nolock.

Any tips on troubleshooting this?

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
Generally as our Best Practice, we will start a child folder, move to a system stage, then attempt any data retrieval and assignment in a conditional action from there. We have a second conditional action that takes it to a 'Failed' stage if something goes wrong.

there are many reasons to do this, but mainly so that an actual folder exists to indicate an error occurred. Administrators can the retry or work around the issue.

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

Member
Registered:
Posts: 25
Reply with quote  #3 

Ok, i was oversimplifying in Flagged Action sequence, we have something similar to the best practice, Flagged Action
   User Stage:Init Child
      Conditional Action(1=1)
         System Stage:Saves Child(this is where it stops)
            Conditional Action: Failed (based on control variable)
               User Stage: Failed ...
            Conditional Action: Success (based on control variable)
               Continues normal workflow

Now thinking about it, the folder should definitely be created right?

I'm going to try a workaround, passing via Flag Data all the variables that are being retrieved in the stalled select statement. Only be able to test it tomorrow, because of change policy....

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
Yes, the folder should be created if there is no code in the 'submit' event of the flag action.

I would be wary of passing in flag data. This needs to be assigned during the flag action because the data does not exist later. If any data is not text, a conversion must be done, and it may fail. One alternative is to pass in the data as a delimited (not tabbed) string, and assign to a variable. This is then extracted and assigned in a system action with a 'fail' backup action.

In version 9 it is safer because the flag parameters are strongly typed, and assigning these is very unlikely to cause the flag action to fail.

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

Member
Registered:
Posts: 25
Reply with quote  #5 

version 9 i wish, we are still running version 6 :P

Well the workaround with the flag data seems to have done it, but i'm still itchy as to why it was not working previously...

Thanks for the tips!

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #6 
... and if text is too long to fit in the variable, it will fail too (used not to in version 5).
__________________
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
RMiranda

Member
Registered:
Posts: 25
Reply with quote  #7 
Quote:
Originally Posted by Jerome
... and if text is too long to fit in the variable, it will fail too (used not to in version 5).


And would any of those failed situations be inserted into elog?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #8 
I am pretty certain they are, yes. It may be that they are only put in the event log, though, my memory is not good on that one.
__________________
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!