ELCM - Resolution for error - Pool FCJDataSource is Suspended, cannot allocate resources to applications (Doc ID 1926623.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle FLEXCUBE Universal Banking - Version 10.3 to 12.0.3 [Release 10 to 12]
Information in this document applies to any platform.

Symptoms

 Slowness in the application & Error

weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool FCJDataSource is Suspended, cannot allocate resources to applications

The log file will show the below SQL during the error

SQLCall(SELECT t0.SERIAL_NO, t0.MODULE, t0.ACTION, t0.MULTI_AUTH, t0.AUTH_DT_STAMP, t0.POOL_CODE, t0.AUTH_STAT, t0.PROCESS_NO, t0.COLLATERAL_CODE, t0.REMARKS, t0.CUST_EXP_CCY_2, t0.SECURITY_ID, t0.CUST_EXP_CCY_4, t0.CUST_EXP_EXCH_RATE_1, t0.SIMULATION, t0.CUST_EXP_EXCH_RATE_3, t0.SOURCE, t0.CUST_EXP_EXCH_RATE_5, t0.TENOR, t0.CUST_EXP_ID_2, t0.TENOR_BASIS, t0.CUST_EXP_ID_4, t0.TRANS_DATE, t0.CUST_EXP_UTIL_1, t0.TXN_EXP_CCY_1, t0.CUST_EXP_UTIL_3, t0.TXN_EXP_CCY_2, t0.CUST_EXP_UTIL_5, t0.TXN_EXP_CCY_3, t0.DELETE_STATUS, t0.TXN_EXP_CCY_4, t0.EVENT_SL_NO, t0.TXN_EXP_CCY_5, t0.EXPSOURE_BLOCK_NO, t0.TXN_EXP_CODE_1, t0.INPUT_DT_STAMP, t0.TXN_EXP_CODE_2, t0.IS_ACCOUNT, t0.TXN_EXP_CODE_3, t0.LIAB_CCY, t0.TXN_EXP_CODE_4, t0.LIAB_ID, t0.TXN_EXP_CODE_5, t0.LIAB_UTIL, t0.TXN_EXP_EXCH_RATE_1, t0.LIMIT_CCY_MATURED, t0.TXN_EXP_EXCH_RATE_2, t0.LIMIT_EXCH_RATE, t0.TXN_EXP_EXCH_RATE_3, t0.LIMIT_TYPE, t0.TXN_EXP_EXCH_RATE_4, t0.LIMIT_UTIL, t0.TXN_EXP_EXCH_RATE_5, t0.LINE_SERIAL, t0.TXN_EXP_ID_1, t0.MATURED_AMT, t0.TXN_EXP_ID_2, t0.AMT_TAG, t0.TXN_EXP_ID_3, t0.BLOCK_REF_NO, t0.TXN_EXP_ID_4, t0.CUST_EXP_CCY_3, t0.TXN_EXP_ID_5, t0.CUST_EXP_EXCH_RATE_2, t0.TXN_EXP_UTIL_1, t0.CUST_EXP_ID_1, t0.TXN_EXP_UTIL_2, t0.CUST_EXP_ID_5, t0.TXN_EXP_UTIL_3, t0.CUST_EXP_UTIL_4, t0.TXN_EXP_UTIL_4, t0.EVENT_CODE, t0.TXN_EXP_UTIL_5, t0.IGNORE_OVERRIDES, t0.TXN_ID, t0.LIAB_BRANCH, t0.TXNINIT_DATE, t0.LIAB_NO, t0.UNCOLL, t0.LIMIT_CCY_UNCOLL, t0.UNITS, t0.LIMIT_UPDATE, t0.USER_REFNO, t0.MATURED, t0.UTIL_ADD_INFO1, t0.AUTH_ID, t0.UTIL_ADD_INFO2, t0.CUST_EXP_CCY_5, t0.UTIL_ADD_INFO3, t0.CUST_EXP_ID_3, t0.UTIL_ADD_INFO4, t0.CUSTOMER_NO, t0.UTIL_ADD_INFO5, t0.INPUT_USER_ID, t0.UTIL_AMT, t0.LIMIT_CCY, t0.UTIL_BRN, t0.LINE_CD, t0.UTIL_CCY, t0.CUST_EXP_CCY_1, t0.UTIL_ID, t0.CUST_EXP_UTIL_2, t0.UTIL_PRD, t0.LIAB_EXCH_RATE, t0.UTIL_STAT, t0.MATURITY_DATE, t0.UTIL_UPDATE, t0.EXPOSURE_TRACKING, t0.VALUE_DATE, t0.CUST_EXP_EXCH_RATE_4, t0.VD_UPDATE, t0.LIMIT_ID, t0.VERSION_NO FROM GETB_UTILS_LOG t0 WHERE (t0.VERSION_NO = (SELECT MAX(t1.VERSION_NO) FROM GETB_UTILS_LOG t1 WHERE (t1.UTIL_ID = ?))))

Internal Exception: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Data Source FCJDEVDSELCM is not active, cannot allocate connections to applications

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