IBM Support

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

Direct link to fix

Subscribe

You can track all active APARs for this component.

 

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 number

    JR40130

  • Reported component name

    WC BUS DEV ED W

  • Reported component ID

    5724I3900

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-18

  • Closed date

    2011-08-31

  • Last modified date

    2011-08-31

  • 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

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
07 December 2021