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

Last updated on MARCH 10, 2017

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/INDOMOFSAAI/Carga_de_Drivers_10258181832940033.xml
Created the user specific mapping xml name in localpath...localDestFile::::/d02/oracle/ofsaai/ftpshare/ExcelTemp/INDOMOFSAAI/Carga_de_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/Plantilla_Carga_Drivers_mayo_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.

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