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 JULY 07, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.1.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.1.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms