APAR status
Closed as program error.
Error description
While developing a new widget, if the widget contains an optional property and is left empty (for example a text box or drop-down menu), an error is thrown when you try to save the layout. This issue is also reproducible in the widgets that are available from WebSphere Commerce if you are using an Oracle database instead of the Apache Derby development database. If a table column is marked as not null, and you attempt to save the layout, you might see a message that is similar the following exception: "com.ibm.commerce.foundation.internal.server.services.dataaccess .graphbuilderservice.jdbc.JDBCGraphBuilderService saveGraph Original exception: ORA-01400: Cannot insert into NULL ("WCOMM2"."PLWIDGETNVP"."VALUE")." Oracle treats this empty value as NULL, therefore it is not possible to save to the PLWIDGETNVP.VALUE column.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce developers that customize any widgets on the Commerce Composer tool. PROBLEM ABSTRACT: An error occurs during an attempt to save a layout that contains empty widget property values in Commerce Composer BUSINESS IMPACT: WebSphere Commerce developers cannot create custom widgets with optional fields. RECOMMENDATION:
Problem conclusion
Enhanced WebSphere Commerce client service to provide the option of specifying whether to send or omit empty properties as part of the request. Set new parameter "omitEmptyProperties" to true in the CreateService and UpdateService of the LayoutWidgetObjectDefinition file.
Temporary fix
Comments
APAR Information
APAR number
JR55847
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-03
Closed date
2016-05-16
Last modified date
2016-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 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