JR49653: CMVC 234767 - Quick Publish times out when publishing a large amount of data after applying JR48772

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

APAR status

• Closed as program error.

Error description

• Quick Publish times out when publishing changes to a very large
  number of items.
  
   An error similar to the following may be seen in the logs:
   [2/22/14 6:17:32:512 IST] 00000013 TimeoutManage I   WTRN0006W:
  Transaction
  0000014456FD6B1F00000001000002AF027A469C93CAB9EA26C01F0A4D47CADB
  9F3DE8530000014456FD6B1F00000001000002AF027A469C93CAB9EA26C01F0A
  4D47CADB9F3DE85300000001 has timed out after 1200 seconds.
   [2/22/14 6:17:32:516 IST] 00000013 TimeoutManage I   WTRN0124I:
  When the timeout occurred the thread with which the transaction
  is, or was most recently, associated was
  Thread[WorkManager.default : 4,5,reserved: WC_demo]. The stack
  trace of this thread when the timeout occurred was:
     java.net.SocketOutputStream.socketWrite0(Native Method)
  
  java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:
  103)
  
  java.net.SocketOutputStream.write(SocketOutputStream.java:147)
  

Local fix

• Quick Publish is designed to handle publication of a small
  changes in a timely manner. The stagingprop utility should be
  used to propagate much larger loads.
   Note that the stagingprop utility can be configured to only
  propagate specific tables from the staging environment to
  production.
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce v7 users who are using quick publish with
  large data sets
  
   PROBLEM ABSTRACT:
   Quick Publish times out when publishing a large amount of data
  after applying JR48772
  
   BUSINESS IMPACT:
   Business users will be unable to leverage QuickPublish for
  large data sets. Stagingprop can be used as a workaround
  
   RECOMMENDATION:
  

Problem conclusion

• Improved caching of the meta data for tables to avoid multiple
  look-ups.
   -------------------------------------------------------------
   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