My Oracle Support Banner

No Dump Files Appear in the Import Definition Screen Drop Down for Import Objects (Doc ID 2779348.1)

Last updated on MAY 27, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On OFSAA 8.1.1, no dump files appear in the Import Definition screen for Import Objects. Export object is successful and dump file is getting created. However, when trying to define import object, none of the dump files copied to the <FTPSHARE>/ObjectMigration/metadata/restore folder are visible in the drop down. This is a single tier application setup.  The drop down list for available dump files shows the following error:

ERROR
No matches found


Additionally, the following error is seen in the FUSIONSUBSYSTEMSService.log:

ERROR
[30-04-21 19:24:10,052 GMT PM] [ERROR] [WEB] [AMHM] [NA] [MIGRATIONHANDLER]
java.lang.NullPointerException
at com.ofs.reveleus.migration.service.MigrationUIService.getObjectTypeListForDump(MigrationUIService.java:109)
at com.ofs.reveleus.migration.mgmt.MigrationHandler.handleAction(MigrationHandler.java:267)
at com.ofs.reveleus.migration.core.MigrationServlet.service(MigrationServlet.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)


The WebLogic server.out file shows the following error:

ERROR
exit loadActionFunctionMap
actionToFunctionMap:{NEW=FU_MIG_ADD, DELETE=FU_MIG_DEL, EDIT=FU_MIG_EDT, COPY=FU_MIG_CPY, SAVE=FU_MIG_ADD, MIGRATE=FU_MIG_RUN, VIEW=FU_MIG_VIW, CANCEL_MIGRATE=FU_MIG_CRN}, userid:,dbAction:null
GlobalConstants.HOME_PAGE:HOMEPAGEcondition:false
in else part of actiontype check
functioncode:null
java.lang.NullPointerException
at com.iflex.fic.util.ftpService.fileTranferer.getContents(fileTranferer.java:1445)
at com.ofs.reveleus.migration.service.MigrationUIService.getDumpsList(MigrationUIService.java:350)
at com.ofs.reveleus.migration.mgmt.MigrationHandler.handleAction(MigrationHandler.java:399)
at com.ofs.reveleus.migration.core.MigrationServlet.service(MigrationServlet.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)


Have set 775 permission for all dump files under restore folder.  Issue appears to be related to setup of Load Balancer in WEB_SERVER_INFO as it works after reverting:

Load Balancer Configuration:
OFSAA_Server_IP_Address=<OFSAASERVER_HOST>
Web_Server_IP_Address=<LOADBALANCER_HOST> <<< NOTE: now Web Server is Load Balancer
Servlet_Port=<PORT>
SFTP=-1 ...no SFTP since same server / same operating system user.

NOTE: This configuration fails during import with FTP/SFTP related errors

Reverted Configuration:
OFSAA_Server_IP_Address=<OFSAASERVER_HOST>
Web_Server_IP_Address=<OFSAASERVER_HOST>
Servlet_Port=<WEBSERVER_PORT>
SFTP=-1 ...no SFTP since same server /same operating system user.

NOTE: This configuration works during import of object DMP.


The issue can be reproduced at will with the following steps:
1. Navigate: Common Object Maintenance -> Object Administration -> Object Migration
2. Export Objects
3. Create a new outline, add object and Export
4. Copy generated.dmp file to ftpshare/ObjectMigration/metadata/restore folder.
5. Navigate: Common Object Maintenance -> Object Administration -> Object Migration -> Import Objects
6. Click Add for new Import Definition
7. List of values for Dump File drop down shows "No matches found"

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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