Data connections getting full during case screening and investigation, causing delay (Doc ID 2834935.1)

Last updated on JANUARY 25, 2022

Applies to:

Symptoms

DB connections started increasing after the ECM cases hit 500+ instead of regular 10 for CS batch cases investigation. This caused the other screening process to be kept on hold.

error in datasource.log:
com.ofss.reveleus.cm.service.RealTimeScreeningBusinessService.isCommentsMandatoryForDecision(RealTimeScreeningBusinessService.java:204)
com.ofss.reveleus.cm.service.RealTimeScreeningBusinessService.updateEventDecision(RealTimeScreeningBusinessService.java:310)
com.ofss.reveleus.cm.service.RealTimeScreeningBusinessService.updateEventDecision(RealTimeScreeningBusinessService.java:326)
com.ofss.reveleus.cm.service.RealTimeScreeningBusinessService.getModuleConfiguration(RealTimeScreeningBusinessService.java:413)
com.ofss.reveleus.cm.service.RealTimeScreeningBusinessService.clearEventGridPreference(RealTimeScreeningBusinessService.java:680)

com.ofss.reveleus.cm.dao.ECMDAO.getAssocOptnForHierAtr(ECMDAO.java:804)
com.ofss.reveleus.cm.dao.ECMDAO.getCaseDetail(ECMDAO.java:4118)
com.ofss.reveleus.cm.dao.ECMDAO.getAssociatedAttrsForCase(ECMDAO.java:4330)

com.ofss.reveleus.cm.service.CustomerScreeningBusinessService.getPDFCustAddrDetailsForAnEvent(CustomerScreeningBusinessService.java:682)
com.ofss.reveleus.cm.service.CustomerScreeningBusinessService.updateEventDecision(CustomerScreeningBusinessService.java:715)
com.ofss.reveleus.cm.service.CustomerScreeningBusinessService.updateEventDecision(CustomerScreeningBusinessService.java:741)
com.ofss.reveleus.cm.service.CustomerScreeningBusinessService.getFccControlMaskingStatus(CustomerScreeningBusinessService.java:1255)

Cause

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