FTP Metadata Migration 6.1 to 8.0 Fails with Time-out! Please contact your system administrator. Error (Doc ID 2162928.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.0.3 to 8.0.0 [Release 6 to 8]
Oracle Solaris on SPARC (64-bit)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

After executing all the pre requisites stated in the FTP Metadata Migration User Guide and upgrading to OFSAAI 7.3.5.1.7, the migration fails with Error. 

Run the extraction command:
./extract_from_source.sh INFODOMMAIN

ERROR
The following error is reported in the $FIC_HOME/reveleus/utility/Migration/logs:

[ExportImportMetadata] : param:/home/misnh5/reveleus/utility/Migration
[ExportImportMetadata] : param:EXPORT_FTP_INFODOMMAIN_2016.06.02-20:07:47
[ExportImportMetadata] : param:ADMIN
[ExportImportMetadata] : param:en_US
[ExportImportMetadata] : param:INFODOMMAIN
[ExportImportMetadata] : param:
[ExportImportMetadata] : param:EXPORT
[ExportImportMetadata] : param:FTP
[ExportImportMetadata] : param:N
[ExportImportMetadata] : param:N
[ExportImportMetadata] : param:Y
[ExportImportMetadata] : param:Y
[ExportImportMetadata] : param:12,5,14,1,136
[ExportImportMetadata] : Migration Configuration Path : /home/misnh5/reveleus/utility/Migration/conf
[ExportImportMetadata] : Properties File Path : /home/misnh5/reveleus/utility/Migration/conf/migration.properties
[ExportImportMetadata] : EXPORTIMPORTPATH :: /home/misnh5/reveleus/utility/Migration
[ExportImportMetadata] : FIC_HOME ::/home/misnh5/reveleus
[LOG] Starting up.....
OBJECT_MIGRATION_XML: ADMIN <MIGRATION_CODE>EXPORT_FTP_INFODOMMAIN_2016.06.02-20:07:47 en_US INFODOMMAIN EXPORT FTP N Y <RETAIN_IDS>Y
[ExportImportMetadata] : ::::::INFODOMMAIN:::::::
[ExportImportMetadata] : :::::::::::::
[ExportImportMetadata] : ::::::ADMIN:::::::
[ExportImportMetadata] : ::::::EXPORT:::::::
[ExportImportMetadata] : metadataDoc:[#document: null]
[ExportImportMetadata] : infodOM:INFODOMMAIN
[ExportImportMetadata] : locale:en_US
[ExportImportMetadata] : userId:ADMIN
[ExportImportMetadata] : Doc to String:<...
filePath:/home/misnh5/reveleus/utility/Migration/conf/WSMigration.properties
URL :http://xsnoahd05:8080/ofsaa/offlineMigration?wsdl
VALIDATE_CERTIFICATE :N
Attempting to receive proxy port.
Received proxy port : JAX-WS RI 2.1.6 in JDK 6: Stub for http://xsnoahd05:8080/ofsaa/offlineMigration
ERROR

The preparation scripts worked fine:
./prepare_source.sh INFODOMMAIN

Running the extraction ./extract_from_source.sh INFODOMMAIN, the following log output on the migration-kit log folder:

...

[2016.06.02 - 20:07:46 PM CEST] ======= Extracting application metadata =======
[2016.06.02 - 20:07:46 PM CEST] Extracting AMHM Dimension-Ids ...
[2016.06.02 - 20:07:46 PM CEST] Cleaning older instance of dim_id.sql
[2016.06.02 - 20:07:46 PM CEST] extracting dimension ids from source.

CALL RESET_DIM_ID(5,'CUSTOMER_IFRS_ID','CUSTOMER_IFRS_ID')
/
...
CALL RESET_DIM_ID(709,'CUSTOMER_ID','Customer')
/

[2016.06.02 - 20:07:46 PM CEST] Script generated.
[2016.06.02 - 20:07:46 PM CEST]
[2016.06.02 - 20:07:46 PM CEST] Preparing AMHM-data for export...

Package created.


Package body created.

No errors.
Preparing dimension: 0
...
Preparing dimension: 709
Preparing dimension: 729

Call completed.

[2016.06.02 - 20:07:47 PM CEST] Extracting relevant OFSAAI Artifacts [12,5,14,1,136].
Exporting Metadata ......................................
Migration triggered Successfully
See migration.log for output
[2016.06.02 - 20:07:49 PM CEST] [1/10] Status of 'EXPORT_FTP_INFODOMMAIN_2016.06.02-20:07:47' :[Init...]; Checking again in 10 seconds.
...
[2016.06.02 - 20:09:10 PM CEST] [9/10] Status of 'EXPORT_FTP_INFODOMMAIN_2016.06.02-20:07:47' :[Init...]; Checking again in 10 seconds.
[2016.06.02 - 20:09:20 PM CEST] Time-out! Please contact your system administrator.
[2016.06.02 - 20:09:20 PM CEST] aborting...

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