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)


14 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