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

(Doc ID 2103204.1)

Last updated on NOVEMBER 16, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

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

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