1 Reply Latest reply on Mar 1, 2016 11:18 PM by thatJeffSmith-Oracle

    SQL Migration to Oracle12c - SQL Developer Migration Tool failing with NULLPointerException

    3053841

      I'm trying to migrate a SQL Server 2005 database (just the tables and constraints) to an Oracle 12c instance. The OMWB_OFFLINE_CAPTURE batch file worked just fine. When using the Migration tool, however, I cannot generate an offline script, nor an online direct target creation, without having the tool fail with a java.lang.NullPointerException error.

       

      SQL Developer Information:

       

      Oracle SQL Developer 3.2.20.09

      Version 3.2.20.09

      Build MAIN-09.87

      IDE Version: 11.1.1.4.37.59.48

      Product ID: oracle.sqldeveloper

      Product Version: 11.2.0.09.87

       

      Component Version

      ========= =======

      Java(TM) Platform 1.6.0_35

      Oracle IDE 3.2.20.09.87

      Versioning Support 3.2.20.09.87

       

      Here is the error stack:

      <exception>

          <message>java.lang.NullPointerException</message>

          <frame>

            <class>oracle.dbtools.migration.generate.GenerateWorker</class>

            <line>734</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.generate.GenerateWorker</class>

            <line>680</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.generate.GenerateWorker</class>

            <line>578</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.generate.GenerateWorker</class>

            <line>330</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>

            <line>1095</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>

            <line>308</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>

            <line>205</line>

          </frame>

          <frame>

            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>

            <line>159</line>

          </frame>

          <frame>

            <class>oracle.dbtools.raptor.backgroundTask.RaptorTask</class>

            <line>193</line>

          </frame>

          <frame>

            <class>java.util.concurrent.FutureTask$Sync</class>

            <line>303</line>

          </frame>

          <frame>

            <class>java.util.concurrent.FutureTask</class>

            <line>138</line>

          </frame>

          <frame>

            <class>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask</class>

            <line>515</line>

          </frame>

          <frame>

            <class>java.util.concurrent.Executors$RunnableAdapter</class>

            <line>441</line>

          </frame>

          <frame>

            <class>java.util.concurrent.FutureTask$Sync</class>

            <line>303</line>

          </frame>

          <frame>

            <class>java.util.concurrent.FutureTask</class>

            <line>138</line>

          </frame>

          <frame>

            <class>java.util.concurrent.ThreadPoolExecutor$Worker</class>

            <line>886</line>

          </frame>

          <frame>

            <class>java.util.concurrent.ThreadPoolExecutor$Worker</class>

            <line>908</line>

          </frame>

          <frame>

            <class>java.lang.Thread</class>

            <line>662</line>

          </frame>

        </exception>