Question

2
Replies
9733
Views
Close popover
Bhushan Patil (BHUSHANPATIL)
Cognizant Technology Solutions
Bhushan Patil
Cognizant Technology Solutions
US
BHUSHANPATIL Member since 2008 48 posts
Cognizant Technology Solutions
Posted: December 9, 2016
Last activity: December 27, 2016
Closed
Solved

Not returning connection x for database "pegadata" to the pool as it previously encountered the following error

We are seeing below execption, is there specific required to handle it? 

DB- Oracle 12c

app server - Weblogic

2016-12-08 10:33:04,995 [fault (self-tuning)'] [TABTHREAD1] [                    ] [       xx:02.01.02] (l.access.ConnectionManagerImpl) ERROR u - Not returning connection 13 for database "pegadata" to the pool as it previously encountered the following error

User ID: xx
Last SQL: select  AccessGroup as ".AccessGroup", AdverseEvent as ".AdverseEvent", Complaint as ".Complaint", DeactivatePatient as ".DeactivatePatient", PerformSearch as ".PerformSearch", TakePatientSurvey as ".TakePatientSurvey", UpdateProfile as ".UpdateProfile" from PEGA_DATA.xx where AccessGroup = 'xx:xx'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

System Administration
Moderation Team has archived post