LI76405: CMVC 213850 - CORRECT A CLASS CAST EXCEPTION DURING FIXPACK UPDATES TO THE DATABASE.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.5 Fix Pack
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When trying to run updateDB.sh/bat the database update fails.
  
  Upon examining the updateDB.log file you may see an error
  similar to the following:
  
  > 2011-09-06 11:22:58.045, <main>,
  com.ibm.commerce.context.content.ant.tasks.UpdateWorkspacesTable
  Task::performTask(), S1
   CWXBR0001E: A generic runtime system exception occured.  The
  exception is: "java.lang.ClassCastException:
  java.lang.StringBuffer incompatible with java.lang.String
   at
  com.ibm.commerce.context.content.objects.schema.AbstractContentR
  esourceSchemaImpl.formatString(AbstractContentResourceSchemaImpl
  .java:2015)
   at
  com.ibm.commerce.context.content.objects.schema.AbstractContentR
  esourceSchemaImpl.getCreatePrimaryKeyStatementForExistingTableAn
  dSchema(AbstractContentResourceSchemaImpl.java:5173)
   at
  com.ibm.commerce.context.content.objects.schema.AbstractContentR
  esourceSchemaImpl.getUpdateTableStatementForTableAndNewSchema(Ab
  stractContentResourceSchemaImpl.java:4286)
   at
  com.ibm.commerce.context.content.objects.ContentSchemaUtility.ch
  eckAndUpdateColumnAddedSQLStatements(ContentSchemaUtility.java:3
  576)
   at
  com.ibm.commerce.context.content.objects.ContentSchemaUtility.up
  dateSchemaTableSQLStatements(ContentSchemaUtility.java:3075)
   at
  com.ibm.commerce.context.content.objects.ContentSchemaUtility.up
  dateTableForExistingSchemas(ContentSchemaUtility.java:2746)
   at
  com.ibm.commerce.context.content.ant.tasks.UpdateWorkspacesTable
  Task.performTask(UpdateWorkspacesTableTask.java:261)
   at
  com.ibm.commerce.context.content.ant.tasks.CreateWorkspaceTask.e
  xecute(CreateWorkspaceTask.java:183)
   at
  com.ibm.commerce.context.content.ant.tasks.UpdateWorkspacesTable
  Task.execute(UpdateWorkspacesTableTask.java:142)
   at
  org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
  275)
   at org.apache.tools.ant.Task.perform(Task.java:364)
   at org.apache.tools.ant.Target.execute(Target.java:341)
   at org.apache.tools.ant.Target.performTasks(Target.java:369)
   at
  org.apache.tools.ant.Project.executeSortedTargets(Project.java:1
  216)
   at
  org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(S
  ingleCheckExecutor.java:37)
   at
  org.apache.tools.ant.Project.executeTargets(Project.java:1068)
   at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
   at
  org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java
  :107)
   at
  org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
  275)
  

Local fix

Problem summary

• USERS AFFECTED:
  All Websphere Commerce users on v7.0
  
  PROBLEM ABSTRACT:
  upateDB.sh/bat fails to complete due to a classCast exception
  
  BUSINESS IMPACT:
  Customer will not be able to update their systems to fixpack 3
  
  RECOMMENDATION:
  

Problem conclusion

• A program error was found and has been corrected to cast the
  stringbuffer to the string correctly.
  
  The code was modified to handle the class cast exception.
  -------------------------------------------------------------
  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 ED ILINU

• Fixed component ID

  5724I3804

Applicable component levels

• R600 PSY

     UP