PM34539: WASPREUPGRADE IS FAILING WHEN TRYING TO MIGRATE DERBY DATABASE WHICH IS NOT FOUND.

7.0.0.19: WebSphere Application Server V7.0 Fix Pack 19
7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21
7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23
7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25
7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
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.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
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.19: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.21: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere
7.0.0.23: Java SDK 1.6 SR10 FP1 Cumulative Fix for WebSphere
7.0.0.25: Java SDK 1.6 SR11 Cumulative Fix for WebSphere Application Server
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
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

• During preupgrade process when a derby database is not found it
  should throw a NotFoundException and allow migration to
  continue,but it is failing with the following errors.
  
  The following error can be seen in WASPreupgrade.log file:
  
  MIGR0496E: Derby database lock file detected.  Cannot migrate
  Derby database <database name> while in use.
  com.ibm.ws.migration.utility.UpgradeException: MIGR0496E: Derby
  database lock file detected.  Cannot migrate Derby database
  <database name> while in use.
  at
  com.ibm.ws.migration.preupgrade.ResourcesCopyDocumentProcessor.c
  opyDerbyDBs(ResourcesCopyDocumentProcessor.java:466)
  at
  com.ibm.ws.migration.preupgrade.ResourcesCopyDocumentProcessor.c
  opyDerbyDBs(ResourcesCopyDocumentProcessor.java:389)
  at
  com.ibm.ws.migration.preupgrade.ResourcesCopyDocumentProcessor.<
  init>(ResourcesCopyDocumentProcessor.java:129)
  
  
  The following error stacks can be seen in WASPreUpgrade.trace
  file:
  
  [3/1/11 20:02:53:208 GMT] 0000000a ResourcesCopy 1
  copyDerbyDBs(..):Unable to backup cloudscape/derby database
  because an exception was received during connection
  
  <database name>
  java.sql.SQLException: Database
  '<database name>' not found.
  at
  org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException
  (Unknown
  Source)
  at
  org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
  Source)
  at
  org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
  Source)
  
  Caused by: java.sql.SQLException: Database
  '<database name>' not found.
  at
  org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(U
  nknownSource)
  at
  org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTran
  sportAcrossDRDA(Unknown Source).......
  

Local fix

• As a workaround setting the option -requireEmbeddedDBMigration
  to false in preupgrade command.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server V7.0 WASPreUpgrade who have a Derby  *
  *                  database configured that does not exist.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The WASPreUpgrade fails with an         *
  *                      SQLException on the Derby database      *
  *                      that does not exist.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During WASPreUpgrade, an SQLException is thrown when
  trying to connect to a Derby database that does not exist.
  

Problem conclusion

• The code has been corrected to catch the SQLException and
  check the SQLState. If the SQLState indicates the database was
  not found, the exception is logged in the trace, and the
  WASPreUpgrade is allowed to continue.
  
  The fix for this APAR is currently targeted for inclusion in
  fix pack 7.0.0.19.  Please refer to the Recommended Updates
  page for delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

Temporary fix

• The requireEmbeddedDBMigration flag can be specified on the
  WASPreUpgrade with a value of false. This causes any exception
  that occurs when you migrate the embedded databases to be
  logged in the trace file, and the WASPreUpgrade command will
  continue.
  

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