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