'Unable to connect to FICServer' Error Opening Data Entry Form (DEFQ) Containing CLOB Column (Doc ID 2103204.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when you open a Data Entry Form created for a table that has a column defined as CLOB, the Form fails to load and the following error appears:
 
[DeFi] Exception
[DirectCommImpl] Unable to connect to FICServer, retry count exceeded

See example below:

A similar error exists in the RevAppserver.log from the web server:

[REVELEUSLOG] Jan 20,16 14:57:19 : [NONE][DeFi] Error at FormDataManager.provideData(): java.lang.Exception: [DirectCommImpl] Unable to connect to FICServer, retry count exceeded
java.lang.Exception: [DirectCommImpl] Unable to connect to FICServer, retry count exceeded
    at com.iflex.fic.ficml.comm.DirectCommImpl.getResponseFromFICServer(DirectCommImpl.java:178)
    at com.iflex.fic.ficml.comm.DirectCommImpl.processRequest(DirectCommImpl.java:91)
    at com.iflex.fic.client.comm.ClientCommunication.requestService(ClientCommunication.java:347)
    at com.iflex.fic.service.ServiceMaster.provideService(ServiceMaster.java:50)
    at com.iflex.fic.defi.util.CommonFunctions.executeQuery(CommonFunctions.java:529)
    at com.iflex.fic.defi.FormDataManager.provideData1(FormDataManager.java:5757)
    at com.iflex.fic.defi.FormDataManager.provideData(FormDataManager.java:213)
    at com.iflex.fic.defi.DefiGateway.getViewData(DefiGateway.java:80)
    at jsp_servlet._defi._dataentry.__displaypage._jspService(__displaypage.java:2937)

 As a result of the error, the form fails to load in the Data Entry screen.

Cause

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