Fatal Error for Mappers Exporting Alias:::OPER_FAILED Failed Migrating Object Importing During FTP Migration to 8.0 (Doc ID 2267253.1)

Last updated on JUNE 01, 2023

Applies to:

Symptoms

When running the migration scripts for 6.1.1.1 to 8.0 version, while running the ./import_into_target.sh script, the import is failing with errors:

ERROR

[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [FUSIONSUBSYSTEMSSERVICEPROVIDER]Error in Exporting Alias:::OPER_FAILED
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [UMMOFFLINEMIGRATIONSERVICE]Cargo:[SC:0][ST:0][SST:0][Oper:0][Version:0][EF:true][D:null][S:null][U:null][PT:0][P:nullOPER_FAILED]
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [IMPORTMIGRATORTHREAD]Migration Return Value..-1
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [DBUTIL]Failed Migrating Object..[id:1437704405977,name:1437704405977,type:136,Source Folder:,Target Folder:null]
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [DBUTIL]Fail on Error is True. So migration stopped..[id:1437704405977,name:1437704405977,type:136,Source Folder:,Target Folder:null]
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [DBUTIL]Preparing to Migrate Object Offline..[id:1437712312336,name:1437712312336,type:136,Source Folder:,Target Folder:null]
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [DBUTIL]Fatal Error Occured. Stoping the Import Process.[id:1437712312336,name:1437712312336,type:136,Source Folder:,Target Folder:null]
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [DBUTIL]Migration Failed Because of Fatal Error
[FUSIONSUBSYSTEMS] Mar 28,17 17:45:13 : [MIGRATIONINTERNALSERVICECLIENT]query::::UPDATE REV_MIG_EXECUTION SET STATUS = ?, END_DATE = SYSDATE WHERE RUN_ID = ?

The issue can be reproduced at will with the following steps:
1. Run the import script

Changes

Upgrade to FTP 8.0 from 6.1.1.1.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.