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

Last updated on MAY 03, 2024

Applies to:

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

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