PM81203: LOG ENTRIES SHOWING "TABLEALIAS" APPEAR IN SYSTEMOUT.LOG FOR JPA APPLICATIONS AFTER UPGRADE TO V7.0.0.25

7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server

APAR status

• Closed as program error.

Error description

• After installing Fix Pack 25 (V7.0.0.25), entries might be
  written to the SystemOut.log containing the string "tableAlias"
  if JPA applications are running on the application server.  The
  log entries will be similar to the following:
  .
  [1/15/13 1:57:39:096 UTC] 00000039 SystemOut     O   1)
  tableAlias =
  [1/15/13 1:57:39:096 UTC] 00000039 SystemOut     O   2)
  tableAlias =
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server V7.0 who make use of a specific      *
  *                  implementation of OpenJPA's                 *
  *                  @VersionStrategy.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: SystemOut.log contains the text         *
  *                      "tableAlias" when a specific WebSphere  *
  *                      implementation of @VersionStrategy is   *
  *                      used.                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Starting in WebSphere Application Server Fix Pack 7.0.0.25,
  there exists the potential for the SystemOut.log file to
  contain the following text:
  SystemOut     O   1)tableAlias =
  This text is extraneous but may cause a user to question this
  entry.  This entry is printed only under a very specific
  situation.  That is, if an application uses OpenJPA and the
  following specific WebSphere implementation of
  an OpenJPA @VersionStrategy:
  "com.ibm.websphere.persistence.RowChangeTimestampStrategy"
  In addition to this, a table alias would need to be defined.
  

Problem conclusion

• With this fix, the extraneous SystemOut entry has been removed.
  
  The fix for this APAR is currently targeted for
  inclusion in Service Levels (Fix Packs) 7.0.0.29 of WebSphere
  Application Server version 7.0.0.
  
  Please refer to the recommended updates page for delivery
  information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

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 APP S

• Fixed component ID

  5724J0800

Applicable component levels

• R700 PSY

     UP