IBM Support

JR57670: Store locator REST call throws exception during BigDecimal conversion

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When store locator REST call is invoked, the following exception
    is thrown:
    
    Exception: com.ibm.db2.jcc.am.SqlDataException:
    [jcc][t4][1037][11190][4.19.49] Exception occurred during
    BigDecimal conversion.  See attached Throwable for details.
    ERRORCODE=-4220, SQLSTATE=22003
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce Version 8.
    
    PROBLEM ABSTRACT:
    Store locator REST call throws exception during BigDecimal
    conversion
    
    BUSINESS IMPACT:
    Store locator is not usable.
    
    RECOMMENDATION:
    

Problem conclusion

  • Updated the SQL statement to support decimal with 5 digit
    fractions.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR57670

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-29

  • Closed date

    2018-05-10

  • Last modified date

    2018-05-10

  • 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

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
11 December 2021