Question

2
Replies
9823
Views
Close popover
Bhushan Patil (BHUSHANPATIL)
Cognizant Technology Solutions
Bhushan Patil
Cognizant Technology Solutions
US
BHUSHANPATIL Member since 2008 49 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,
Close popover 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.