12 Replies Latest reply on Aug 8, 2014 7:47 PM by kalibrain

    Sybase 15 to Oracle Migration Error

    kalibrain

      I have been working on migrating our Sybase ASE 15 database to Oracle. I followed every instructions on Oracle website using SQL Developer Migration Tool. Once the migration starts, I keep getting this error for some reason that I couldn't figure out. Here is the XML file for my error.

       

      <?xml version="1.0" encoding="windows-1252" standalone="no"?>
      <log>
      <record>
        <date>2014-07-31T12:26:27</date>
        <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
        <level>SEVERE</level>
        <class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>
        <message>Capture
      Enterprise Capture
      Capture failed.  Refer to MIGRLOG table in the repository for details</message>
        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doOnlineEnterpriseCapture(FullMigrateTask.java:758)</param>
        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doCapture(FullMigrateTask.java:601)</param>
        <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:400)</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@caaa1c7</param>
        <exception>
          <message>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Capture
      Enterprise Capture
      Capture failed.  Refer to MIGRLOG table in the repository for details</message>
          <frame>
            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
            <line>758</line>
          </frame>
          <frame>
            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
            <line>601</line>
          </frame>
          <frame>
            <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
            <line>400</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>2014-07-31T12:26:27</date>
        <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
        <level>WARNING</level>
        <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
        <message>Error:ORA-06550: line 1, column 14:
      PLS-00201: identifier 'SYB12ALLPLATFORM.STAGECAPTURE' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      : FAILED : Database Migration : FAILED</message>
        <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@434de9ab</param>
      
      
      </record>
      </log>
      
        • 1. Re: Sybase 15 to Oracle Migration Error
          thatJeffSmith-Oracle

          Capture failed.  Refer to MIGRLOG table in the repository for details

          • 2. Re: Sybase 15 to Oracle Migration Error
            kalibrain

            Hi Jeff,

             

            I forgot to mention about that. I already checkhed MIRGLOG table and there is no record at all.

             

            MIGRLOG.PNG

            • 3. Re: Sybase 15 to Oracle Migration Error
              thatJeffSmith-Oracle

              Is the SYB12ALLPLATFORM package in the repository owner schema and compiled w/o errors?

              • 4. Re: Sybase 15 to Oracle Migration Error
                kalibrain

                How can I make sure it is compiled without any errors?

                • 5. Re: Sybase 15 to Oracle Migration Error
                  thatJeffSmith-Oracle

                  SQL Developer will tell you it's compilation status and if there are any errors. Open it in the Connection/Database tree.

                  • 6. Re: Sybase 15 to Oracle Migration Error
                    kalibrain

                    There is no error or I don't see any errors in the Connection/Database tree.

                     

                    Connection-Database Tree.PNG

                    • 7. Re: Sybase 15 to Oracle Migration Error
                      thatJeffSmith-Oracle

                      Your package tree node is null - there are no packages. That's why the migration won't run, you have missing code in the migration repository. Try installing it again, and look for errors as it runs.

                      1 person found this helpful
                      • 8. Re: Sybase 15 to Oracle Migration Error
                        kalibrain

                        I don't know why packages folder are empty. Anyway I created new migration repository and associated it. Unfortunately, there is no package inside folder. Do you want me to install sql developer again? or something else? This is the first time I am using this program. I am sorry for the dumb questions

                        • 9. Re: Sybase 15 to Oracle Migration Error
                          Dermot ONeill-Oracle

                          Hi,

                           

                          My guess is the user you have tried to install/associate the migration repository with does not have suitable privileges.

                           

                          Best to start again to see if we can capture the issue.

                          First create a brand new user in Oracle for the migration repository. Give it the correct privileges

                          >Connect to SYS  or  SYSTEM and run the following commands

                           

                          CREATE USER migrep identified by migrep;

                          GRANT connect, resource, create view, create materialized view to migrep;

                          ALTER USER migrep quota unlimited on USERS;

                           

                          Now using SQL Developer create a connection to  MIGREP and associate the migration repository with this connection.

                          Check if the migration repository packages have been created and are compiled valid. Worth checking the package bodies are valid as well.

                          repo_packages.jpg

                           

                          Hopefully it was just a privilege you were missing.

                          Regards,

                          Dermot.

                          SQL Developer Team.

                          • 10. Re: Sybase 15 to Oracle Migration Error
                            kalibrain

                            Thank you for pointing out privileges. Now I have all packages. Unfortunately, when I start migration process, I keep getting the same error. I have added MIGRLOG table report. Please take a look at it and give me some suggestions.

                             

                            <?xml version='1.0' encoding='Cp1252' ?>
                            <RESULTS>
                            <ROW>
                            <COLUMN NAME="ID"><![CDATA[98501]]></COLUMN>
                            <COLUMN NAME="PARENT_LOG_ID"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="LOG_DATE"><![CDATA[05-AUG-14 05.15.01.304000000 PM]]></COLUMN>
                            <COLUMN NAME="SEVERITY"><![CDATA[900]]></COLUMN>
                            <COLUMN NAME="LOGTEXT"><![CDATA[Error:ORA-06510: PL/SQL: unhandled user-defined exception
                            ORA-06512: at "MIGREP.SYB12ALLPLATFORM", line 2339
                            ORA-06512: at line 1
                            : FAILED : Database Migration : FAILED]]></COLUMN>
                            <COLUMN NAME="PHASE"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="REF_OBJECT_ID"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="REF_OBJECT_TYPE"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="CONNECTION_ID_FK"><![CDATA[]]></COLUMN>
                            </ROW>
                            <ROW>
                            <COLUMN NAME="ID"><![CDATA[59801]]></COLUMN>
                            <COLUMN NAME="PARENT_LOG_ID"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="LOG_DATE"><![CDATA[05-AUG-14 05.15.00.000000000 PM]]></COLUMN>
                            <COLUMN NAME="SEVERITY"><![CDATA[2]]></COLUMN>
                            <COLUMN NAME="LOGTEXT"><![CDATA[ProcessFkConstraints: Unable process referenced constraint details [ORA-01403: no data found
                            : ORA-06512: at "MIGREP.SYB12ALLPLATFORM", line 1293
                            ] svrid:dbid:objid:v_refRow.ref_table_id_gen_fk:v_colOrder:v_keys(v_colOrder): 51:101:3901::1:1]]></COLUMN>
                            <COLUMN NAME="PHASE"><![CDATA[Capture]]></COLUMN>
                            <COLUMN NAME="REF_OBJECT_ID"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="REF_OBJECT_TYPE"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="CONNECTION_ID_FK"><![CDATA[51]]></COLUMN>
                            </ROW>
                            <ROW>
                            <COLUMN NAME="ID"><![CDATA[98451]]></COLUMN>
                            <COLUMN NAME="PARENT_LOG_ID"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="LOG_DATE"><![CDATA[05-AUG-14 05.15.01.300000000 PM]]></COLUMN>
                            <COLUMN NAME="SEVERITY"><![CDATA[1000]]></COLUMN>
                            <COLUMN NAME="LOGTEXT"><![CDATA[Capture
                            Enterprise Capture
                            Capture failed. Refer to MIGRLOG table in the repository for details]]></COLUMN>
                            <COLUMN NAME="PHASE"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="REF_OBJECT_ID"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="REF_OBJECT_TYPE"><![CDATA[]]></COLUMN>
                            <COLUMN NAME="CONNECTION_ID_FK"><![CDATA[]]></COLUMN>
                            </ROW>
                            </RESULTS>

                             

                            Thanks.

                            • 11. Re: Sybase 15 to Oracle Migration Error
                              Ashish Neo Raina

                              I faced a similar issue which was resolved by using SQL developer v4.0.0 instead of v4.0.2.

                              • 12. Re: Sybase 15 to Oracle Migration Error
                                kalibrain

                                I will test it out asap. I hope it will solve my problem too. Thanks...