0 Replies Latest reply on Jan 30, 2016 4:22 AM by SanjayGupta92

    SQL Developer Migration from SQL Server To Oracle Fails, looking for reason/log files

    SanjayGupta92

      How do I find out where Migration Wizard is failing ( From SQL Server to Oracle) ? Is it in  XML file or some other log file.

      I see following error in XML file.

      How do I find out what is causing issues ?

       

       

      <record>

        <date>2016-01-29T20:08:07</date>

        <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>

        <level>SEVERE</level>

        <class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>

        <message>Generation phase

      null</message>

        <param>oracle.dbtools.metadata.persistence.PersistableObjectIterator.next(PersistableObjectIterator.java:131)</param>

        <param>oracle.dbtools.migration.generate.GenerateWorker.generateIndividualTable(GenerateWorker.java:2573)</param>

        <param>oracle.dbtools.migration.generate.GenerateWorker.generateAllTables(GenerateWorker.java:2094)</param>

        <param>oracle.dbtools.migration.generate.GenerateWorker.generateIndividualSchema(GenerateWorker.java:792)</param>

        <param>oracle.dbtools.migration.generate.GenerateWorker.generateSchema(GenerateWorker.java:532)</param>

        <param>oracle.dbtools.migration.generate.GenerateWorker.runGenerate(GenerateWorker.java:339)</param>

        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doGenerate(FullMigrateTask.java:1261)</param>

        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:430)</param>

        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:314)</param>

        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:147)</param>

        <param>oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)</param>

        <param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>

        <param>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)</param>

        <param>java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)</param>

        <param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>

        <param>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</param>

        <param>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</param>

        <param>java.lang.Thread.run(Thread.java:745)</param>

        <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@53dbf4ab</param>

        <exception>

          <message>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Generation phase

      null</message>

          <frame>

            <class>oracle.dbtools.metadata.persistence.PersistableObjectIterator</class>

            <line>131</line>

          </frame>

          <frame>

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

            <line>2573</line>

          </frame>

          <frame>

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

            <line>2094</line>

          </frame>

          <frame>

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

            <line>792</line>

          </frame>

          <frame>

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

            <line>532</line>

          </frame>

          <frame>

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

            <line>339</line>

          </frame>

          <frame>

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

            <line>1261</line>

          </frame>

          <frame>

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

            <line>430</line>

          </frame>

          <frame>

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

            <line>314</line>

          </frame>

          <frame>

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

            <line>147</line>

          </frame>

          <frame>

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

            <line>193</line>

          </frame>

          <frame>

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

            <line>266</line>

          </frame>

          <frame>

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

            <line>621</line>

          </frame>

          <frame>

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

            <line>511</line>

          </frame>

          <frame>

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

            <line>266</line>

          </frame>

          <frame>

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

            <line>1142</line>

          </frame>

          <frame>

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

            <line>617</line>

          </frame>

          <frame>

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

            <line>745</line>

          </frame>

        </exception>

       

       

      </record>

      <record>

        <date>2016-01-29T20:08:07</date>

        <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>

        <level>WARNING</level>

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

        <message>Generating Table t_pt_UDRCTapered: FAILED : Database Migration : FAILED</message>

        <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@270bcb1f</param>

       

       

      </record>