Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #1 

We are currently on 9.2.1.7 (we had to roll back from 9.3.1.1 due to some incompatibility issues), but I have seen the following occur in 9.0, 9.1, 9.2 and 9.3, so its not version specific.  Does anyone have suggestions on how to address / diagnose / fix the following:

  1. I have actions which work with no issues most of the time, but occasionally error with "Stored procedure 'esp_update_action' failed." message.  Most of the time the action will resume normal processing if tried again.  The stack trace is usually useless to me in nearly all cases, but more (or is that less) so in this case.  This is an internal MBPM database procedure.
  2. Similar to above, a user edits a form and clicks the OK to save.  The form just "spins" or shows the white screen usually seen while saving, but the form never finishes closing, no error is reported anywhere, and the window itself doesn't even time out.  The action usually appears to finish internal to the database, but the users doesn't see / know that.  If the user closes the white/spinning (depending on view) window and tries again, it usually works.
  3. I've seen this in V7 as well, but only rarely.  I've seen more frequently on V9, but I think its more of an IE thing than an MBPM thing.  The forms sometimes freeze (To Do / Watch or actions) and eventually IE reports its recovering the web page.  There's no messages anywhere we see (users don't display the error messages IE suppresses) and it only happens on occasion.

We are in the QA test phase of our last and biggest migration of a process (a rewrite, not a migration as that didn't work well either).  However, those occasional issues above are giving our users little confidence on V9.  Note that we have seen this on occasion on other and unrelated solutions as well, but that audience / user community is a bit more flexible.  They do not occur all of the time, but enough to give our users less confidence in V9.

(I'm also posting on the official site, but responses here are generally more timely and useful.)
0
JoeOmerta

Veteran
Registered:
Posts: 210
Reply with quote  #2 
I get problems 1 and 2 a few times a week in my production environment.  #3 i might've seen once in the past 2 years.

I kinda of just noted it as another "Metastorm bug" as it doesn't really effect anything.
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #3 
I fear its "just another MBPM bug" as you elude to as its so hit and miss from what I've seen ... but that doesn't give my user community who has to sign off much confidence.  But I suspected, before your post, that may be the case.  But figured its worth asking just in case someone can suggest something more.  (At least others are seeing it and its not just us, so that lends itself more to an MBPM thing and not environmental here.)
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #4 
Or how about:

4. anybody else having issues of the form refreshing (reopen folder) with actions from the prior stage when the folder changes stages, and therefore actions should no longer be available?  I've had a few reports of this.  I know I can refresh, but the user's have no clue about that ... and again doesn't give much confidence to them.  This had never occurred in V7, but does more frequently in V9.
0
JoeOmerta

Veteran
Registered:
Posts: 210
Reply with quote  #5 
I've seen it where it doesn't always catch up with itself.  If it goes on to a system stage which then forwards it on to another stage, it will show the system stage on the todo/watch list until it's manually refreshed.

I haven't seen it with actions from the prior folder unless someone else gets to it first.  ie, 3 people share a workload, person A opens the form to review it, person B also opens the form to review it(person C is useless), person A approves it while person B is still reviewing it.  The form goes on to the second stage and is NOT locked because the action is complete.  Meanwhile person B still has the previous actions and can try anyone of them but gets errors because they no longer exist.
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #6 
In this case, the folder is moving from one user stage to another user stage, where the folder reopens automatically for the user.  No intermediate stages.  This is when actions sometimes show from the prior stage.
0
ryansaul

Member
Registered:
Posts: 16
Reply with quote  #7 
Hi,
I often experience the issues you are observing.
Regarding the 'esp_update_action' failed; this occurs to our users several times a day (relating to point (4). I logged this as a bug about 2 years ago, however as it was intermittent, I could not reproduce this on a test solution to send at the time. This issue was never resolved and I hoped as I applied updates and upgrades it would eventually be resolved; however this was not the case.
What is noticed is the actions against the stage do not refresh; and this causes the issue until F5 is pressed; or form is reopened.

Regarding where the loading wheel just spins; I occasionally get this when the form is opening at a specific stage for all folders. The only resolution I have is to force a refresh of the IIS app pool. I have not noticed this when a form is closed.

IE also does not respond sometimes, and closes all tabs; but this is infrequent.

(I am currently on v9.2.1)
0
JoeOmerta

Veteran
Registered:
Posts: 210
Reply with quote  #8 
I'm curious if the wheel spinning on open when nothing happens was that problem where it runs your "On Load" code multiple times.  I remember putting random messages in there and they would be written in the admin logs backwards or up to 3 times each.
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #9 
I have seen that on load condition and since we have "are you sure you want to cancel" client script on cancel of many forms I see this as it pops up that box "on load" when it reloads automatically.  That is another issue as well.

I've seen this "on save" as well when closing a form with no activity.

I'm going to raise the esp_update_action issue today since I have a dump of it occurring enough, though I won't hold my breath for a reply from what you've stated.  It seems worse in 9.2.1.7 than before, but that could just be because I have a large user community hitting MBPM more at once time than before.  I will relay if I get any information from OT.
0
gfield

Avatar / Picture

Senior Member
Registered:
Posts: 61
Reply with quote  #10 
I have found a problem where if the form has a grid which is initially hidden, when opening the form it causes the form load to fail and not display. If on form load you do not affect the BO for the Grid, so no grid refresh is fired it all works ok. However, when you set the BO Grid Parameter value i.e gridID = 0, so it appears empty, this causes a refresh, but the grid is hidden so the refresh code can't find the grid causing a length = 0 jscript error.

To resolve the problem, I created a Panel, placed the Grid and other bits in the panel with visibility not set, then the visiblility is set on the Panel. This only took a weekend of frustration as part of a V7-V9 conversion.

I have reported this to Metastorm, but it's not included in the 9.3.2 release.

__________________
Cheers Graham Field
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #11 
We have grids on some of our forms, and one of them has a few (but its not the only form/action to encounter this issue).  That one form shows/hides fields using panels, not the grid itself.  Something to consider for other possible forms though, so thanks for the tip.

OT asked me to provide a SQL dump to try to track down this issue.  I sent them Friday.  I hope to hear from them this week.  The frequency of this issue is a show stopper for upgrading our last and biggest solution to V9.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!