JR42218: CMVC 219709 - RESOLVE THE 'ORA-01722: INVALID NUMBER' EXCEPTION THAT OCCURS WITH ORACLE DATABASE

7.0.0-WS-WCServer-FP009

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 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