A fix is available
APAR status
Closed as program error.
Error description
Pre-condition: 1. WebSphere Commerce is using an Oracle database. 2. The shopper who is browsing the storefront belongs to more than 1000 member groups (segments). Symptoms of the problem: 1. When the customer hovers over the product image to show the quick info, the quick info is not shown properly. 2. The WebSphere Commerce log prints Oracle error code: ORA-01795.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce v7 customers who use Oracle as their database, and have shoppers who belong to more than 1000 member groups. PROBLEM ABSTRACT: The product quick info dialog is not showing properly when WebSphere Commerce is using an Oracle database and the shopper belongs to more than 1000 member groups. BUSINESS IMPACT: The shopper who belongs to more than 1000 member groups will not be able to view the product quick info properly. RECOMMENDATION:
Problem conclusion
Oracle has a limitation that the maximum number of expressions in a list is 1000, so when there are more than 1000 expressions, the "ORA-01795" exception will be thrown. This fix will change the code logic to split those expressions with an 'OR' condition when there are more than 1000 member groups. ------------------------------------------------------------- The latest available maintenance information can be obtained from the Recommended Fixes for WebSphere Commerce technote: http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
Temporary fix
Comments
APAR Information
APAR number
JR42311
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-21
Closed date
2012-06-28
Last modified date
2012-06-28
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
R700 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 June 2012