Direct link to fix
APAR status
Closed as program error.
Error description
When the search engine optimization (SEO) feature is enabled with a store catalog, the SEOURL and SEOURLKEYWORD tables will be populated with the token for every SEO friendly URL. When deleting catalog entries or catalog groups in WebSphere Commerce Management Center, the SEO URL keyword status field in the SEOURLKEYWORD table is not being updated correctly due to a datatype conversion issue, and the Oracle database throws an exception while trying to convert the status field into a number. The exception call stack is similar to below: Current exception: Message: null Stack trace: com.ibm.websphere.command.CommandException at com.ibm.commerce.foundation.server.command.bod.BusinessObjectCom mandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.ja va:137) .......................................... at com.ibm.commerce.catalog.facade.server.commands.ProcessCatalogGr oupDeleteActionCmdImpl.save(ProcessCatalogGroupDeleteActionCmdIm pl.java:319) at com.ibm.commerce.catalog.facade.server.commands.ProcessCatalogGr oupDeleteActionCmdImpl.performExecute(ProcessCatalogGroupDeleteA ctionCmdImpl.java:103) at com.ibm.commerce.foundation.internal.server.command.impl.Command Target.executeCommand(CommandTarget.java:66) ... 73 more Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce users on v7.0 who use SEO enabled catalogs on Oracle databases. PROBLEM ABSTRACT: An 'ORA-01722: invalid number' exception may be thrown when deleting SEO enabled catalog entries or catalog groups from an Oracle database using Management Center. BUSINESS IMPACT: Business users cannot delete the catalog entries and categories. RECOMMENDATION:
Problem conclusion
The fix in this APAR is to store the status as a String rather than as an Object so that it can be converted to a number correctly. ------------------------------------------------------------- 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
JR42218
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-13
Closed date
2012-04-18
Last modified date
2012-04-18
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 DEV ED W
Fixed component ID
5724I3900
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
07 December 2021