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

Last updated on JUNE 20, 2023

Applies to:

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

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