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 number
PM40153
Reported component name
LOTUS WEB CONT
Reported component ID
5724I2900
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-05-26
Closed date
2011-06-10
Last modified date
2011-06-10
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
[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Web Content Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB33","label":"N\/A"}}]
Document Information
Modified date:
21 December 2021