JR40130: CMVC 211884 - CORRECT THE ORDER RECORDS ARE PERSISTED WHEN USING THE CATALOGENTRY SERVICE TO UPDATE THE ATTRIBUTE DICTIONARY.

7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• When utilizing the CatalogEntry component service to update the
  Attribute Dictionary with multiple attributes, an exception
  occurs when the JDBCGraphBuilderService attempts to persist the
  records.
  The error is particularly seen when adding more than one
  attribute in the request where one of the attributes is a free
  form descriptive assigned value attribute.
  The following is an example of such a service request followed
  by the resulting error:
  
  
  <?xml version="1.0" encoding="UTF-8"?>
  <_cat:ChangeCatalogEntry
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:_cat="http://www.ibm.com/xmlns/prod/commerce/9/catalog"
  xmlns:_wcf="http://www.ibm.com/xmlns/prod/commerce/9/foundation"
  xmlns:oa="http://www.openapplications.org/oagis/9">
        <oa:ApplicationArea xsi:type="_wcf:ApplicationAreaType">
              <oa:CreationDateTime>2011-06-08Z</oa:CreationDateTim
  e>
              <oa:BODID>d2f5d630-91cb-11e0-8be6-81ea4dee35f1</oa:B
  ODID>
              <_wcf:BusinessContext>
                    <_wcf:ContextData
  name="storeId">10001</_wcf:ContextData>
                    <_wcf:ContextData
  name="catalogId">10001</_wcf:ContextData>
              </_wcf:BusinessContext>
        </oa:ApplicationArea>
        <_cat:DataArea>
              <oa:Change>
                    <oa:ActionCriteria>
                          <oa:ActionExpression actionCode="Add"
  expressionLanguage="_wcf:XPath">/CatalogEntry[1]/CatalogEntryAtt
  ributes/Attributes[1]</oa:ActionExpression>
                          <oa:ActionExpression actionCode="Add"
  expressionLanguage="_wcf:XPath">/CatalogEntry[1]/CatalogEntryAtt
  ributes/Attributes[2]</oa:ActionExpression>
                    </oa:ActionCriteria>
              </oa:Change>
              <_cat:CatalogEntry
  catalogEntryTypeCode="ProductBean">
                    <_cat:CatalogEntryIdentifier>
                          <_wcf:ExternalIdentifier
  ownerID="7000000000000000551">
                                <_wcf:PartNumber>13717</_wcf:PartN
  umber>
                          </_wcf:ExternalIdentifier>
                    </_cat:CatalogEntryIdentifier>
                    <_cat:CatalogEntryAttributes>
  
                          <_cat:Attributes displaySequence="0.0"
  usage="Descriptive">
                                <_cat:AttributeIdentifier>
                                      <_wcf:UniqueID>7000000000000
  000717</_wcf:UniqueID>
                                </_cat:AttributeIdentifier>
                                <_cat:Value
  identifier="7000000000000002974"></_cat:Value>
                          </_cat:Attributes>
  
                          <_cat:Attributes displaySequence="0.0"
  usage="Descriptive">
                                <_cat:AttributeIdentifier>
                                      <_wcf:UniqueID>7000000000000
  000722</_wcf:UniqueID>
                                </_cat:AttributeIdentifier>
                                <_cat:AttributeDataType>String</_c
  at:AttributeDataType>
                                <_cat:StringValue>
                                      <_cat:Value>Machined
  Parts</_cat:Value>
                                </_cat:StringValue>
                          </_cat:Attributes>
  
                    </_cat:CatalogEntryAttributes>
              </_cat:CatalogEntry>
        </_cat:DataArea>
  </_cat:ChangeCatalogEntry>
  ...
  ...
  [7/12/11 9:04:30:521 EDT] 00000047 jdbc          I
  com.ibm.commerce.foundation.internal.server.services.dataaccess.
  graphbuilderservice.jdbc.JDBCGraphBuilderService saveGraph
  Original exception: DB2 SQL Error: SQLCODE=-530, SQLSTATE=23503,
  SQLERRMC=DB2ADMIN.CATENTRYATTR.F_3568, DRIVER=4.3.111
  

Local fix

• Alternatively, Management Center may be used to update the
  Attribute Dictionary.
  

Problem summary

• USERS AFFECTED:
  All WebSphere Commerce users on v7.0 with Feature Pack 2 or
  higher leveraging the Attribute Dictionary feature.
  
  PROBLEM ABSTRACT:
  CatalogEntry service request results in SQLSTATE=23503 when
  updating the Attribute Dictionary.
  
  BUSINESS IMPACT:
  Moderate; the above error may hinder development of custom web
  services.
  
  RECOMMENDATION:
  

Problem conclusion

• This fix updates the ChangeCatalogEntryAttributeMediator to
  properly link catalog entries which contain any newly added
  attribute values.
  
  -------------------------------------------------------------
  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

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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP