Direct links to fixes
APAR status
Closed as program error.
Error description
The catalog SOA storefront service occasionally returns wrong data for product attributes when there are multiple simultaneous service requests. This issue occurs for Extended Site stores containing multiple languages. This issue randomly occurs with no errors displayed in the logs. The following log shows the symptoms of the problem: [11/15/11 16:30:08:830 GMT] 00000072 taglib > com.ibm.commerce.foundation.internal.client.taglib.ParamTag setValue(String value) ENTRY 3490218 [11/15/11 16:30:08:831 GMT] 00000072 taglib > com.ibm.commerce.foundation.internal.client.taglib.ParamTag setValue(String value) ENTRY -3 [11/15/11 16:30:09:423 GMT] 00000072 queryservice > com.ibm.commerce.foundation.internal.server.services.dataaccess. queryservice.SubstitutionHelper getControlValues ENTRY LANGUAGES {_wcf.dataLanguageIds.0=_wcf.dataLanguageIds=[-1],, UniqueID.1=UniqueID=[3596506],} [11/15/11 16:30:09:427 GMT] 00000072 jdbc 1 com.ibm.commerce.foundation.internal.server.services.dataaccess. graphbuilderservice.jdbc.JDBCMediatorSupplyQuery getGraph(DMSQueryData) SQL query: SELECT ATTRIBUTE.ATTRIBUTE_ID, ATTRIBUTE.LANGUAGE_ID, ATTRIBUTE.ATTRTYPE_ID, ATTRIBUTE.NAME, ATTRIBUTE.SEQUENCE, ATTRIBUTE.DESCRIPTION, ATTRIBUTE.CATENTRY_ID, ATTRIBUTE.DESCRIPTION2, ATTRIBUTE.FIELD1, ATTRIBUTE.OID, ATTRIBUTE.USAGE, ATTRIBUTE.QTYUNIT_ID, ATTRIBUTE.GROUPNAME, ATTRIBUTE.NOTEINFO, ATTRIBUTE.MULTITYPE, ATTRIBUTE.OPTCOUNTER FROM ATTRIBUTE WHERE ATTRIBUTE.ATTRIBUTE_ID IN (?, ?, ?, ?, ?) AND ATTRIBUTE.LANGUAGE_ID IN (?) ORDER BY ATTRIBUTE.SEQUENCE [9032349, 9032506, 11358397, 11358399, 11358632, -1] As per the above trace, the language ID is changed from -3 to -1 due to multi-threading issues. This causes bad data to be returned for requested attributes.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce users on v7.0 who use multi-language stores. PROBLEM ABSTRACT: The catalog SOA storefront service occasionally returns wrong data. BUSINESS IMPACT: High- Unable to checkout orders RECOMMENDATION:
Problem conclusion
The AbstractGraphComposer class was enhanced to support muti-threading. Installing JR41229 will fix this issue. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APANOPUB
APAR Information
APAR number
JR41229
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Pervasive
Submitted date
2011-11-16
Closed date
2011-12-05
Last modified date
2011-12-05
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
WC BUS EDITION
Fixed component ID
5724I3800
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 December 2011