IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR48809

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-13

  • Closed date

    2014-01-21

  • Last modified date

    2015-05-01

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 May 2015