PM11951: SQLException updating data during DST Correction

APAR status

• Closed as program error.

Error description

• SQLException updating data during DST Correction Case
  
  When correcting nodes which have been written to the database
  during the DST time change, the following SQL Exception occurs:
  
  [3/13/10 21:39:39:659 EST] 0000008d PPreparedStat 3
  com.ibm.icm.da.portable.common.sql.PPreparedStatement
  executeQuery() ==> [UPDATE JCR.ICMUT01663001 SET
  ATTR0000001002=?,ATTR0000001091=?,ATTR0000001092=?,ATTR000000109
  
  3=?,ATTR0000001151=?,ATTR0000001153=?,ATTR0000001157=?,ATTR00000
  
  01318=?,ATTR0000001321=?,ATTR0000001324=?,ATTR0000001328=?,ATTR0
  
  000001331=?,ATTR0000001352=?,ATTR0000001353=?,ATTR0000001354=?,A
  
  TTR0000001355=?,ATTR0000001356=?,ATTR0000001357=NULL,ATTR0000001
  
  358=?,ATTR0000001359=?,ATTR0000001361=?,ATTR0000001362=?,ATTR000
  
  0001364=?,ATTR0000001365=?,ATTR0000001366=?,ACLCODE=?,SEMANTICTY
  
  PE=?,LASTCHANGEDTS=?,LASTCHANGEDUSERID=?,ATTR0104500014=?,ATTR01
  
  04500126=?,ATTR0105200014=?,ATTR0105200126=? WHERE COMPONENTID
  =
  ? AND VERSIONID = ? AND LASTCHANGEDTS = ? ]
  [3/13/10 21:39:39:756 EST] 0000008d LSUtil        2
  com.ibm.icm.da.portable.common.LSUtil handleSQLException()
  [3/13/10 21:39:39:757 EST] 0000008d LSUtil        2
  com.ibm.icm.da.portable.common.LSUtil handleSQLException()
  Thread 485523678 : lException: [ibm][db2][jcc][t4][2039][11162]
  End of stream prematurely reached while reading InputStream,
  parameter #30.  Remaining data has been padded with 0x0.
  at com.ibm.db2.jcc.c.gb.a(gb.java:305)
  at com.ibm.db2.jcc.c.jb.a(jb.java(Compiled Code))
  at com.ibm.db2.jcc.c.jb.a(jb.java:153)
  at com.ibm.db2.jcc.c.tb.a(tb.java:159)
  at com.ibm.db2.jcc.b.ih.a(ih.java(Inlined Compiled Code))
  at com.ibm.db2.jcc.b.ih.d(ih.java(Compiled Code))
  at com.ibm.db2.jcc.b.ih.W(ih.java:525)
  at com.ibm.db2.jcc.b.ih.executeUpdate(ih.java:508)
  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement
  .pmiExecuteUpdate(WSJdbcPreparedStatement.java:724)
  

Local fix

• Local fix:
  Customer able to resolve issue using previous year's DST
  workaround methods
  

Problem summary

• The DST Correction fix (for nodes changed during DST changeover)
  was not able to correctly handle binary attachments.  Fix has
  been provided.
  

Problem conclusion

• PM11951
  =======
  
  Problem Description:
     SQLException updating data during DST Correction Case
  
  Problem Solution:
    PM11951 contains code changes.
  
  Affected Users:
     All portal users.
  
  Pre-Requisite(s):
     Portal Version: 6.0.1.7
     Portal Fixes:   ---
  
  Installation Steps:
     NOTE:  YOU MUST FIRST DOWNLOAD THE UPDATE INSTALLER TOOL IN
  ORDER TO INSTALL A FIX.
            The WebSphere Portal Update Installer (PUI) can be
  downloaded from the following link:
            http://www.ibm.com/support/docview
  .wss?rs=688&uid=swg24006942
  
  *Reminder: the version of PUI used varies based on the version
  of WebSphere Portal.
  Ensure the correct version is in use.*
  
  Refer to the "Maintaining the cluster" topic in the 6.0
  InfoCenter
  (http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index
  .jsp?topic=/com.ibm.wp.ent.doc/wpf/clus_maint.html)
  for additional information on installing or uninstalling interim
  fixes in clustered environments
  while maintaining continuous availability of your portal.
  
  1. Stop the WebSphere Portal server
  2. Apply the PM11951.jar using the PUI (Portal update
  installer).
     Refer to the PUI readme for further information on using the
  PUI.
  3. Restart the WebSphere Portal server.
  
  
  Uninstall:
  NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.
         DO NOT REMOVE A FIX UNLESS ALL FIXES APPLIED AFTER IT
  HAVE FIRST BEEN REMOVED.
         YOU MAY REAPPLY ANY REMOVED FIX.
  
  Use the Portal Update Installer to uninstall the fix:
  
     1. Shutdown WebSphere Portal.
     2. Follow the instructions that are packaged with the Portal
  Update Installer on how to uninstall a fix.
     3. Restart WebSphere Portal.
  

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

  LOTUS WEB CONT

• Fixed component ID

  5724I2900

Applicable component levels

• R60K PSY

     UP

• R60M PSY

     UP

• R61A PSY

     UP

• R61B PSY

     UP

• R61C PSY

     UP

• R610 PSY

     UP

• R615 PSY

     UP