Question

5
Replies
490
Views
PradeepPydi Member since 2017 204 posts
Anthem
Posted: 2 years ago
Last activity: 2 years 2 months ago
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
Share this page LinkedIn