Question

5
Replies
557
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 215 posts
Anthem
Posted: July 2, 2018
Last activity: July 13, 2018
Closed

SQLServerExceptions and Productions JVM crash down.

Hi Team,

Please find our environment stack below.

PRPC : 731, Tomcat : 8.5.13 and SQL Server

Out of 30 JVM's only few of them crashes down with the below mentioned errors.Nothing suspicious in the DB and Windows Event logs.

PFB for the Tomcat Connection pool settings.

<Resource maxWaitMillis="10000" maxIdle="30" maxTotal="100" password="ABCD" username="ABCD" url="jdbc:sqlserver://ABCD\PEGA;databaseName=ABCD;SelectMethod=cursor;SendStringParametersAsUnicode=false" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" type="javax.sql.DataSource" auth="Container" factory="dbencryption.EncryptedDataSourceFactory" name="jdbc/PegaRULES"/>

Any suggestions please.

PRPC Log:

7/2/18 1:52:17.000 PM 2018-07-02 13:52:17,612 [.140.80-8887-exec-12] [TABTHREAD1] [ ] [mCSNCCSuper:01.01.01] ( internal.access.Lister) ERROR gbdcompass.corp.agp.ads|xx.xx.xx.xx AF28038 - There was a problem with the database when getting a list:com.pega.pegarules.pub.database.ConnectionException: Database-General Problem encountered when getting connection for database pegadata 0 The connection is closed.DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. | SQL Code: 0 | SQL State: null at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:348) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:333) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getConnectionFromDataSourceIdentity(JdbcConnectionManagerImpl.java:1032) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getDataStoreConnection(JdbcConnectionManagerImpl.java:3431) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getDataStoreConnection(JdbcConnectionManagerImpl.java:1291) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getDataStoreConnection(JdbcConnectionManagerImpl.java:1190) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.ClassicConnectionBroker.getDataStoreConnection(ClassicConnectionBroker.java:103) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.ConnectionBrokerRouter.getDataStoreConnection(ConnectionBrokerRouter.java:71) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.store.AutoCommitTransaction.getDataStoreConnection(AutoCommitTransaction.java:316) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.RDBPageResultPackager.getDataStoreConnection(RDBPag

Tomcat logs :

Tomcat below first error in logs shown SQL connection is closed while reading PR_ENGINE_JARS file from PEGA_RULES data source.

SQLException from datasource while checking for package = org/apache/http/client/( PR_ENGINE_JARS)

com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

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.