JR49347: CMVC 234603 - Quick Publish fails with ResourceException when publishing a delete statement

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When deletions are performed through Quick Publish, in some
  cases the update counts are not adjusted correctly and a
  ResourceException is thrown indicating that the deletion did not
   occur.
  
  An exception similar to the following may be seen in the logs:
  CommerceSrvr  E
  com.ibm.commerce.context.content.resources.ResourceContentEventL
  istener processActivityEvent(WCSEvent ae) CMN0409E The following
  error occurred during processing {0}.
  com.ibm.commerce.context.content.resources.exception.ResourceExc
  eption The update did not execute successfully on the CATENCALCD
  table.
          at
  com.ibm.commerce.context.content.resources.publish.DefaultJDBCCo
  ntentPublisherImpl.executeUpdate(DefaultJDBCContentPublisherImpl
  .java:263)
          at
  com.ibm.commerce.context.content.resources.publish.DefaultJDBCCo
  ntentPublisherImpl.deleteResource(DefaultJDBCContentPublisherImp
  l.java:538)
          at
  com.ibm.commerce.context.content.resources.AbstractResourceManag
  erImpl.publish(AbstractResourceManagerImpl.java:1355)
          at
  com.ibm.commerce.marketing.promotion.content.resources.CatalogEn
  tryCalculationCodeResourceManager.publish(CatalogEntryCalculatio
  nCodeResourceManager.java:577)
  ...
  ...
  CommerceSrvr  E
  com.ibm.commerce.contentmanagement.commands.TaskGroupCleanupCmdI
  mpl publishTaskGroup CMN0409E The following error occurred
  during processing {0}.
  Correlation Identity 3717458c143e18013f9-7e48
  Additional Data
          null
  Current exception
  Message
     _ERR_GENERIC
  Stack trace
  com.ibm.commerce.exception.ECSystemException The following error
  occurred during processing {0}.
          at
  com.ibm.commerce.context.content.resources.ResourceContentEventL
  istener.processActivityEvent(ResourceContentEventListener.java:1
  56)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce v7 users who use Quick Publish after applying
  JR48564
  
  PROBLEM ABSTRACT:
  Quick Publish fails with ResourceException when publishing a
  delete statement
  
  BUSINESS IMPACT:
  Changes cannot be published on an urgent basis from Staging to
  Production
  
  RECOMMENDATION:
  

Problem conclusion

• The failure occurs when a delete statement is executed on a
  table (e.g. CATENCALCD).
  
  The delete occurs successfully but the update count isn't
  generated correctly so an error is thrown to indicate that one
  more updates didn't occur successfully and the transaction is
  unnecessarily rolled back.
  
  The update count has been fixed to return the correct count
  value
  -------------------------------------------------------------
  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 EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP