We are migrating DB2 to Oracle and getting error as below:
DB2:
Database version: DSN11015
Driver: IBM DB2 JDBC
Driver version: 3.8.35
Oracle:
Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Driver: Oracle JDBC driver
Driver version: 11.2.0.2.0
Error1 : After I click the finish button, I see error as: "Migration Actions have Failed. Check the migration report for details.Capture Classic Capture. ORA-01400: Cannot insert null into MD_PROJECTS.ID"
I found the table MD_PROJECTS in the repository is having a primary key on column MD_PROJECTS.ID. I dropped the column and associates foreign key fro other tables. Then I got below weror when I click the finish button. Can someone please help and guide ?
Error2 :Java error received :
- java.util.NoSuchElementException
at oracle.dbtools.metadata.persistence.PersistableObjectIterator.next(PersistableObjectIterator.java:131)
at oracle.dbtools.migration.workbench.core.navigator.nodes.MigrationProjectsFolderNode.loadChildren(MigrationProjectsFolderNode.java:134)
at oracle.dbtools.migration.workbench.core.navigator.nodes.AsynchronousMigrationNavigatorTreeNode$1.doWorkImpl(AsynchronousMigrationNavigatorTreeNode.java:47)
at oracle.dbtools.raptor.navigator.model.NavigatorQueryTask.doWork(NavigatorQueryTask.java:57)
at oracle.dbtools.raptor.navigator.model.NavigatorQueryTask.doWork(NavigatorQueryTask.java:17)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)