Archive Metadats Gets Operation Failed for Extracts and/or Files

(Doc ID 2115483.1)

Last updated on MARCH 11, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, in Unified Metadata Manager, when you run the Metadata Restore > Archive Metadata utility, it fails while exporting the ETL files. The following messages appear in the Status window:

Extracts and/or Files
Operation Failed

Example:

The following message exists in the ImportExport.log in the web server's OFSAA log directory:

Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO][WriteMasterXML] Exporting : ETL
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO]ETL Details : ApplName: OELAPPsource NAme OELSTGdefn Name: T2T_RETIREMENT_ACCOUNTS
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO]The ETL definition object objCompleteDefinition is null
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO]Error. Continuing by ignoring this Definition....
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO][ETLMetadataExportImportHandler]Error has occurred while exporting ETL Definitions
 No of definitions failed=1
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO][WriteMasterXML] Adding ETL result to hashtable
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO][WriteMasterXML] Result of export  {21=OPER_FAIL}
Fri Mar 11 03:38:34 IST 2016[EXPORT][EXPORT_OELPMINFO_testdebug3_OELPMINFO][ExportHandler] Result for: 21 is :OPER_FAIL


You do not understand why the extract fails to export.

Important: To get the messages listed above in the ImportExport.log, you must have logging set to debug in ExportLog4jConfig.xml.  See instructions in <Document 1630609.1> "How to Enable Debugging for Restore Metadata / Archive Metadata Issues".

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