Question

4
Replies
349
Views
Satya Sai Seetha Ramakrishna Kota (Ramakrishna1985)
Express Scripts

Express Scripts
US
Ramakrishna1985 Member since 2017 2 posts
Express Scripts
Posted: April 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

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) ~[?:?] 
Pega Platform 8.4 System Administration Healthcare and Life Sciences
Moderation Team has archived post, 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.