My Oracle Support Banner

Account Activity Transaction Fails Randomly with Screen Error - "The system has encountered an error while processing the request" and And Logs Error - '' java.sql.SQLException: The connection is closed''. (Doc ID 2743363.1)

Last updated on JANUARY 15, 2021

Applies to:

Oracle FLEXCUBE Direct Banking - Version DB 12.0.2 to DB 12.0.3 [Release DB 12]
Information in this document applies to any platform.

Symptoms

Sometimes Account Activity transaction doesn't fetch records for the selected criteria and following errors occur.

ERROR ON SCREEN
-----------------------
The system has encountered an error while processing the request.

ERROR IN LOGS
-----------------------
java.sql.SQLException: The connection is closed: The connection is closed
    at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:473)
    at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:457)
    at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:255)
    at com.sun.proxy.$Proxy103.prepareStatement(Unknown Source)
    at com.iflex.fcat.xjava.jdbc.JDBCEngine.executeUpdate(JDBCEngine.java:409)
    at com.iflex.fcat.services.apps.endpoints.AccountActivityService.inquireListOfTransaction(AccountActivityService.java:351)

java.sql.SQLException: The connection is closed: The connection is closed
    at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:473)
    at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:457)
    at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:255)
    at com.sun.proxy.$Proxy103.setAutoCommit(Unknown Source)
    at com.iflex.fcat.services.hostinterface.HostAdapterHelper.logRequestAuditInfo(HostAdapterHelper.java:642)
    at com.iflex.fcat.services.hostinterface.HostAdapterManager.logRequestData(HostAdapterManager.java:756)
    at com.iflex.fcat.services.hostinterface.HostAdapterManager.processRequest(HostAdapterManager.java:420)
    at com.iflex.fcat.services.apps.endpoints.AccountActivityService.inquireAccountActivity(AccountActivityService.java:438)
    at com.iflex.fcat.services.apps.endpoints.AccountActivityService.inquireListOfTransaction(AccountActivityService.java:365)

STEPS
-----------------------
Issue is rendom in nature and may not get replicated with below steps everytime.
1. Login to FCDB application.
2. Navigate to Account Activity.
3. Select the account and choose last 'n' days criteria.




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
Cause
Solution
References


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