Direct links to fixes
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