Question

3
Replies
949
Views
Rohini Srinivasan (RohiniS6)
Infosys Technologies Ltd

Infosys Technologies Ltd
IN
RohiniS6 Member since 2012 3 posts
Infosys Technologies Ltd
Posted: August 30, 2016
Last activity: September 7, 2016
Posted: 30 Aug 2016 5:44 EDT
Last activity: 7 Sep 2016 7:53 EDT
Closed
Solved

Cause of multiple DB connection pool failure?

Our applications are in production for a year and Pega upgrade to V7.2.1 was done recently. All of a sudden, DB connection pool failure can be noticed in multiple places in log file. There are connection problems with “Pegadata” pool and history class itself. Can you please suggest what could be the root cause of the issue?

***************************************

2016-08-30 00:04:48,166 [fault (self-tuning)'] [TABTHREAD4] [      CPECS:01.01.01] (l.access.ConnectionManagerImpl) ERROR brms-prd4-01|XX.XX.XXX.XX CPEAdmin - Not returning connection 0 for database "pegadata" to the pool as it previously encountered the following error
User ID: CPEAdmin

***************************************

User ID: CPEAdmin
Last SQL: SELECT count(*) as "pyCount" FROM CPE_BPRMS.pr_History_Cisco_FW_CPEF_728cb where pxObjClass = 'History-Cisco-FW-CPEFW-Data-Ref-FCRCustomerList'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

***Updated by Moderator: Marissa to update categories***

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.