APAR status
Closed as program error.
Error description
The problem only occurs under a specific configuration: 1. Use FinalizeDiscountCalculationUsageNoPromoargCmdImpl https://www.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.ibm .commerce.admin.doc/tasks/tprconfigpromoargument.htm 2. Set TrackPublicPromotionCodeUsage to true https://www.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.ibm .commerce.management-center_customization.doc/concepts/cprwcadmi ncom.htm#fntarg_1 3. Have multiple promotions that share the same code. 4. Some of these promotions in 'active' status, others in 'inactive', 'archived' or other status. 5. Apply the promotion code and order process would throw the error: Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ... at com.ibm.commerce.base.objects.ServerJDBCHelperAccessBean.execute ParameterizedQuery(ServerJDBCHelperAccessBean.java:310) at com.ibm.commerce.order.calculation.FinalizeDiscountCalculationUs ageNoPromoargCmdImpl.handlePromotionCodes(FinalizeDiscountCalcul ationUsageNoPromoargCmdImpl.java:458) at com.ibm.commerce.order.calculation.FinalizeDiscountCalculationUs ageNoPromoargCmdImpl.performExecute(FinalizeDiscountCalculationU sageNoPromoargCmdImpl.java:138)
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce Version 8 Mod Pack 4. PROBLEM ABSTRACT: Cannot submit order with a shared public promotion code BUSINESS IMPACT: Shopper cannot use the promotion code. RECOMMENDATION:
Problem conclusion
Enhance the sql to filter out the promotion codes with promotions disabled.
Temporary fix
Comments
APAR Information
APAR number
JR58889
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-12-19
Closed date
2018-05-16
Last modified date
2018-05-16
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
R800 PSY
UP
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer 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