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 AUGUST 26, 2020

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 INFODOM

ERROR
The following error is reported in the $FIC_HOME/xxxxxxxx/xxxxx/logs:

[ExportImportMetadata] : param:/home/.../.../.../Migration
[ExportImportMetadata] : param:EXPORT_FTP_INFODOM
[ExportImportMetadata] : param:<USER_ID>
[ExportImportMetadata] : param:en_US
[ExportImportMetadata] : param:INFODOM
[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 : <MIGRATION_PATH>
[ExportImportMetadata] : Properties File Path : <PROPERTIES_FILES_PATH>
[ExportImportMetadata] : EXPORTIMPORTPATH :: <EXPORTIMPORTPATH>
[ExportImportMetadata] : FIC_HOME ::/<FIC_HOME>
[LOG] Starting up.....
OBJECT_MIGRATION_XML: <USER_ID> <MIGRATION_CODE>EXPORT_FTP_INFODOM_
[ExportImportMetadata] : ::::::INFODOM:::::::
[ExportImportMetadata] : :::::::::::::
[ExportImportMetadata] : ::::::<USER_ID>:::::::
[ExportImportMetadata] : ::::::EXPORT:::::::
[ExportImportMetadata] : metadataDoc:[#document: null]
[ExportImportMetadata] :<INFODOM>
[ExportImportMetadata] : locale:en_US
[ExportImportMetadata] : userId:<USER_ID>
[ExportImportMetadata] : Doc to String:<...
filePath:<FILE_PATH>
URL :<URL>
VALIDATE_CERTIFICATE :N
Attempting to receive proxy port.
Received proxy port : <PROXY_PORT>
ERROR

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

Running the extraction ./extract_from_source.sh INFODOM, 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_INFODOM_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_INFODOM_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

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