Using JDBC to Access OSI PI from Ignition

Ignition
,
1

I am running version 8.1.44 of Ignition and I am trying to configure a JDBC Database Driver that will connect to and query my OSI PI Data.

I was trying to follow the guidance outlined in this article but I see that they were using a much older version of Ignition and JDBC driver.

The JDBC Driver that I am using is version 2019, Patch 1, the AF PI Server version that I am using is 2018 SP3 Patch 6, and the PI SQL Data Access Server that I am using is version 2023, Patch 1.

Right now, I am running into a couple of different errors on the Ignition side.

My JDBC Driver is configured as follows:
Name - OSI PI
Classname - com.osisoft.jdbc.Driver
Driver Type - Generic
URL Format - jdbc:pisql://PI Server IP Address/Data Source=PI Server Data Source;Integrated Security=SSPI;
Default Translator - MSSQL

When I try to create a Database Connection using the OSI PI JDBC Driver, the connection bounces between a reconnecting and faulted status, and I get the following error:
"Cannot create PoolableConnectionFactory (Connection failed. Please make sure the PI SQL DAS service is running, and you have supplied the correct port number. Connection refused: connect)"

I have confirmed that the PI SQL DAS service is running on the PI server, and that I can see the PI server from my Ignition Server.

I have tried updating the URL in my Database Connection to: jdbc:pisql://PI Server IP Address:PI SQL DAS Port/Data Source=PI Server Data Source;Integrated Security=SSPI;
But when I do this, my Database Connection immediately goes into a faulted status and I get a different error:
"Cannot create PoolableConnectionFactory (Connection failed. Error at index 4 in: "5469:5461")"

Does anybody know if this functionality is still supported on newer versions of Ignition? If so, are there any steps that I may be missing in my configuration that would help give better clarity on the errors that I am seeing?

2

Your URLs do not look like the correct format, did you just remove the das_node and PI Server name from the URLs before posting, or are they actually missing in your configuration?

3

I only removed before posting. They exist in my configuration.
Edit: I didn't realize that using <>'s in my post would hide the information. I have updated the OP.

4

I think you’re going to have to post the un-redacted connection string for this error to make sense.

If you can’t do that here give support a call.

5

"Cannot create PoolableConnectionFactory (Connection failed. Error at index 4 in: "5469:5461")"

Sounds like a syntax issue when trying to read the connection string. Try 5462 if you haven't changed the default ports on the PI DAS

6

Using a different IP address but the connection string is:
jdbc:pisql://192.168.21.128:5469/Data Source=HIST;Integrated Security=SSPI;

7

The PI DAS is installed on ports 5468/5469 on my PI server. The default ports are 5464 and 5465, but they were being occupied by some System Kernel PID.

8

Oh. I was getting 5462 from the docs here but I believe that's the wrong documentation for the product you're using.

It's weird that the error message contains 5461 if this product doesn't default to 5461/5462 and you're trying to use 5468/5469.

9

It appears that your document is for PI SQL DAS 2016 R2. I am using 2023 SP1, and its document specifies that the default ports are 5464 and 5465. Here is a link to the Administrator Guide

10

Yeah, agreed. I'm just not sure how 5461 ends up in your error message if that port isn't involved.