BPM Shortcuts - Suspend Process

Geoff Osbaldestin

I have downloaded the Suspend Process from the list of BPM shortcuts on the here:

http://www.metastorm.com/customers/csecure/bpm_shrt.asp

 

I have published the suspend process, after fixing it for working with Oracle, it updates the records as per the procedure, but it seems to make no difference when starting new folders on a procedure that has been "Suspended".

 

Can anyone explain what is supposed to be happening in this process?

 

 

Tested on version BPM 7.5.1.1305

Jerome_Pearce

It is supposed to set the eUserAccess of the start actions. One or two issues with it may make it not work:

 

1. It uses '' instead of NULL and Oracle may behave differently to SQL Server. Try adding the statement:

%ExecSQL("UPDATE eAction SET eUserAccess = 'Suspended'  WHERE eMapName='%SuspendMap'  and eStageName IS NULL)

 

2. It does nothing to the eStart table. I suspect you need to update that too in version 6.? (6.5?) and 7.x

 

Obviously not used extensively!

Jerome_Pearce

Oh, and the way the SQL uses the date variable without formatting makes it clear the author did not understand either SQL or Metastorm BPM, I'm afraid. The only safe way in version before 9 is to use the ODBC timestamp format.

Jerome_Pearce

Oh, and "And eAction.eMapName Like '%ReleaseMap'" just re-enforces that impression!

 

Use entirely at your own risk....

Geoff Osbaldestin

Hmmm, so the conclusion is - it does not work......

Jerome_Pearce

Well, I'm not sure it does not work. What I can say is it probably will not work outside the US, given the date formatting, and the SQL is less than optimal. I am not sure if it should do something with the eStart table, however.

 

I'll try to test it when I get onto our v7 environment.

Jerome_Pearce

Just tried it on 7.6 and it seems to work. It is after the 12th of the month, so SQL Server does not get the dates confused, however.

 

What changes did you make to get it working with Oracle?