My Oracle Support Banner

Excel Upload Hangs With Spinning Hourglass After Clicking 'Upload' Button (Doc ID 2475628.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Oracle Financial Services Profitability Management - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 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 8.0.5, in an environment where the web server is on a separate server from the application, in the Excel Utilities > Excel Upload user interface, when you select an Excel File, select a Mapping, and click on the 'Upload' button, the process hangs with a spinning hourglass:

 

The Excel Upload never completes.

Additionally, the nohup.out created when starting the web server (ex. Weblogic) contains the following error:

ClsUCntETLExcelLoadingOne.getExcelMapping......APP and WEB servers are different,so will ftp the files from app ftpshare to web localpath
[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
<Aug 23, 2018 9:45:14 AM CDT> <Error> <HTTP> <BEA-101020> <[ServletContext@443656345[app:OFSAA module:/OFSAA path:null spec-version:3.0]] Servlet failed with an Exception
java.lang.RuntimeException: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "sftp://<ftp user>:***@<app server name>/".
       at com.iflex.fic.util.ftpService.SFTPUtil.downloadFile(SFTPUtil.java:564)
       at com.iflex.fic.util.ftpService.fileTranferer.getFileFromRemoteServer(fileTranferer.java:588)
       at com.iflex.fic.util.ftpService.fileTranferer.getFileFromRemoteServer(fileTranferer.java:524)
       at com.iflex.fic.etl.excelUpload.ClsUCntETLExcelLoadingOne.getExcelMapping(ClsUCntETLExcelLoadingOne.java:1660)
       at jsp_servlet._excelupload.__filehandler._jspService(__filehandler.java:182)
Truncated. see log file for complete stacktrace
Caused By: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "sftp://<ftp user>:***@<app server name>/".
       at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:107)
       at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:103)
       at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)
       at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:65)
       at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:693)
Truncated. see log file for complete stacktrace
Caused By: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "<app server name>".
       at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:230)
       at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:96)
       at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:103)
       at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)
       at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:65)
Truncated. see log file for complete stacktrace
Caused By: com.jcraft.jsch.JSchException: Algorithm negotiation fail
       at com.jcraft.jsch.Session.receive_kexinit(Session.java:529)
       at com.jcraft.jsch.Session.connect(Session.java:291)
       at com.jcraft.jsch.Session.connect(Session.java:154)
       at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:226)
       at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:96)
Truncated. see log file for complete stacktrace

However, you can successfully execute SFTP from the web server and connect to the app server.  You do not know why the SFTP to the app server cannot connect.

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.