JR48809: Quick Publish cannot publish more than one attachment/managed file in a federated environment.

7.0.0-WS-WCServer-FP009
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 using Workspaces quick publish and a federated Websphere
  Commerce environment to publish more than one attachment, an
  error similar to the following might be seen:
  
   DSRA9110E: Statement is closed.
   at
  com.ibm.commerce.context.content.resources.file.ManagedFileResou
  rceManager.publish(ManagedFileResourceManager.java:532)
  ...
  Caused by: com.ibm.websphere.ce.cm.ObjectClosedException:
  DSRA9110E: Statement is closed.
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WS
  JdbcWrapper.java:110)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WS
  JdbcStatement.java:1821)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setLong(WSJdbc
  PreparedStatement.java:2062)
   at
  com.ibm.commerce.context.content.resources.file.ManagedFileResou
  rceManager.publishFileContent(ManagedFileResourceManager.java:27
  2)
   at
  com.ibm.commerce.context.content.resources.file.ManagedFileResou
  rceManager.publish(ManagedFileResourceManager.java:402)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Users quick publishing for attachments &
  managed files in an authoring environment within a federated
  Commerce instance.
  
  PROBLEM ABSTRACT:
  Quick Publish cannot publish more than one attachment / managed
  file in a federated Commerce environment.
  
  BUSINESS IMPACT:
  Quick publishing managed files & attachments is limited to one
  at a time.
  
  RECOMMENDATION:
  

Problem conclusion

• During the quick publishing of managed files, the prepared
  statement was being prematurely closed prior to the completion
  of the processing for the remaining attachments & managed files.
  The code has been updated to fix this situation.
  
  -------------------------------------------------------------
  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