PM40153: WCM authoring portlet view My Items -> Pending Approval does not show all content items that need to be approved

APAR status

• Closed as program error.

Error description

• WCM authoring portlet view My Items -> Pending Approval does
  not
  show all content items that need to be approved because JCR
  node
  data has lower-case group LDAP DN and XPath query has
  mixed-case
  group LDAP DN.
  
  In WCMSupportTools portlet, we can lookup UUID <xxx> for draft
  content item ibm_test_event.  The approval list shows group
  LDAP
  DN all in lower-case:
  
  ibmcontentwcm:approvalRequired[cn=ibm_approvers,ou=ibm]
  ibmcontentwcm:name[ibm_test_event]
  jcr:nodeType[ibmcontentwcm:draftSummary]
  
  However, the WCM authoring portlet generates a XPath query with
  the group LDAP DN in mixed-case (cn=ibm_approvers,OU=IBM).
  
  Since the XPath queries that pull the content are using the
  full
  LDAP DN of the user/group, and the underlying database queries
  are case-sensitive, in some cases if the DN is stored in a
  different case than we are using to retrieve, not all of the
  items will show.
  
  WCMConfigService.properties shows user.cache.enable = false.
  
  WAS security.xml shows ignoreCase="true".
  
  This problem probably affects other WCM authoring portlet views
  also.
  

Local fix

Problem summary

• WCM authoring portlet view My Items -> Pending Approval does
  not
  show all content items that need to be approved because JCR
  node
  data has lower-case group LDAP DN and XPath query has
  mixed-case
  group LDAP DN.
  
  In WCMSupportTools portlet, we can lookup UUID <xxx> for draft
  content item ibm_test_event.  The approval list shows group
  LDAP
  DN all in lower-case:
  
  ibmcontentwcm:approvalRequired[cn=ibm_approvers,ou=ibm]
  ibmcontentwcm:name[ibm_test_event]
  jcr:nodeType[ibmcontentwcm:draftSummary]
  
  However, the WCM authoring portlet generates a XPath query with
  the group LDAP DN in mixed-case (cn=ibm_approvers,OU=IBM).
  
  Since the XPath queries that pull the content are using the
  full
  LDAP DN of the user/group, and the underlying database queries
  are case-sensitive, in some cases if the DN is stored in a
  different case than we are using to retrieve, not all of the
  items will show.
  
  WCMConfigService.properties shows user.cache.enable = false.
  
  WAS security.xml shows ignoreCase="true".
  
  This problem probably affects other WCM authoring portlet views
  also.
  

Problem conclusion

• memberfixer updated, and WCM flag added to use lower case.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  LOTUS WEB CONT

• Fixed component ID

  5724I2900

Applicable component levels

• R615 PSY

     UP