Question
AIG
US
Last activity: 27 Dec 2016 7:25 EST
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
Accepted Solution
AIG
US
root cause : WebLogic was not allocating more than 16 connections on any node in development environment, hence the connection limits are increased; this has resolved issue
Pegasystems Inc.
US
can you check your pegarules datasource connection pool size and the specific PEGA_DATA.xx to if xx is there using database tool (e.g, sql developer from Oracle)?
Accepted Solution
AIG
US
root cause : WebLogic was not allocating more than 16 connections on any node in development environment, hence the connection limits are increased; this has resolved issue