AnsweredAssumed Answered

PIJDBC 2018 Connection Reset

Question asked by JeremyWilson on Oct 22, 2018
Latest reply on Oct 24, 2018 by JeremyWilson

On a single environment I have a PI 2018 Archive server and PI SQL DAS and PI JDBC installed. 

 

When I try to connect I get to the server from a 3rd party JDBC client I get the following Java exception:

java.sql.SQLException: Connection failed. Connection reset

at com.osisoft.jdbc.DriverExtension.connect(DriverExtension.java:255)

at com.osisoft.jdbc.Driver.connect(Driver.java:341)

at com.osisoft.jdbc.Driver.connect(Driver.java:328)

at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

 

URL used is jdbc:pisql://host.domian.com/Data Source=serverName; Integrated Security=SSPI;

 

With JDBC verbose logging properties set I get the following trace information

 

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.DriverExtension <init>

FINER: Driver Version : 1.6.18206.1.

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.DriverExtension <init>

INFO: New Connection : jdbc:pisql://host.domain.com/Data Source=serverName; Integrated Security=SSPI;

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.DriverExtension logProperties

FINEST: Properties:

EnableCertificateValidation=False

LogLevel=5

user=********

password=********

LogFile=D:\Logs\jdbc.log

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.DriverExtension getAuthentication

FINEST: Searching Properties for "user" or "DCA"

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.DriverExtension getAuthentication

FINEST: AuthenticationInfo built from properties:AuthenticationInfo[host.domin.com\domain/********/******** ]

 

 

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.DriverExtension connect

FINE: PI SQL DAS Authentication with : AuthenticationInfo[aipiintegaf.esrgtech.com\esrgtech/********/******** ]

 

 

Oct 22, 2018 2:10:32 PM com.osisoft.jdbc.ConnectionImpl <init>

FINEST:  Trusted connection = false

 

 

Anyone have any insight to the issue or what next steps would be in troubleshooting.

Outcomes