Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Satya Sai Seetha Ramakrishna Kota (Ramakrishna1985)
Express Scripts

Express Scripts
US
Ramakrishna1985 Member since 2017 2 posts
Express Scripts
Posted: Apr 28, 2020
Last activity: May 8, 2020
Posted: 28 Apr 2020 16:39 EDT
Last activity: 8 May 2020 13:16 EDT
Closed
Solved

Issue in connecting to SQL Server (External DB)

While trying to connect to SQL Server (external db) using jtds driver to enable windows authentication.

This was working in Pega 7.2.2 but started throwing error on Pega 8.4.

Test Connectivity gets below error:

Status:fail

Operator:Unauthenticated or not available

Node:No ID available

Err/Exception on logs

Show More

While trying to connect to SQL Server (external db) using jtds driver to enable windows authentication.

This was working in Pega 7.2.2 but started throwing error on Pega 8.4.

Test Connectivity gets below error:

Status:fail

Operator:Unauthenticated or not available

Node:No ID available

Err/Exception on logs

com.pega.pegarules.pub.PRRuntimeError: PRRuntimeError 
	at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:721) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:520) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:4097) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:445) ~[prenginext.jar:?] 
	at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source) ~[?:?] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121] 
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1408) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1140) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:994) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:368) ~[prenginext.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:920) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:338) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:282) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:259) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:281) ~[prpublic.jar:?] 
	at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:226) ~[prpublic.jar:?] 
	at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:767) ~[prwebj2ee.jar:?] 
	at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:423) ~[prwebj2ee.jar:?] 
	at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source) ~[?:?] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121] 
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121] 
	at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:385) ~[prbootstrap-8.4.0-237.jar:8.4.0-237] 
	at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:427) ~[prbootstrap-8.4.0-237.jar:8.4.0-237] 
	at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225) ~[prbootstrap-api-8.4.0-237.jar:8.4.0-237] 
	at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274) ~[prbootstrap-api-8.4.0-237.jar:8.4.0-237] 
	at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:146) ~[prbootstrap-api-8.4.0-237.jar:8.4.0-237] 
	at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:107) ~[prbootstrap-api-8.4.0-237.jar:8.4.0-237] 
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) ~[servlet-api.jar:?] 
	at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:172) ~[prbootstrap-api-8.4.0-237.jar:8.4.0-237] 
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[servlet-api.jar:?] 
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:8.5.14] 
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-websocket.jar:8.5.14] 
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) ~[catalina.jar:8.5.14] 
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[catalina.jar:8.5.14] 
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) ~[tomcat-coyote.jar:8.5.14] 
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-coyote.jar:8.5.14] 
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) ~[tomcat-coyote.jar:8.5.14] 
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) ~[tomcat-coyote.jar:8.5.14] 
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:8.5.14] 
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_121] 
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_121] 
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:8.5.14] 
	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121] 
Caused by: java.lang.AbstractMethodError 
	at net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833) ~[jtds-1.3.1.jar:1.3.1] 
	at com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:411) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:382) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:346) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72) ~[HikariCP-java7-2.4.12.jar:?] 
	at com.pega.platform.datastore.connection.internal.jdbc.JdbcConnectionManager.newHikariDataSource(JdbcConnectionManager.java:187) ~[datastore.jar:?] 
	at com.pega.platform.datastore.connection.internal.jdbc.JdbcConnectionManager.initializeDataSource(JdbcConnectionManager.java:146) ~[datastore.jar:?] 
	at com.pega.platform.datastore.connection.internal.jdbc.JdbcConnectionManager.newDataSource(JdbcConnectionManager.java:119) ~[datastore.jar:?] 
	at com.pega.platform.datastore.connection.internal.jdbc.JdbcConnectionManager.get(JdbcConnectionManager.java:97) ~[datastore.jar:?] 
	at com.pega.platform.logicaldatastore.connection.internal.ConnectionBrokerImpl.getConnection(ConnectionBrokerImpl.java:100) ~[logical-datastore.jar:?] 
	at com.pega.pegarules.data.internal.store.ConnectionBrokerAdapter.getDataStoreConnection(ConnectionBrokerAdapter.java:245) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.store.ConnectionBrokerAdapter$JdbcConnectionManagerAdapter.getDataStoreConnection(ConnectionBrokerAdapter.java:464) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.store.ConnectionBrokerAdapter$JdbcConnectionManagerAdapter.getJDBCUrlConnection(ConnectionBrokerAdapter.java:716) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.testConnection(DatabaseImpl.java:3880) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.testConnection(DatabaseImpl.java:3946) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.testNonInheritedConnection(DatabaseImpl.java:8580) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.testConnection(DatabaseImpl.java:8575) ~[prprivate-data.jar:?] 
	at com.pegarules.generated.activity.ra_action_testdbconnection_99d5f180c6e771e9b27d7315370ec44f.step3_circum0(ra_action_testdbconnection_99d5f180c6e771e9b27d7315370ec44f.java:341) ~[?:?] 
	at com.pegarules.generated.activity.ra_action_testdbconnection_99d5f180c6e771e9b27d7315370ec44f.perform(ra_action_testdbconnection_99d5f180c6e771e9b27d7315370ec44f.java:119) ~[?:?] 
Show Less
To see attachments, please log in.
Pega Platform 8.4
System Administration
Healthcare and Life Sciences

Accepted Solution

Posted: 4 years ago
Updated: 4 years ago
Posted: 29 Apr 2020 6:53 EDT
Updated: 8 May 2020 13:16 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

This looks like a jdbc driver issue: https://stackoverflow.com/questions/41231750/abstractmethoderror-with-jtds-jdbc-driver-on-tomcat-8/41232124. By default if you configure DB instance using url, Pega will use embedded Hikari connection pooling (I believe since 7.4). You can configure your external DB as datasource in tomcat context.xml and make sure add the following in the datasource attribute, let us know that resolves the issue.

validationQuery="select 1"
To see attachments, please log in.
Posted: 4 years ago
Posted: 29 Apr 2020 18:22 EDT
Satya Sai Seetha Ramakrishna Kota (Ramakrishna1985)
Express Scripts

Express Scripts
US

<!-- CONTEXT.XML

    <Resource name="jdbc/PrfRpt"               auth="Container"               type="javax.sql.DataSource"               maxTotal="100"               maxIdle="30"               maxWaitMillis="10000"               validationQuery="select 1"               driverClassName="net.sourceforge.jtds.jdbc.Driver"               url="jdbc:jtds:sqlserver://<SERVERNAME>:<PORT>;databaseName=PrfRpt;domain=<DOMAIN>;useNTLMv2=true;"               username="usrname"               password="usrPwd#"/>

-->

<!-- PRCONFIG.XML

<env name="database/drivers" value="net.sourceforge.jtds.jdbc.Driver" />

<env name="database/databases/PrfRpt/dataSource" value="java:comp/env/jdbc/PrfRpt"/>   

 

This worked in Personal Edition. When I did this in newly upgraded Dev, did not work.

To see attachments, please log in.
Posted: 4 years ago
Posted: 29 Apr 2020 18:24 EDT
Satya Sai Seetha Ramakrishna Kota (Ramakrishna1985)
Express Scripts

Express Scripts
US

IN the Data Admin DB Name Instance I created a instance with "use configuration in preference" option.

When Saving the instance, it shows the error.

Database PrfRpt has a configuration problem: the database is configured to get SQL connection information from the preferences, but the preferences have no "url" or "name" setting for this database

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice