Error Opening File Extract '[4528] Could Not Retrieve the Definition File. FIC Server May Not Be Running." (Doc ID 1608121.1)

Last updated on APRIL 28, 2023

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, you cannot open a File to Table (F2T) extract in Data Integrator Framework > Warehouse Designer > File Extracts.  When you click on the extract name in the Data Integrator window, an error with the following message appears:

[4528] Could not retrieve the Definition File. FIC Server may not be running.

Followed by:

[9294] Failed to fetch data from Server [4528] Could not retrieve the
definition file. Fic Server may not be running.

Errors also exist in the ETLService.log in $FIC_APP_HOME/common/FICServer/logs.  For example:

[ETLLOG] Dec 6,13 15:41:05 : [CLSUCNTETLDEFINITION]getDefinition Definition file name :/<ftpshare>/STAGE/<data source>/CASA.xml
[ETLLOG] Dec 6,13 15:41:05 : [CLSUUTLETLXMLBASE]FileNotFoundException message :/<ftpshare>/STAGE/<data source>/CASA.xml (No such file or directory)
[ETLLOG] Dec 6,13 15:41:05 : [CLSUUTLETLXMLBASE]
java.io.FileNotFoundException: /<ftpshare>/STAGE/<data source>/CASA.xml (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:106)
at java.io.FileInputStream.(FileInputStream.java:66)
at com.iflex.fic.etl.util.ClsUUtlETLXmlBase.getDocument(ClsUUtlETLXmlBase.java:102)
at com.iflex.fic.etl.extraction.ClsUCntETLDefinition.getDefinition(ClsUCntETLDefinition.java:438)
at com.iflex.fic.etl.extraction.ClsUCntETLMapping.getMappingDefintionEntity(ClsUCntETLMapping.java:1031)
at com.iflex.fic.etl.util.ClsUUtlETLExtractionController.handleRequest(ClsUUtlETLExtractionController.java:195)
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:202)

[ETLLOG] Dec 6,13 15:41:05 : [CLSUCNTETLDEFINITION][ETL-SOURCE]Could not fetch the Definition File.FIC Server may not be running.

or

[ETLLOG] Dec 10,13 11:37:24 : [CLSUCNTETLDEFINITION][ETL-DEFINITION] MAPPED IN INFODOMS::1
[ETLLOG] Dec 10,13 11:37:24 : [CLSUUTLETLXMLBASE]
java.lang.NullPointerException
    at org.apache.xerces.dom.ParentNode.nodeListItem(Unknown Source)
    at org.apache.xerces.dom.ParentNode.item(Unknown Source)
    at com.iflex.fic.etl.util.ClsUUtlETLXmlHelper.runNodeList1(ClsUUtlETLXmlHelper.java:243)
    at com.iflex.fic.etl.util.ClsUUtlETLXmlBase.selectNodeListWithAtts(ClsUUtlETLXmlBase.java:293)
    at com.iflex.fic.etl.util.ClsUUtlETLRepositoryHandler.getALLMappedInfoDoms(ClsUUtlETLRepositoryHandler.java:1458)
    at com.iflex.fic.etl.extraction.ClsUCntETLDefinition.getMappedColumns(ClsUCntETLDefinition.java:626)
    at com.iflex.fic.etl.extraction.ClsUCntETLDefinition.getDefinition(ClsUCntETLDefinition.java:441)
    at com.iflex.fic.etl.util.ClsUUtlETLExtractionController.getDefinitionProperties(ClsUUtlETLExtractionController.java:365)
    at com.iflex.fic.etl.util.ClsUUtlETLExtractionController.handleRequest(ClsUUtlETLExtractionController.java:124)
    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:202)

The errors prevent you from editing the file extract.

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.