FTP Metadata Migration 6.1 to 8.0 Fails with Time-out! Please contact your system administrator. Error

Last updated on JUNE 09, 2017

Applies to:

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