JR41229: CMVC 216096 - RESOLVE MULTI-THREADING ISSUE CAUSED BY ABSTRACTGRAPHCOMPOSER.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

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 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