My Oracle Support Banner

[4272] Error in Excel Upload and java.lang.NullPointerException Running the Excel Upload (Doc ID 2062152.1)

Last updated on JANUARY 10, 2022

Applies to:

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



Symptoms

On OFSAAI 7.3.4.2.0, Excel Upload for a single excel mapping is failing with the following errors on screen:

ERROR
[4272] Error in Excel Upload

Additional errors are found in the nohup.out of the Web Server log:

local path-->/d02/oracle/ofsaai/ftpshare/
User Specific mapping xml name...localDestFile::::/d02/oracle/ofsaai/ftpshare/ExcelTemp/INFODOM/Drivers_10258181832940033.xml
Created the user specific mapping xml name in localpath...localDestFile::::/d02/oracle/ofsaai/ftpshare/ExcelTemp/INFODOM/Drivers_10258181832940033.xml
ClsUCntETLExcelLoadingOne.getExcelMapping......APP and WEB servers are same,so will directly copy the files from app ftpshare to web localpath
before fetching excel mapping
after fetching the excel mapping cargo-- in file handler
local path-->/d02/oracle/ofsaai/ftpshare/
local path-->/d02/oracle/ofsaai/ftpshare/
local path-->/d02/oracle/ofsaai/ftpshare/
Uploading excel Name/d02/oracle/ofsaai/ftpshare/ExcelTemp/Templates/Drivers_OBS.xls
java.lang.NullPointerException
at com.iflex.fic.etl.excelUpload.ClsUCntETLExcelLoadingOne.loadExcelData(ClsUCntETLExcelLoadingOne.java:330)
at jsp_servlet._excelupload.__filehandler._jspService(__filehandler.java:205)
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:818)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at com.iflex.fic.filters.EncodingFilter.doFilter(EncodingFilter.java:86)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
exception is::null


Other Excel Uploads are working without issue. No Excel Upload log file is generated.

The issue can be reproduced at will with the following steps:
1. Run Excel Upload for a single mapping.

Changes

 

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
Changes
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.