Direct links to fixes
APAR status
Closed as program error.
Error description
When attempting to save a language selection as part of an attachment, an error is displayed "DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001" (or Oracle equivalent), even though the URL that is used is within the database-specified character limit.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce Version 7 and Version 8 administrators who use the Assets tool in Management Center. PROBLEM ABSTRACT: Database error in the Management Center Assets tool when attempting to save a URL attachment BUSINESS IMPACT: Business users using the Assets tool in Management Center will not be able to save a URL attachment with a URL length near the 255 character limit. RECOMMENDATION:
Problem conclusion
Validation being performed for attachment assets, specifically managed files, was suppressed to not be performed on URL attachment assets.
Temporary fix
Comments
APAR Information
APAR number
JR56005
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-26
Closed date
2016-06-24
Last modified date
2016-06-24
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
12 December 2021