Closed as program error.
In these scenarios when the customer has added customization to read and write to SEOPAGEDEFDESC from CMC (WebSphere Commerce Management Center), here's what happens: When reading the fields: 1) These fields have been directly updated in the database: field2, field3 with some string values. 2) An attempt is made to view the fields in CMC. field2 can be read successfully but not field3. There are no errors in the SystemOut.log. When saving these fields in CMC: 1) After saving field2 and field3 in CMC, nothing happens. With foundation tracing enabled, the following lines are seen (with an Oracle database) in the trace.log: [9/1/14 15:03:24:078 CDT] 00000045 JDBCGraphBuil I com.ibm.commerce.foundation.internal.server.services.dataaccess. graphbuilderservice.jdbc.JDBCGraphBuilderService saveGraph Original exception: ORA-00001: unique constraint (WCADMIN.I0001409) violated . . [9/1/14 15:03:24:080 CDT] 00000045 SystemErr R com.ibm.commerce.foundation.internal.common.exception.Foundation SystemException: An exception was caught while saving the data graph using the data mediator. . . [9/1/14 15:03:24:141 CDT] 00000045 TransactionLo 1 TransactionManager rolls back with prior status 0 (active)
Directly update SEOPAGEDEFDESC table.
USERS AFFECTED: WebSphere Commerce users that are trying to customize category object SEO properties in Management Center to update or read from SEOPAGEDEFDESC custom fields. PROBLEM ABSTRACT: Cannot successfully read or write to/from a category's SEO properties custom field in Management Center. BUSINESS IMPACT: Business users need to ask database administrators to update SEOPAGEDEFDESC directly or perform a dataload. RECOMMENDATION:
Modified the create and update SEOPAGEDEFDESC methods in InsertMoreCatalogGroupSEODataCmdImpl and SEOServiceHelper class files to fix some typos in the methods.
Reported component name
WC BUS EDITION
Reported component ID
YesSpecatt / Pervasive
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WC BUS EDITION
Fixed component ID
Applicable component levels
08 December 2014