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:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 to 8.0.5 [Release 7 to 8]Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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
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 |