Return a List of user names from a script method for a dynamic role formula

I have a server script method which returns a Metastorm.Runtime.Types.List of Metastorm user names, and I'm calling that function in a role formula. This is happening inside a library, and that library is being used in another process. The role from the library is being used for the to-do list at the first stage of the process.

I cannot get the folders I create to appear on anyone's to-do list, i.e. there are no records in the eAlert table. I know the method in the library is being called -- I've tested this by writing the contents of the list to a text file on the server.

Any help would be appreciated.

-Rory

Find more posts tagged with

BPM

Comments

Aaron Van

I have found that while usernames are not case sensitive in the web front-end they are in role definitions.

We return all of our usernames.ToLower() from our service before it reaches our server side scripts. The usernames will also have to be lower case in Metastorm's user table.

I've read about tweaks to turn off case sensitive usernames, but I believe this only applies to authenticating with the ECL and not for dynamic role matching. It was a hard bug to find, but give that a shot and see if it fixes your problem.

achopra

I was just about to suggest the same thing. I hit that one during a week-long customer POC and it set me back by a day or so...apparently its a C# related issue and difficult to remedy...

Apperson_Rory

Thanks, yeah, I've come across the lower-case thing before, and now I make sure all usernames are stored in the db as lowercase, so that shouldn't be the issue here. Something screwy is definitely going on; I added "Originator" to the first stage, and they're still not showing up on anyone's list, even the originator. I just noticed there are errors in the event log each time this happens:

Database exception while trying to raise alerts. Operation: ExecuteSQL. Code: State:S1T00,Native:0,Origin:[Microsoft][ODBC SQL Server Driver]
. Description: Query timeout expired

Aaron Van

Are you doing any on action completed or stage started that queries the Metastorm db tables? We've run into issues with the eFolder table being deadlocked and dropping TimeOut exceptions as well.

Apperson_Rory

I am doing a stage started action; all it does is run a code activity, a call to a script method. I know that script method is succeeding, because that method performs some business logic and inserts a record into an external database. I can observe the records it's creating, so I know that's succeeding. Nothing happens after the insert.

achopra

can you check your engine settings and make sure that "alert generation" is turned on? also restart your engine if you haven't done that already (i'm sure you have though...)

Apperson_Rory

Yes, alert generation is turned on. I checked that earlier today, but also, this very process was working yesterday before I involved my library. I've since removed the reference to the library and made it so that the only to-do list role on that stage is Originator; still not working. I sense that something is corrupted.

achopra

hmm. i suppose the next test would be to create a brand new project and see if that works?

Michael_Turek

Wow this sounds like an issue that I had just fixed (along with Metastorm support).

Check your ealertgeneratorlock table. There shouldn't be anything in it (data does get pop'd but the engine removes the records quickly). If there is something in it, use the efolderid to check the record out in ealertrequest. In ealertrequest there are two fields eToDoList and eWatchList.

Those fields should hold your list of users and should be tab delimited. If there are half comma / half delimited in just one record within that entire table - all alerts will never get generated!

So - if the fields look to have an issue - do any update on the field to fix the issue (in my case a replace comma with tab). Then delete the record from the generatorlock table and wait to see if it processed. Restarting the service will speed up having to wait and to see immediate results.

Hope this helped.

Apperson_Rory

Wow! That was so ridiculously helpful. Thank you very much. Amazingly esoteric, as well.

Apperson_Rory

Also, thanks to everyone else who contributed their knowledge as well.