Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
ssmelche

New Member
Registered:
Posts: 2
Reply with quote  #1 
I have a user that has Metastorm folders that correctly route to their To Do List as part of the workflow.

When the user goes to open the folder, the actions that are assigned to the To Do List role are not available. The stages that this occurs in are assigned to a custom role.

This issue only happens with this one user, other users do not have this issue.

I have noticed two workarounds.

1. Remove and Re-add the folder to the user's To Do List using Metastorm Services Manager.

2. Modify the Metastorm process workflow to also assign the actions to the same custom role that the stage is assigned to.

Before I modify the Metastorm process workflow, I'd like to find out why this issue is only occurring with one user and not the others.

0
KarlD

Avatar / Picture

Guru
Registered:
Posts: 113
Reply with quote  #2 
I have seen this where single sign on is used and the user name is different between Metastorm and Windows. When the user logs in the eGuest account is activated instead of the actual user account and no items are displayed.

If SSO is being used check that the sign in name is the same as the Metastorm user account name.

0
ssmelche

New Member
Registered:
Posts: 2
Reply with quote  #3 
We aren't using SSO. I should also note that this issue only occurs in the production system, and not the test system.

I ran some queries against the eAssignment table in both production and test, and found a difference.

If I search for entries in production database eAssignment where the eUserName is like the user's username, then I only get one row.

select * from [production db].eAssignment

where eusername like '<user's username>';

--eRoleName eUserName   eFolderID   eUpdatedTime

--Lawyer    <User's username>       NULL


If I search for entries in production database eAssignment where the eUserName is equal to the user's username, then I get all three rows.

select * from [production db].eAssignment

where eusername = '<user's username>';

--eRoleName eUserName   eFolderID   eUpdatedTime

--everybody <User's username>       NULL

--Lawyer    <User's username>       NULL

--<User's username>      <User's username>       NULL


If I search for entries in test database eAssignment where the eUserName is like the user's username, then I get all three rows.

select * from [test db].eAssignment

where eusername like '<user's username>';

--eRoleName eUserName   eFolderID   eUpdatedTime

--everybody <User's username>       NULL

--Lawyer    <User's username>       NULL

--<User's username>      <User's username>       NULL


If I search for entries in test database eAssignment where the eUserName is equal to the user's username, then I get all three rows.

select * from [test db].eAssignment

where eusername = '<user's username>';

--eRoleName eUserName   eFolderID   eUpdatedTime

--everybody <User's username>       NULL

--Lawyer    <User's username>       NULL

--<User's username>      <User's username>       NULL

 

I don't know if this is related to the issue that the user is experiencing in production, but perhaps Metastorm isn't able to resolve all of the assigned roles for the user?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
Either
1. you are using a case-sensitive database (Oracle by Default and SQL Server as an option) or
2. somebody has been updating the database directly (ie not using proper tools).

I think option 2 is the most likely. Somebody added a user and did not add the required eAssignment records because they did not understand how the system works (this is why you don't do this).

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

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #5 
Hang on.

I just re-read the your last post. I am certain this is not possible.

Select * from <table> where <field> like '<value>'

should give the exact same result as

Select * from <table> where <field> = '<value>'

as long as <value> does not contain underscores or % symbols. It may not be the case if there is a "/" (forward slash), but I am not certain of that, and is database dependent IIRC.

If you really are getting these results, I would like to see the returned data to validate it, because I cannot see how it would be possible.

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

Avatar / Picture

Guru
Registered:
Posts: 113
Reply with quote  #6 
This would result in a different outcome only if there were trailing spaces in the data stored within the table.

Try this:
1. Find the record in the database table with the value you require in the eUserName field.
2. Copy the data in the eUsername Field.
3. Build the two queries.
4. Paste the copied value into the correct location in the two queries.
5. Run the Queries.

The results should now be the same. You will see in the pasted information if the values have any trailing spaces.
0
praxkan

Veteran
Registered:
Posts: 142
Reply with quote  #7 
We saw a similar issue for some users when we upgraded versions (cant remember which one). Basically it had something to do with the case sensitive usernames. The SSO script was passing in user name with the domain as uppercase, but the eUser table had domain as lowercase. 

For that particular user, have them open up a form that just displays ProcessContext.UserName, and see if there's something strange going on with the username.

PS - one of the other possibilities is if the user's name has an apostrophe in it . If you're building the query with a straight string without params, that might break
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!