APAR status
Closed as program error.
Error description
Fail to update Layout using Composer tool in DB2 environment. Widgets cannot be added to the layout using composer tool. Listing of widgets will result in SQL Exception on DB2 environment. This issue is specific to DB2, and it works well in Oracle environment. When includeInActiveWidgets parameter value is passed as "false", one of the queries which uses CAST function to convert to CHAR(4) was failing with insufficient length error, though it works well in Oracle.
Local fix
Problem summary
USERS AFFECTED: Customers who have installed JR 51844 on DB2 environment will not be able to create new layouts or modify existing layouts. PROBLEM ABSTRACT: Fail to update Layout using Composer tool in DB2 environment. BUSINESS IMPACT: Business users will not be able to create new layouts or modify existing layouts. RECOMMENDATION:
Problem conclusion
To fix the issue, the CAST function will now convert includeInActiveWidgets parameter value to CHAR(5). The APAR updates the query in wc-query-WidgetDefinition-get.tpl related to following XPath: name=/WidgetDefinition[@includeInactiveWidgets= and WidgetType=] Specifically a clause in WHERE condition is updated FROM: (CAST((?includeInactiveWidgets.1?) as CHAR(4)) = 'true') TO: (CAST((?includeInactiveWidgets.1?) as CHAR(5)) = 'true')
Temporary fix
Comments
APAR Information
APAR number
JR52643
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2015-02-23
Closed date
2015-04-20
Last modified date
2015-04-20
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:
11 December 2021