Saturday, September 24, 2011

Troubleshooting User log-in and organization relationship

CommerceSrvr E AccManager isAllowed CMN1501E: User 6002 does not have the authority to perform action "Display" on resource "com.ibm.commerce.user.beans.UserDataBean" for command "Logon".
 CommerceSrvr A DataBeanManager directActivate(DataBean,CommandContext) The user does not have the authority to run this command "com.ibm.commerce.user.beans.UserRegistrationDataBean".
t have the authority to perform action "Display" on resource "com.ibm.commerce.user.beans.OrganizationDataBean"

Troubleshooting: The above error was caused as there was a missing relationship in MBRREL to the parent organization.

DN should be lowercase and no spaces between orgs.

If you have Manually imported orgentity table through data load, The DN relationship is stored between the ancestor and descendant in MBRREL. If the tree has multiple parents, all the parent-child relationship should be defined in MBRREL.

A member_id from MEMBER table can be a ORGENTITY_ID, USERS_ID,MBRGRP_ID

 Some queries to help for debugging:

select * from mbrrel where descendant_id=;


select * from orgentity where orgentity_id in (
select ancestor_id from mbrrel where descendant_id=);



USERS:

 MBRREL; ( USER to all parent organization relationship as per dn is loaded here)

MBRROLE & ROLE; (Role for each user is assigned to an organization, e.g. -29 for registered customer)

SELECT DN FROM USERS (DN SHOULD BE THE CORRECT ORGENTITY)


33 comments:

  1. Hi Raj, thank you for this post. It was really helpful for me to solve a problem in user registration.
    Is it possible to have your email to talk about some others WebSphere Commerce v7 tips to share in your blog?

    Regards

    ReplyDelete
  2. In fact, it requires the establishment of co-operative objectives, individual tasks and specific results. People make up the heart of the virtual team.guarantor

    ReplyDelete
  3. I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! johnny cassell

    ReplyDelete
  4. Today, I was just browsing along and came upon your blog. Just wanted to say good blog and this article helped me a lot, due to which I have found exactly I was looking. compact tractor attachments

    ReplyDelete
  5. Yes, I am entirely agreed with this article, and I just want say that this article is very helpful and enlightening. I also have some precious piece of concerned info !!!!!!Thanks. taxi bergschenhoek

    ReplyDelete
  6. Every coordinator had a rundown of contributors alloted to them, raising support objectives, and a timetable.IT company North York

    ReplyDelete
  7. I really like your writing style, great information, thankyou for posting. 토토사이트

    ReplyDelete
  8. Hi there! Nice stuff, do keep me posted when you post again something like this! 토토사이트

    ReplyDelete
  9. Nice to be visiting your blog once more, it has been months for me. Well this article that ive been waited for therefore long. i want this article to finish my assignment within the faculty, and it has same topic together with your article. Thanks, nice share. click here

    ReplyDelete
  10. Hi there! Nice post! Please tell us when I will see a follow up! 토토커뮤니티

    ReplyDelete
  11. You have done a great job on this article. It’s very readable and highly intelligent. You have even managed to make it understandable and easy to read. You have some real writing talent. Thank you. 토토사이트

    ReplyDelete
  12. This is the type of information I’ve long been trying to find. Thank you for writing this information. 릴게임

    ReplyDelete
  13. Thank you a bunch for sharing this with all of us you actually realize what you are talking about! Bookmarked. Please also seek advice from my site =). We could have a hyperlink change contract between us! 안전놀이터

    ReplyDelete
  14. Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. 먹튀검증커뮤니티

    ReplyDelete
  15. Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. pii-email

    ReplyDelete
  16. I’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. academic transcription services

    ReplyDelete
  17. I’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. 먹튀검증

    ReplyDelete
  18. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... 88카

    ReplyDelete
  19. Hi there! Nice stuff, do keep me posted when you post again something like this! Divorce in Orange County

    ReplyDelete
  20. Cool stuff you have got and you keep update all of us. joker888

    ReplyDelete
  21. This is actually the kind of information I have been trying to find. Thank you for writing this information. 먹튀검증

    ReplyDelete
  22. Thank you a bunch for sharing this with all of us you actually realize what you are talking about! Bookmarked. Please also seek advice from my site =). We could have a hyperlink change contract between us! anime filler list

    ReplyDelete
  23. Really I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. 토토사이트

    ReplyDelete
  24. Liposuction is possible in almost any area of the body. Many of our patients opt to target more than one area of the body during their liposuction procedure because we offer discounts for multiple target areas. you can try this out

    ReplyDelete
  25. A very excellent blog post. I am thankful for your blog post. I have found a lot of approaches after visiting your post. 대전마사지

    ReplyDelete
  26. Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. 바둑이게임

    ReplyDelete
  27. Pretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon! https://www.abercrombieand-fitch.com.co/

    ReplyDelete
  28. Cool stuff you have got and you keep update all of us. www.digitalanalog.in

    ReplyDelete
  29. You have outdone yourself this time. It is probably the best, most short step by step guide that I have ever seen. 먹튀검증

    ReplyDelete
  30. I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. https://sites.google.com/view/buy-twitch-followers/

    ReplyDelete
  31. 바카라사이트
    Hello I am so delighted I located your blog, This is my website and it has been very helpful. How did you come up with this brilliant idea? This is a very well written article. I will be sure to bookmark it and return to read more of your useful info. Thanks for the post. I’ll certainly comeback. Please visit my website and give your opinion.

    ReplyDelete
  32. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. 토토사이트

    ReplyDelete