3 Replies Latest reply on Oct 24, 2018 11:30 AM by JeremyWilson

    PIJDBC 2018 Connection Reset

    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.