Bug with multiple use of one subprocess and cloning folders, V9

I know this is not easy to explain, but perhaps a MBPM Developer understands what our problem is ;-)

Scenario:

We have designed a small subprocess that is used like a "v7 map segment" within multiple other processes. The subprocess also contains an action which "clones" the folder.

We figured out that the cloning (copying) of the folder only works for one of the parent processes, all other throw an expception within the systems stored procedure "esp_update_action". This error is caused because of wrong entries inside the eSubprocess table.(see Screenshot)

We embedded the subprocess in more than one process but the eSubprocess table only references to one of these processes.

Solution/Workaround

The stored procdure [psp_clone_all_processes] queries the eSubprocess table by eSubProcessName and eVersion number. It seems that the subprocess version number has to be equal with the version of the parent process, which is not the case. eSubProcessName is the primary key here, therefore also querieng for eversion makes no sense!

As a workaorund we modified the query and removed the eVersion parameter.

Find more posts tagged with

BPM

Comments

Jerome_Pearce

I must admit, ever since map segments came in, I have never tried to clone a Folder in a map sgement / sub-process! Just goes to prove there is always something more to find out ....

Jerome_Pearce

I've just tried it and it works OK for me in 9.0.2

[edit] Sorry, read in more detail and it must be in a different solution file for the version numbers to be different. Back to the drawing board.....

Bjoern Nettingsmeier

We are also running the latest Service Release 9.2 and use the subprocess to define templates for the main processes.

For example:

The main process controls user authentication/permission requests on an ERP system. The ERP System Owner can define a permission template within the subprocess. When a new user needs access to this system he simply chooses one of the provided templates, clones the folder and the process continues within the main process.

Other main processes handle requests to Citrix, Fileshares and other applications and also use the "Template" subprocess.

As mentioned above the query causing this error is located inside the psp_clone_all_processes procedure. (Attached a screenshot) It uses two parameters eVersion and eSubProcessName, where eSubProcessName is the PK so there is no need to use eVersion there. eVersion seems to contain the version number of the main process which leads to an empty result.

Bjoern Nettingsmeier

Modified your example a little bit.

As you allready said, it is necessary that the both main processes do not have the same version number.

After deployment simply create an instance of both processes, go to todo list and try to clone both instances by user action. For one of the processes it should work, the other should lead to an error.

Thx

Jerome_Pearce

I did another modification, and I get the same result as you did.

Good call, and excellent analysis if I may say so!