IBM Support

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

Fixes are available

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

Subscribe

You can track all active APARs for this component.

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 number

    PM34539

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-10

  • Closed date

    2011-05-03

  • Last modified date

    2011-05-03

  • 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



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PM34539

Modified date: 03 May 2011