Direct links to fixes
APAR status
Closed as program error.
Error description
A common pattern is to include an e-Marketing Spot on the category display page where the name of the e-Marketing Spot is the category identifier. When the category identifier is greater than 64 characters, then an exception similar to the following appears in the log: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.113 This occurs because the maximum length of an e-Marketing Spot name is 64 characters, but the maximum length of a category identifier is 254 characters.
Local fix
Increase the length of the EMSPOT.NAME database column.
Problem summary
USERS AFFECTED: WebSphere Commerce users on v7.0 using Management Center Marketing. PROBLEM ABSTRACT: An exception is thrown when including an e-Marketing Spot on a store page with a name greater than 64 characters. BUSINESS IMPACT: Category page cannot include an e-Marketing Spot that is based on the category identifier. RECOMMENDATION:
Problem conclusion
This fix updates the sever side validation to allow an e-Marketing Spot name up to a length of 256 characters. This fix includes instructions on how to increase the length of the EMSPOT.NAME database column to 256 characters. There are also manual steps required to update Management Center to allow entering an e-Marketing Spot name up to a length of 256 characters. ------------------------------------------------------------- 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
JR47791
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
2013-09-13
Closed date
2013-11-01
Last modified date
2013-11-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
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:
01 November 2013