AnsweredAssumed Answered

Error connecting to PI server from linux using getsnap

Question asked by ujjwal on Aug 9, 2017
Latest reply on Aug 9, 2017 by sraposo

Hi ,

 

In linux machine when i try to connect to the PI server using getsnap i am getting the following error:

 

 

 

WARNING: Connection to https://my_server:5461/DataAccessServer/Query failed. Error: [PI SQL DAS] Connection timed out

Details: connect failed in tcp_connect()

 

 

java.sql.SQLException: Connection to https://my_server:5461/DataAccessServer/Query failed. Error: [PI SQL DAS] Connection timed out

Details: connect failed in tcp_connect()

 

 

 

 

 

Here is my code and log details:

 

$ java GetSnap my_server my_DAS  Yes Https/Soap:5461 5 sin%

 

 

Arguments:

        Data Access Server name: my_server

        PI Data Archive name: my_DAS

        Use trusted connection?: Yes

        Protocol order: Https/Soap:5461

        Log level: 5

        PI tag name/name pattern: sin%

 

 

Aug 09, 2017 4:55:50 AM com.osisoft.jdbc.DriverExtension <init>

FINER: Driver Version : 1.5.16096.2

Aug 09, 2017 4:55:50 AM com.osisoft.jdbc.DriverExtension <init>

INFO: New Connection : jdbc:pioledb://my_server /Data Source=my_DAS  ; Integrated Security=SSPI

Aug 09, 2017 4:55:50 AM com.osisoft.jdbc.DriverExtension logProperties

FINEST: Properties:

LogLevel=5

TrustedConnection=Yes

LogConsole=True

ProtocolOrder=Https/Soap:5461

Aug 09, 2017 4:55:50 AM com.osisoft.rdsa.NativeRDSA verifyWrapperLibrary

FINEST: /opt/pipc/jdbc/lib/libRdsaWrapper64-1.5b.so can be loaded.

Aug 09, 2017 4:55:50 AM com.osisoft.jdbc.DriverExtension getAuthentication

FINEST: Using trusted connection.

Aug 09, 2017 4:55:50 AM com.osisoft.jdbc.ConnectionImpl <init>

FINEST:  Trusted connection = true

Stateless connection = false

Aug 09, 2017 4:55:50 AM com.osisoft.rdsa.NativeRDSA create

INFO: Trying to connect to https://my_server:5461/DataAccessServer/Query

Aug 09, 2017 4:57:57 AM com.osisoft.jdbc.ConnectionImpl <init>

WARNING: Connection to https://my_server:5461/DataAccessServer/Query failed. Error: [PI SQL DAS] Connection timed out

Details: connect failed in tcp_connect()

 

 

java.sql.SQLException: Connection to https://my_server:5461/DataAccessServer/Query failed. Error: [PI SQL DAS] Connection timed out

Details: connect failed in tcp_connect()

 

 

Could not connect using none of the specified protocols.

 

 

 

If i try using NetTcp protocol instead I am getting a different error:

 

WARNING: Connection to net.tcp://my_server:5462/DataAccessServer/Query failed. Error: NetTcp is not supported.

 

 

java.sql.SQLException: Connection to net.tcp://my_server:5462/DataAccessServer/Query failed. Error: NetTcp is not supported.

 

pls help me resolve this

Outcomes