IBM Support

IT32807: CODELISTCODES REST API RETURNS SQL ERROR WHEN DEFAULT VERSION IS PART OF THE READCODELISTCODES QUERY

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

  • ReadCodeListCodes REST API throws a SQL error "API000002:
    java.sql.SQLSyntaxErrorException: ORA-00936: missing
    expression" when listVersion is set to default version.
    

Local fix

  • STRRTC - B2BISFG-52298
    MRC/MRC
    Circumvention: None
    

Problem summary

  • Users Affected:
    
    All
    
    Problem Description:
    
    
    
           When the ReadCodeListCodes Service is invoked and part of
    the query it includes listVersion=-1 (searching for the default
    version).An SQL error is returned:
    
    
    
    Oracle DB - { "errorCode": 400, "errorDescription": "API000002:
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression"
    }
    
    
    
    SQL Server DB -
    
    { "errorCode": 400, "errorDescription": "API000002:
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect
    syntax near the keyword 'and'." }
    
    
    
          Platforms Affected:
    
           All
    

Problem conclusion

  •   Resolution Summary:
    A code fix is provided.
        A Java class was updated that was creating incorrect SQL
    statement that caused the SQLSyntaxErrorException.
    
    
    
          Delivered in:
    
        6000203
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32807

  • 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

    2020-05-08

  • Closed date

    2020-11-26

  • Last modified date

    2020-12-01

  • 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":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"603"}]

Document Information

Modified date:
02 December 2020