I am attempting to migrate a SQL Server 2017 db to Oracle 12.2. I am using Developer 19.4. I am at the point that the migration commences and runs for a while and then eventually errors with this message :
But I don't see a report, per se. If I click on the Migrations Project folder, there are a series of tabs that all raise the same error:
The XML log does contain an error. But how to resolve? The SQL Server user is sa and the Oracle repository user was eventually granted all privileges in an attempt to get it past the initial failures of permission problems.
<log>
<record>
<date>2020-06-08T15:29:43</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</message>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doOnlineEnterpriseCapture(FullMigrateTask.java:765)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doCapture(FullMigrateTask.java:608)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:407)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:321)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:154)</param>
<param>oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)</param>
<param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>
<param>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)</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:1149)</param>
<param>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)</param>
<param>java.lang.Thread.run(Thread.java:748)</param>
<param>oracle.dbtools.migration.workbench.core.logging.LogInfo@2d692905</param>
<exception>
\<message>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Capture
Enterprise Capture
Capture failed</message>
\<frame>
\<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask\</class>
\<line>765\</line>
\</frame>
\<frame>
\<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask\</class>
\<line>608\</line>
\</frame>
\<frame>
\<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask\</class>
\<line>407\</line>
\</frame>
\<frame>
\<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask\</class>
\<line>321\</line>
\</frame>
\<frame>
\<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask\</class>
\<line>154\</line>
\</frame>
\<frame>
\<class>oracle.dbtools.raptor.backgroundTask.RaptorTask\</class>
\<line>199\</line>
\</frame>
\<frame>
\<class>java.util.concurrent.FutureTask\</class>
\<line>266\</line>
\</frame>
\<frame>
\<class>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask\</class>
\<line>702\</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>1149\</line>
\</frame>
\<frame>
\<class>java.util.concurrent.ThreadPoolExecutor$Worker\</class>
\<line>624\</line>
\</frame>
\<frame>
\<class>java.lang.Thread\</class>
\<line>748\</line>
\</frame>
</exception>
</record>
<record>
<date>2020-06-08T15:29:43</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 'SS2K5ALLPLATFORM.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@5c147065</param>
</record>
</log>
Any advice would be appreciate. I've spent a lot of time trying to get this to work and have nothing to show for it at this point.