IBM Support

IT36042: CANNOT ADD ENTRY TO CODE LIST

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When trying to import a code list customer gets the following
    error:
    The object [SenderItem: OCEAN_40 ReceiverItem: 38
    Description: OCEAN_40 Text1: Text2: Text3: Text4: ]
    will be
    overwritten by the object [SenderItem: OCEAN_403 ReceiverItem:
    8 Description: OCEAN_403 Text1: Text2:Text3: Text4: ]
    
    Note
    that both codes entries are unique and therefore should not be
    overwritten.
    
    The issue can also be seen if using the dashboard
    UI to create a new code list, enter one of the codes
    combination, OCEAN_40 and 38,
    which works fine but when trying
    to enter the second one, OCEAN_403 and 8, we get the
    error:
    "One of the new code already exists in the list. Please
    try again with a unique Sender Code and a unique Receiver
    Code."
    Strange thing is that if I enter the sender/receiver
    code combination OCEAN_406/8 instead of OCEAN_403/8, it works
    fine and the same happens for
    combination OCEAN_403/9, it also
    works fine, it seems to be only the specific combination
    OCEAN_403/8 that causes the issue
    
    The issue doesn't seem to be
    database related since I could reproduce it on MSSQL, DB2 and
    Oracle database systems.
    Also could reproduce the issue on
    5.2.6.x, 6.0.2.2 and 6.0.3.2 and customer has the issue on
    6.0.1.0
    

Local fix

  • STRRTC- B2BISFG-56435
    OAQ / OAQ
    Circumvention: a key will be
    used in form of SenderItem+ReceiverItem, the concatenation of
    both strings has to be unique.
    

Problem summary

  • Problem Description:
    
    
    
    When trying to import a code list, customer gets the following
    error:
    
    The object [SenderItem: OCEAN_40 ReceiverItem: 38 Description:
    OCEAN_40 Text1: Text2: Text3: Text4: ]
    
    will be overwritten by the object [SenderItem: OCEAN_403
    ReceiverItem: 8 Description: OCEAN_403 Text1: Text2:Text3:
    Text4: ]
    
    
    
    
    Users Affected:
    
    All customers of B2BI using standards
    
    
    Platforms Affected:
    
    All Platforms
    

Problem conclusion

  •  Resolution Summary:
    
    
    
    A code fix is provided
    
    A hash map key is created in the form of SenderItem+ReceiverItem
    before inserting the code list entry to the database. To
    guarantee the uniqueness of the key, the form should be
    SenderItem+"_"+ReceiverItem
    
    
    
    Delivered in:
    
    6000305
    
    
    
    All future Fix Packs can be found in the Release Timeline
    Matrix.
    
    https://www.ibm.com/support/pages/node/6194265.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT36042

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    603

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-02-25

  • Closed date

    2021-10-05

  • Last modified date

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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"603"}]

Document Information

Modified date:
06 October 2021