4 Replies Latest reply on Nov 12, 2010 12:17 PM by Amir Khamis

    Problem upgrading bl 7.6.0.248 to 8SP6

    Amir Khamis

      I am getting an error message running the blmigration_mgr utility, any idea what is wrong ?

       

       

      D:\bl8\NSH\bin>blmigration_mgr.exe d:\temp\bl_8.0.0\oracle\upgrade

      Migration Manager built on: Thu Oct 14 23:41:14 EDT 2010
      ... which is the timestamp of file: D:/bl8/NSH/migrationmanager/migration-framework.jar

      [10 Nov 2010 16:21:32,882] [main] [INFO] [::] [] Upgrade path read as parameter =d:\temp\bl_8.0.0\oracle\upgrade
      [10 Nov 2010 16:21:32,882] [main] [INFO] [::] [] Running  default way ( UI or CLI)
      [10 Nov 2010 16:21:32,882] [main] [INFO] [::] [] Running the UI
      [10 Nov 2010 16:21:32,944] [main] [INFO] [::] [] Initializing Database API ...
      [10 Nov 2010 16:21:33,554] [main] [WARN] [::] [] MigDatabaseAPI::cmdLineDriverSourceUserPassPlain=null
      [10 Nov 2010 16:21:33,554] [main] [INFO] [::] [] Datasource creation Driver=
      [10 Nov 2010 16:21:33,569] [main] [INFO] [::] [] Datasource creation connectionString=
      [10 Nov 2010 16:21:33,569] [main] [INFO] [::] [] Datasource creation userId=
      [10 Nov 2010 16:21:33,569] [main] [ERROR] [::] [] MigDatabaseAPI::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty
      com.bladelogic.mig.framework.common.MigException: The Driver class is null or empty
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.createDataSource(MigDatabaseAPI.java:211)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:101)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.<init>(MigDatabaseAPI.java:67)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.getInstance(MigDatabaseAPI.java:42)
              at com.bladelogic.mig.db.MigDBAPI.execute(MigDBAPI.java:54)
              at com.bladelogic.mig.db.MigDBAPI.executeSqlId(MigDBAPI.java:96)
              at com.bladelogic.mig.db.MigDBUtils.getDBVersionFromSystemPropertyTable(MigDBUtils.java:69)
              at com.bladelogic.mig.framework.common.MigUtils.checkDatabaseIsAtValidVersion(MigUtils.java:73)
              at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.<init>(ChainedMigration.java:25)
              at com.bladelogic.mig.Migration.runUI(Migration.java:85)
              at com.bladelogic.mig.Migration.main(Migration.java:68)
      [10 Nov 2010 16:21:33,569] [main] [INFO] [::] [] Initializing Database API ...
      [10 Nov 2010 16:21:33,804] [main] [WARN] [::] [] MigDatabaseAPI::cmdLineDriverSourceUserPassPlain=null
      [10 Nov 2010 16:21:33,804] [main] [INFO] [::] [] Datasource creation Driver=
      [10 Nov 2010 16:21:33,804] [main] [INFO] [::] [] Datasource creation connectionString=
      [10 Nov 2010 16:21:33,804] [main] [INFO] [::] [] Datasource creation userId=
      [10 Nov 2010 16:21:33,804] [main] [ERROR] [::] [] MigDatabaseAPI::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty
      com.bladelogic.mig.framework.common.MigException: The Driver class is null or empty
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.createDataSource(MigDatabaseAPI.java:211)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:101)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.<init>(MigDatabaseAPI.java:67)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.getInstance(MigDatabaseAPI.java:42)
              at com.bladelogic.mig.db.MigDBAPI.cleanupResources(MigDBAPI.java:31)
              at com.bladelogic.mig.db.MigDBUtils.getDBVersionFromSystemPropertyTable(MigDBUtils.java:82)
              at com.bladelogic.mig.framework.common.MigUtils.checkDatabaseIsAtValidVersion(MigUtils.java:73)
              at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.<init>(ChainedMigration.java:25)
              at com.bladelogic.mig.Migration.runUI(Migration.java:85)
              at com.bladelogic.mig.Migration.main(Migration.java:68)
      [10 Nov 2010 16:21:33,804] [main] [ERROR] [::] [] MigUtils::checkDatabaseIsAtValidVersion:: Exception while getting the DB version.
      com.bladelogic.mig.framework.common.MigException: MigDatabaseAPI::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:108)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.<init>(MigDatabaseAPI.java:67)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.getInstance(MigDatabaseAPI.java:42)
              at com.bladelogic.mig.db.MigDBAPI.cleanupResources(MigDBAPI.java:31)
              at com.bladelogic.mig.db.MigDBUtils.getDBVersionFromSystemPropertyTable(MigDBUtils.java:82)
              at com.bladelogic.mig.framework.common.MigUtils.checkDatabaseIsAtValidVersion(MigUtils.java:73)
              at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.<init>(ChainedMigration.java:25)
              at com.bladelogic.mig.Migration.runUI(Migration.java:85)
              at com.bladelogic.mig.Migration.main(Migration.java:68)
      Caused by: com.bladelogic.mig.framework.common.MigException: The Driver class is null or empty
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.createDataSource(MigDatabaseAPI.java:211)
              at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:101)
              ... 8 more
      [10 Nov 2010 16:21:33,819] [main] [INFO] [::] [] TOP LEVEL MIGRATION EXCEPTION CAUGHT.
      Error while checking the DB required version. Error is:<MigUtils::checkDatabaseIsAtValidVersion:: Exception while getting the DB version.com.bladelogic.mig.framework.common.MigException: MigDatabaseAP
      I::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty>.Database needs to be at least at version 7.6.0


      D:\bl8\NSH\bin>

        • 1. Re: Problem upgrading bl 7.6.0.248 to 8SP6
          Bill Robinson

          can you run a 'blasadmin show data all' and put in the output ?

          • 2. Re: Problem upgrading bl 7.6.0.248 to 8SP6
            Amir Khamis

            here you go:

            bladmin>show data all
            [Database]
            AutoBatchEnabled:true
            ConnectionString:jdbc:oracle:thin:@10.53.51.110:1521:ORCL
            DatabaseInstrumentationFilePath:
            DatabaseInstrumentationRolloverCount:10
            DatabaseInstrumentationRolloverSize:10000
            DatabaseVersion:7.6.0
            DriverClass:oracle.jdbc.driver.OracleDriver
            FetchSize:100
            IdleConnectionTestPeriod:
            MaxClientConnections:100
            MaxGeneralConnections:100
            MaxIdleTime:
            MaxJobExecutionConnections:100
            MaxWaitTime:
            MinClientConnections:0
            MinGeneralConnections:0
            MinJobExecutionConnections:0
            MinTimeToLog:0
            Password:XEWZVVWAPNXMPKEONMXUOWXNKZMAWQAKXANVMAANVWNVBETUMBUNTKABWKZKEQZN
            TransactionAttempts:10
            UserId:bladelogic
            bladmin>

            • 3. Re: Problem upgrading bl 7.6.0.248 to 8SP6
              Amir Khamis

              I ran it again after fixing the db setting:  her is the output:

              D:\bl8\NSH\bin>blmigration_mgr.exe d:\temp\bl_8.0.0\oracle\upgrade

              Migration Manager built on: Thu Oct 14 23:41:14 EDT 2010
              ... which is the timestamp of file: D:/bl8/NSH/migrationmanager/migration-framework.jar

              [10 Nov 2010 17:10:31,851] [main] [INFO] [::] [] Upgrade path read as parameter =d:\temp\bl_8.0.0\oracle\upgrade
              [10 Nov 2010 17:10:31,851] [main] [INFO] [::] [] Running  default way ( UI or CLI)
              [10 Nov 2010 17:10:31,851] [main] [INFO] [::] [] Running the UI
              [10 Nov 2010 17:10:31,866] [main] [INFO] [::] [] Initializing Database API ...
              [10 Nov 2010 17:10:32,351] [main] [WARN] [::] [] MigDatabaseAPI::cmdLineDriverSourceUserPassPlain=null
              [10 Nov 2010 17:10:32,351] [main] [INFO] [::] [] Datasource creation Driver=
              [10 Nov 2010 17:10:32,351] [main] [INFO] [::] [] Datasource creation connectionString=jdbc:oracle:thin:@phlabwin200310:1521:ORCL
              [10 Nov 2010 17:10:32,351] [main] [INFO] [::] [] Datasource creation userId=bladelogic
              [10 Nov 2010 17:10:32,351] [main] [ERROR] [::] [] MigDatabaseAPI::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty
              com.bladelogic.mig.framework.common.MigException: The Driver class is null or empty
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.createDataSource(MigDatabaseAPI.java:211)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:101)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.<init>(MigDatabaseAPI.java:67)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.getInstance(MigDatabaseAPI.java:42)
                      at com.bladelogic.mig.db.MigDBAPI.execute(MigDBAPI.java:54)
                      at com.bladelogic.mig.db.MigDBAPI.executeSqlId(MigDBAPI.java:96)
                      at com.bladelogic.mig.db.MigDBUtils.getDBVersionFromSystemPropertyTable(MigDBUtils.java:69)
                      at com.bladelogic.mig.framework.common.MigUtils.checkDatabaseIsAtValidVersion(MigUtils.java:73)
                      at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.<init>(ChainedMigration.java:25)
                      at com.bladelogic.mig.Migration.runUI(Migration.java:85)
                      at com.bladelogic.mig.Migration.main(Migration.java:68)
              [10 Nov 2010 17:10:32,351] [main] [INFO] [::] [] Initializing Database API ...
              [10 Nov 2010 17:10:32,554] [main] [WARN] [::] [] MigDatabaseAPI::cmdLineDriverSourceUserPassPlain=null
              [10 Nov 2010 17:10:32,569] [main] [INFO] [::] [] Datasource creation Driver=
              [10 Nov 2010 17:10:32,569] [main] [INFO] [::] [] Datasource creation connectionString=jdbc:oracle:thin:@phlabwin200310:1521:ORCL
              [10 Nov 2010 17:10:32,569] [main] [INFO] [::] [] Datasource creation userId=bladelogic
              [10 Nov 2010 17:10:32,569] [main] [ERROR] [::] [] MigDatabaseAPI::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty
              com.bladelogic.mig.framework.common.MigException: The Driver class is null or empty
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.createDataSource(MigDatabaseAPI.java:211)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:101)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.<init>(MigDatabaseAPI.java:67)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.getInstance(MigDatabaseAPI.java:42)
                      at com.bladelogic.mig.db.MigDBAPI.cleanupResources(MigDBAPI.java:31)
                      at com.bladelogic.mig.db.MigDBUtils.getDBVersionFromSystemPropertyTable(MigDBUtils.java:82)
                      at com.bladelogic.mig.framework.common.MigUtils.checkDatabaseIsAtValidVersion(MigUtils.java:73)
                      at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.<init>(ChainedMigration.java:25)
                      at com.bladelogic.mig.Migration.runUI(Migration.java:85)
                      at com.bladelogic.mig.Migration.main(Migration.java:68)
              [10 Nov 2010 17:10:32,569] [main] [ERROR] [::] [] MigUtils::checkDatabaseIsAtValidVersion:: Exception while getting the DB version.
              com.bladelogic.mig.framework.common.MigException: MigDatabaseAPI::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:108)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.<init>(MigDatabaseAPI.java:67)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.getInstance(MigDatabaseAPI.java:42)
                      at com.bladelogic.mig.db.MigDBAPI.cleanupResources(MigDBAPI.java:31)
                      at com.bladelogic.mig.db.MigDBUtils.getDBVersionFromSystemPropertyTable(MigDBUtils.java:82)
                      at com.bladelogic.mig.framework.common.MigUtils.checkDatabaseIsAtValidVersion(MigUtils.java:73)
                      at com.bladelogic.mig.framework.chainedmigration.ChainedMigration.<init>(ChainedMigration.java:25)
                      at com.bladelogic.mig.Migration.runUI(Migration.java:85)
                      at com.bladelogic.mig.Migration.main(Migration.java:68)
              Caused by: com.bladelogic.mig.framework.common.MigException: The Driver class is null or empty
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.createDataSource(MigDatabaseAPI.java:211)
                      at com.bladelogic.mig.db.impl.MigDatabaseAPI.initializeAPI(MigDatabaseAPI.java:101)
                      ... 8 more
              [10 Nov 2010 17:10:32,569] [main] [INFO] [::] [] TOP LEVEL MIGRATION EXCEPTION CAUGHT.
              Error while checking the DB required version. Error is:<MigUtils::checkDatabaseIsAtValidVersion:: Exception while getting the DB version.com.bladelogic.mig.framework.common.MigException: MigDatabaseAP
              I::initializeAPI::Could not retrieve the data source information; The Driver class is null or empty>.Database needs to be at least at version 7.6.0


              D:\bl8\NSH\bin>

              • 4. Re: Problem upgrading bl 7.6.0.248 to 8SP6
                Amir Khamis

                Turned out to be server forgot it's db setting.  I reset the settings per support:

                set database conn jdbc:oracle:thin:@SERVER:PORT:INSTANCE

                set database driver oracle.jdbc.driver.OracleDriver

                set database user bladelogic_user

                set database password <cleartextpasswordforbladelogic>

                 

                re-ran the migration and it worked.