Question

2
Replies
9678
Views
BHUSHANPATIL Member since 2008 47 posts
Cognizant Technology Solutions
Posted: 3 years ago
Last activity: 3 years 9 months ago
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
Share this page LinkedIn