Question

3
Replies
924
Views
RohiniS6 Member since 2012 3 posts
Infosys Technologies Ltd
Posted: 4 years ago
Last activity: 4 years 1 month ago
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
Share this page LinkedIn