OFSAA Excel Entity Mapping Hangs After Clicking Load Excel Metadata (Doc ID 1326459.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Checked for relevance on 27-Dec-2013.

Symptoms

On Data Entry Forms and Queries -> Excel Upload, when attempting to upload and excel file, the following error occurs:

ERROR

[REVELEUSLOG] Apr 29,11 16:53:04 : [NONE][FileTransferer] Closing Server [ofsaaserver.com:21] on exception
java.io.FileNotFoundException: RETR 01/ofsa72/ftpshare/STAGE/ExcelUpload/Templates/VB_STG_PRODUCTS_B_INTFF_v2.xls: 550 Failed to open file.

at com.iflex.fic.util.ftpService.FtpClient.readReply(FtpClient.java:186)
at com.iflex.fic.util.ftpService.FtpClient.issueCommand(FtpClient.java:140)
at com.iflex.fic.util.ftpService.FtpClient.openDataConnection(FtpClient.java:243)
at com.iflex.fic.util.ftpService.FtpClient.get(FtpClient.java:430)
at com.iflex.fic.util.ftpService.fileTranferer.getFileFromRemoteServer(fileTranferer.java:725)
at com.iflex.fic.util.ftpService.fileTranferer.getFileFromRemoteServer(fileTranferer.java:682)
at com.iflex.fic.etl.excelUpload.UtilFunctions.getTemplatePath(UtilFunctions.java:337)
at com.iflex.fic.etl.excelUpload.UtilFunctions.getJSONofHeader(UtilFunctions.java:99)
at jsp_servlet._excelupload.__ajaxservice._jspService(__ajaxservice.java:97)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.iflex.fic.filters.FilterServlet.doFilter(FilterServlet.java:747)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.iflex.fic.filters.EncodingFilter.doFilter(EncodingFilter.java:88)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

STEPS

The issue can be reproduced at will with the following steps:
1. Go to UMM -> Data Entry Forms and Queries -> Excel Upload will open a new window
2. Excel Entities -> Excel-Entity Mappings - Create a new mapping
3. Give a name and Browse and select an excel file
4. Click on Load Excel Metadata
5. The below messages pop-up


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