IBM Support

JR56749: Listing products with more than 1000 SKUs on one page causes errors on Oracle

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a search profile is using the
    SolrRESTSearchCatalogEntryViewDescriptionQueryPostprocessor, it
    will check the database for override information for the catalog
     entries that are returned by the search. However, if you are
    using an Oracle database, and have more than 1000 catalog
    entries being returned in a search, then this postprocessor will
     cause the following error:
    
    SolrRESTSearc 1
    com.ibm.commerce.foundation.server.services.rest.search.postproc
    essor.solr.SolrRESTSearchCatalogEntryViewDescriptionQueryPostpro
    cessor  readPhysicalObjects() Failed to fetch ... using query
    IBM_Get_CatentryDescOverride_By_LangId_And_CatentryId_And_GroupI
    d
    ...
    SolrRESTSearc 1
    com.ibm.commerce.foundation.server.services.rest.search.postproc
    essor.solr.SolrRESTSearchCatalogEntryViewDescriptionQueryPostpro
    cessor  readPhysicalObjects() Exception: ORA-01795: maximum
    number of expressions in a list is 1000
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce Version 7 and Version 8.
    
    PROBLEM ABSTRACT:
    Listing products with more than 1000 SKUs on one page causes
    errors on Oracle
    
    BUSINESS IMPACT:
    Shoppers will be unable to view a category page.
    
    RECOMMENDATION:
    

Problem conclusion

  • A single query invocation was separated into multiple
    invocations to avoid the maximum number of expressions
    limitation.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56749

  • 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 / Xsystem

  • Submitted date

    2016-09-29

  • Closed date

    2016-10-21

  • Last modified date

    2016-10-21

  • 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:
11 December 2021