1 2 Previous Next 17 Replies Latest reply on Jan 27, 2016 1:49 PM by Dermot ONeill-Oracle

    SQL Developer Migration Utility Error ( DB2 to Oracle)

    3008289

      Hi Team.

       

      I am trying to migrate DB2 to oracle using Sql developer utilty tool. during conversion i m getting strange error which is not given on anywebsite how to deal with it. please help me with the error.

      "Migration actions have failed. check the migration reports for details.: convert cannot retrieve object if the key is not set"

       

      please help asap.

       

      error_migration.JPG

      i have attached the error screenshot also.

        • 1. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
          Mkirtley-Oracle

          Hi,

          To follow could you let us know -

           

          1. What is the version of DB2 and on which platform it is running ?

          2. What is the size of the Db2 database ?

          3. Are you making an online of offline migration ?

          4. Could you detail the exact steps you have made during the migration ?


          Regards,

          Mike

          • 2. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
            Mkirtley-Oracle

            Hi,

            Also, what is the full SQL*Developer version ?  There were some similar problems with earlier versions whcih should be fixed.


            Regards,

            Mike

            • 3. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
              3008289

              Thanks for seeing the problem.

              The details are as follow:

              1) SQL Developer version: 4.0.3.16

              2) DB2 version: v9.7.0.10

              3) DB2 database size: around 300GB

              4) We are using offline mode to get master script of schema creation.

              5) The steps are one by one as in wizard.

              step 1) associate the migration repository

              step 2) Migrate

              step 3) select the migration repository connection

              step 4) select the source database

              step 5) select online capture of metadata

              step 6) select convert

              step 7) select translate

              step 8) select target database with offline data mode

              step 9) move data offline mode

              step 10) done

               

              let me know any more information needed

              • 4. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                Mkirtley-Oracle

                Hi,

                4.0.3 is quite an old version now. Could you download the latest version from this link -

                 

                Oracle SQL Developer

                 

                and check if you see the same problem ?

                 

                Regards,

                Mike

                • 5. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                  3008289

                  thanks.

                  but in newer version is there any fixes done for such error.

                  • 6. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                    thatJeffSmith-Oracle

                    we've not seen this error before

                     

                    recommend you do the capture and convert, then STOP

                     

                    check your migration reports and the log file, MigrationLog.xml in your migration project directory

                     

                    using 4.1.3 will be better than 4.0.3, but can't guarantee it will address your undiagnosed issue

                    • 7. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                      3008289

                      the log file also has same error mentioned.

                      Moreover how to select particular schema from datadbase during migration. I dnt see any such options during migration wizard

                      • 8. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                        thatJeffSmith-Oracle

                        well, what else did the log show?

                        • 9. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                          3008289

                          let me attach the log file

                           

                          <?xml version="1.0" encoding="windows-1252" standalone="no"?>

                          <log>

                          <record>

                            <date>2016-01-13T14:26:58</date>

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

                            <level>SEVERE</level>

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

                            <message>Cannot retrieve object if key is not set</message>

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

                            <exception>

                              <message>oracle.dbtools.migration.convert.ConvertException: Cannot retrieve object if key is not set</message>

                              <frame>

                                <class>oracle.dbtools.migration.convert.ConverterWorker</class>

                                <line>450</line>

                              </frame>

                              <frame>

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

                                <line>1065</line>

                              </frame>

                              <frame>

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

                                <line>406</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>262</line>

                              </frame>

                              <frame>

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

                                <line>554</line>

                              </frame>

                              <frame>

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

                                <line>471</line>

                              </frame>

                              <frame>

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

                                <line>262</line>

                              </frame>

                              <frame>

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

                                <line>1145</line>

                              </frame>

                              <frame>

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

                                <line>615</line>

                              </frame>

                              <frame>

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

                                <line>745</line>

                              </frame>

                            </exception>

                           

                           

                          </record>

                          <record>

                            <date>2016-01-13T14:26:58</date>

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

                            <level>SEVERE</level>

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

                            <message>Convert

                          Cannot retrieve object if key is not set</message>

                            <param>oracle.dbtools.migration.convert.ConverterWorker.runConvert(ConverterWorker.java:450)</param>

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

                            <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:406)</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:262)</param>

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

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

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

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

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

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

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

                            <exception>

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

                          Cannot retrieve object if key is not set</message>

                              <frame>

                                <class>oracle.dbtools.migration.convert.ConverterWorker</class>

                                <line>450</line>

                              </frame>

                              <frame>

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

                                <line>1065</line>

                              </frame>

                              <frame>

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

                                <line>406</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>262</line>

                              </frame>

                              <frame>

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

                                <line>554</line>

                              </frame>

                              <frame>

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

                                <line>471</line>

                              </frame>

                              <frame>

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

                                <line>262</line>

                              </frame>

                              <frame>

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

                                <line>1145</line>

                              </frame>

                              <frame>

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

                                <line>615</line>

                              </frame>

                              <frame>

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

                                <line>745</line>

                              </frame>

                            </exception>

                           

                           

                          </record>

                          <record>

                            <date>2016-01-13T14:26:58</date>

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

                            <level>WARNING</level>

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

                            <message>Building converted model: FAILED : Database Migration : FAILED</message>

                            <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@104a345</param>

                           

                           

                          </record>

                          • 11. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                            Dermot ONeill-Oracle

                            Hi,

                             

                            I have tried to reproduce this issues with the latest version of SQL Developer and SQL Developer 4.0.2 with no luck.

                            I would start from scratch again just to make sure its not caused by some previous attempt.

                             

                            Here are the steps I would take.

                            Download and use the latest SQL Developer release.

                            Create a brand new migration repository within a new Oracle schema.

                            grant connect,resource,create view,create materialized view to migrep_db2 dentified by migrep_db2;

                            alter user migrep_db2 quota unlimited on users;

                             

                            Recreate the connection to your DB2 database and make sure you can browse the objects ok.*

                            Kick off the migration

                            Migration Wizard Step 5 only select 1 small database.

                            Migration Wizard Step 6 choose finish.

                             

                            * I was able to debug into our code to the relevant place your log file specifies.

                            That code is fairly straight forward and I wasn't able to reproduce your issue.

                            But the code pertains to listing the converted project,database and schemas.

                            When you browse your DB2 connection, Is there anything out of the ordinary. Like a schema name with an empty string "" or anything like that.

                             

                            Regards,

                            Dermot.

                            SQL Developer Team.

                            • 12. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                              user12885184

                              Hi Dermot,

                               

                              We are able to use the same migration repository for migrating a different DB2 database. However, the one we intend to migrate is giving this error and looking at the error message we are unable to identify where to look for. Could you please provide some pointers in the case where same repository is able to create master_sql for one of the DB2 database but not for the other.

                               

                              P.S;- We do not have any empty string or "" in any of the schema names of the Database that we are trying to migrate.

                               

                              Thanks,

                              Neha

                              • 13. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                                Dermot ONeill-Oracle

                                Hi Neha,

                                 

                                The MigrationLog information leads me to think that there is an issue with the migration repository persistence of a project, catalog or schema. I cant be sure why that is. The only thing I could think of was a strange name (like empty string).

                                I would create a new migration repository (described above) to capture the problematic database only. Just to rule out any interference from another migration.

                                 

                                Regards,

                                Dermot.

                                SQL Developer Team.

                                • 14. Re: SQL Developer Migration Utility Error ( DB2 to Oracle)
                                  3008289

                                  Hi Dermot,

                                   

                                  As mentioned by you to select small schema from migration repository. but i do not see any options to select schema from database. I want to see te option where i can select the schema from database which needs to be migrated.

                                  Plase help me.

                                   

                                  Thanks

                                  Kishlay

                                  1 2 Previous Next