Answered by:
MDS 2016 CU4: Web Interface - unable to access to users and groups security parameters

Question
-
Answers
-
I can confirm, that it does not work.
By doing it this way you get to the first screen with the General tab active. When you try to shift tab to Membership, Functions or Members, then you have the time out issue again.
As somebody described earlier there is a workaround that will give you the ability to see the tabs you want and to make changes.
Go to the front page and refresh cached information, then go to the security groups page, and instead of the pencil icon use the direct way on the specific group you want to edit and go directly to the tab you want to have access to.If you want to see another tab, then again, back to front page, refresh cache, back to group page, direct way to tab.
Bo
- Edited by bolaugo Friday, September 8, 2017 6:12 AM
- Proposed as answer by Julia Hunt Friday, November 3, 2017 2:02 PM
- Marked as answer by Times DecidesEditor Monday, March 26, 2018 8:02 PM
All replies
-
-
-
-
I managed to figure a way to get past this problem. Model permission management works for the first time, but not with another try. The problem seems to be with cached information. It will work if you go to main page and reset cached information before another attempt. Seems obvious bug, please fix it in the next CU.
-
@Smartysanthosh applied the stored proc but same behaviour :
the Log file has several entries like :
..
08/24/2017 19:30:35,00000000-0000-0000-0000-000000000000,Unknown,Verbose,"Unable to convert value of query string parameter Id = VID to an integer"
..
..
08/24/2017 19:30:41,0adc573d-6580-4722-a120-cc79f593603c,/MDS/security/Groups/SecurityGroupsList.aspx,Verbose,"Unable to convert value of query string parameter Id = MID to an integer"
..maybe this helps. I can send a complete log file with verbose logging if you provide me an email address. Or I can open a ticket at connect.microsoft.com and attach the log file ?
Christoph
-
Hi @Christoph,
hope you updated the stored procedure, please send the log to this email id sqlmdsfeedback@microsoft.com
I will look into this issue .
thanks,
sunny
-
Hi sunny,
yes, i have updated the stored procedure you had previously put on OneDrive. The link above has no attachment..
I have mailed the log file.
Christoph
- Edited by Christoph Bohne Wednesday, September 6, 2017 4:39 PM
-
-
-
I had a call with Couple of them last night and understood that you guys facing problem in group security page , the fix I gave was for User security page and they confirmed my SP workaround fix is working for them.
Ok now lets come back to group security page , I started look into this problem and observed there is a problem happening in the underlying threads ( and its getting struck there and eventually going for a timeout ) I am debugging more to understand root cause , mean while can someone quickly check this and let me know , whether this works or not so that I can assume you guys are not blocked ?
I am sure most of them when they demo to me are using this control on the group page to navigate to the model page ,
rather than doing this way , we also provided a button on the top as shown below screenshot , just click on the group you would like to edit permissions and then this control will turn from grey to visible and by clicking it will take you to the edit page where you can navigate to the model page and do your add/update of permissions ( again you need my modified sp to be applied first , assuming you already did that ) . it should work , let me know if it is still not working .
note: this is temporary workaround only , I will work for a permanent fix
-sunny
- Edited by SmartysanthoshMicrosoft employee, Moderator Friday, September 8, 2017 2:28 AM image missing
-
I can confirm, that it does not work.
By doing it this way you get to the first screen with the General tab active. When you try to shift tab to Membership, Functions or Members, then you have the time out issue again.
As somebody described earlier there is a workaround that will give you the ability to see the tabs you want and to make changes.
Go to the front page and refresh cached information, then go to the security groups page, and instead of the pencil icon use the direct way on the specific group you want to edit and go directly to the tab you want to have access to.If you want to see another tab, then again, back to front page, refresh cache, back to group page, direct way to tab.
Bo
- Edited by bolaugo Friday, September 8, 2017 6:12 AM
- Proposed as answer by Julia Hunt Friday, November 3, 2017 2:02 PM
- Marked as answer by Times DecidesEditor Monday, March 26, 2018 8:02 PM
-
ok thanks Bolaugo, understood the workaround . I think I got to the root cause and see whether I can use 2016 SP2 CTP release to catch this so that It can be out before 2016 SP2 RTM release . lets see what can I do best to roll this fix at the earliest .
-
-
-
-
-
-
I've found the root cause of the issue with group security pages ( https://social.technet.microsoft.com/Forums/windows/en-US/5473f312-055a-41c0-bec7-4861365454e4/mds-sql-2016-cant-edit-permissions-for-selected-group-in-manage-groups ), as a workaround I kill MDS worker process, it works for a development environment, hopefully, the bug will be fixed before our go live.
MDS web app has some potential for race condition issues because of the way it handles some parts of page state - static dictionary which is shared across all sessions, so it possible that user1 opens a page to edit group1, another user2 opens a page to edit group2 at the same time and both user1 and user2 will see page rendered with the same data e.g. group2
Is there a good place to submit issues/suggestions for MDS? MS Connect for SQL Server? I'm finding some thing that might be worth sharing, like [mdm].[udpEntityMembersUpdate] doesn't do a good job using indexes when updates members, a simple refactoring saves 2.5-3 seconds on 7500 attributes update batch on L16 VM. -
-
-