Collecting MustGather data for registration and login issues

Prepare the following MustGather information before you call IBM Support to help with registration and login issues.

Procedure

1. Configure the following trace string in the Transaction server Docker container.

   com.ibm.websphere.commerce.WC_SERVER=all: com.ibm.websphere.commerce.WC_USER=all: com.ibm.websphere.commerce.WC_ACCESSCONTROL=all

   For information about how to set trace strings, see Configure logging for the Transaction Server.

2. Reproduce the problem.

   Record the specific steps that we used to reproduce the problem and any details that might be relevant.

3. Collect the following files from the Transaction server Docker container.

   • /opt/WebSphere/AppServer/profiles/default/installedApps/localhost/ts.ear/xml/member/MemberRegistrationAttributes.xml

   • /opt/WebSphere/AppServer/profiles/default/logs/server1/trace*.log

   • /opt/WebSphere/AppServer/profiles/default/logs/server1/SystemOut*.log

4. Run the following database queries to collect the necessary information from the database (output results in CSV format).

   SELECT * FROM SITE 	
   select * from STORE 	
   select * from STOREENT 	
   select * from USERS where USERS_ID = {user who logged in} 	
   select * from USERREG where USERS_ID = {user who logged in} 	
   select * from MEMBER where MEMBER_ID = {user who logged in} 	
   select * from MBRROLE where MEMBER_ID = {user who logged in} 
   select * from ORGENTITY 
   select * fom MBRREL where DESCENDANT_ID in (select ORGENTITY_ID as DESCENDANT_ID from ORGENTITY) 
   select * fom MBRREL where DESCENDANT_ID = {user who logged in}