[9294] Failed to fetch data from Server and [3124] Error while processing request Errors Opening Seeded T2T Extracts

(Doc ID 2009273.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Data Ingestion / Data Integration / Data Management Tools
Table to Table (T2T)
Data Mapping
Mapping Extracts

Symptoms

On OFSAAI 8.0, when attempting to open installed T2T extracts, the following errors occur:


ERROR
[9294] Failed to fetch data from Server [3124] Error while processing request



The following error can additionally be found in the nohup.out in the $FIC_APP_HOME/common/FICServer/bin directory:

java.lang.NullPointerException
at com.iflex.fic.etl.extraction.ClsUCntETLDefinition.getMappedColumns(ClsUCntETLDefinition.java:630)
at com.iflex.fic.etl.extraction.ClsUCntETLDefinition.getDefinition(ClsUCntETLDefinition.java:441)
at com.iflex.fic.etl.util.ClsUUtlETLExtractionController.getDefinitionProperties(ClsUUtlETLExtractionController.java:400)
at com.iflex.fic.etl.util.ClsUUtlETLExtractionController.handleRequest(ClsUUtlETLExtractionController.java:132)
at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:107)
at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:211)
at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:297)
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:201)

More errors can be found in the Web Server ETLService.log:

[ETLLOG] Apr 28,15 11:27:49 : [CLSUETLEXTRACTIONROUTER]Fetching app-src tree for the application :: PFT_APP
[ETLLOG] Apr 28,15 11:27:49 : [CLSUETLEXTRACTIONROUTER]Fetching source details for :: PFT_APP_STG
[ETLLOG] Apr 28,15 11:27:49 : [CLSUETLENTITYSOURCE]Cargo object returned successfully.
[ETLLOG] Apr 28,15 11:27:49 : [STACK TRACE]
java.lang.NullPointerException
at com.iflex.fic.etl.extraction.entity.ClsUETLEntitySource.showSourceDetails(ClsUETLEntitySource.java:509)
at com.iflex.fic.etl.extraction.entity.ClsUETLEntitySource.fetchDetails(ClsUETLEntitySource.java:539)
at com.iflex.fic.etl.commons.ClsUETLExtractionRouter.sourceScreenHandler(ClsUETLExtractionRouter.java:162)
at com.iflex.fic.etl.servlet.ETLExtractionServlet.processRequest(ETLExtractionServlet.java:117)
at com.iflex.fic.etl.servlet.ETLExtractionServlet.doPost(ETLExtractionServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)


The issue can be reproduced at will with the following steps:
Connected to: INFODOME

Data Management Tools -> PFT_APP -> PFT_APP_STG -> T2T_CASA

Changes

Additional application installation.

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