PH53520: SERVICEABILITY IMPROVEMENT TO AID IN DEBUGGING CWLRB5841E DB2 SQL ERROR: SQLCODE=-433, SQLSTATE=22001

APAR status

• Closed as program error.

Error description

• Error SQLCODE=-433, SQLSTATE=22001 means VALUE value IS TOO
  LONG.  Error in the log shows:
  Caused by:
  com.ibm.ws.gridcontainer.exceptions.PersistenceException:
  CWLRB5828E: Error updating table with query UPDATE WASDBWCG.LOC
  ALJOBSTATUS SET STATUS = ?, CURRENTSTEP = ?, RC = ?,
  SUSPENDEDUNTIL = ?, LASTUPDATE = ?, UPDATECOUNT = ?, STEPDATA =
  ?, STEPRETRIES
  = ?, STEPTIME = ?, RECORDMETRICS = ? WHERE JOBID = ? :
  com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error:
  SQLCODE=-433, SQLSTATE=22
  001, SQLERRMC=<Lob-Value>, DRIVER=4.31.15
   at com.ibm.ws.gridcontainer.persistence.LocalJobStatusDataStor
  eImpl.update(LocalJobStatusDataStoreImpl.java:565)
   at com.ibm.ws.gridcontainer.services.impl.WASJDBCPersistenceSe
  rviceImpl._updateJobStatus(WASJDBCPersistenceServiceImpl.java:2
  84)
   at com.ibm.ws.gridcontainer.services.impl.AbstractPersistenceM
  anagerImpl.updateData(AbstractPersistenceManagerImpl.java:312)
   at com.ibm.ws.gridcontainer.services.impl.JobStatusManagerImpl
  .updateContextData(JobStatusManagerImpl.java:887)
   at com.ibm.ws.gridcontainer.batch.checkpoint.CheckpointMgr._up
  dateContextData(CheckpointMgr.java:510)
   at com.ibm.ws.gridcontainer.batch.checkpoint.CheckpointMgr.pre
  pareForCheckpoint(CheckpointMgr.java:354)
  
  But you can't tell from the error or with trace enabled, what
  lengths are being used in the update to the table.
  

Local fix

• obtain a dump in DB2 for SQLCODE=-433, SQLSTATE=22001 and use
  that to review the lengths in the update to the table.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server                                      *
  *                  V8.5 and V9 Java Batch                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A DB2 -433 error occurred when updating *
  *                      the                                     *
  *                      LOCALJOBSTATUS batch runtime table, and *
  *                      the                                     *
  *                      following exception can be seen:        *
  *                      CWLRB5828E: Error updating table with   *
  *                      query                                   *
  *                      UPDATE schema_name.LOCALJOBSTATUS SET   *
  *                      STATUS =                                *
  *                      ?, CURRENTSTEP = ?, RC = ?,             *
  *                      SUSPENDEDUNTIL = ?,                     *
  *                      LASTUPDATE = ?, UPDATECOUNT = ?,        *
  *                      STEPDATA = ?,                           *
  *                      STEPRETRIES = ?, STEPTIME = ?,          *
  *                      RECORDMETRICS =                         *
  *                      ? WHERE JOBID = ? :                     *
  *                      com.ibm.db2.jcc.am.SqlDataException:    *
  *                      DB2 SQL                                 *
  *                      Error:                                  *
  *                      SQLCODE=-433, SQLSTATE=22               *
  *                      001, SQLERRMC=<Lob-Value>               *
  *                      at                                      *
  *                      com.ibm.ws.gridcontainer.persistence.Lo *
  *                      calJobSt                                *
  *                      atusDataStor                            *
  *                      eImpl.update(LocalJobStatusDataStoreImp *
  *                      l.java:5                                *
  *                      65)                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The -433 error code means that a field was too large for the
  column
  definition and the SQLERRMC=<Lob-Value> means that it was one of
  the blob values used here, either the RECORDMETRICS or STEPDATA
  fields.
  However, the underlying exception does not indicate which field
  is
  too large or what the size of the value was.  Extra steps were
  needed to obtain a DB2 dump to find this information.
  

Problem conclusion

• A code update has been made to trace the size of the RECORDMETRI
  and STEPDATA fields if an error is countered updating the
  LOCALJOBSTATUS batch runtime table at this location.
  
  The fix for this APAR is targeted for inclusion in fix pack
  9.0.5.17 and 8.5.5.24. For more information, see 'Recommended
  Updates for WebSphere Application Server':
  https://www.ibm.com/support/pages/node/715553
  

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

  WEBSPHERE FOR Z

• Fixed component ID

  5655I3500

Applicable component levels