Connection messages and errors

Common connection messages, including error messages that indicate connection problems, are provided here.

These messages and errors are visible as output of the IPISQL sample application. Other JDBC applications might display messages in a message box or log file, depending on how those applications handle exceptions. For example, DBVisualizer displays messages in the Connection Message text box of its Database Connection dialog.

Successful connection

The following message occurs when a successful connection is established:

Connected to PI SQL Data Access Server (RTQP Engine) 2018 SP3 Patch 3, 1.8.21196.1
Driver name: PI SQL Client, version: 4.2.22020.1.

Item: AF SDK Version: 2.10.9.593 FriendlyVersion: 2018 SP3 Patch 3
Item: AF Server Version: 2.10.9.593 FriendlyVersion: 2018 SP3 Patch 3
Item: Master Catalog Version: 2 FriendlyVersion: null
Item: Model Schema Version: 3 FriendlyVersion: null
Item: Operating System Version: 6.2.9200.0 FriendlyVersion: Microsoft Windows 10 Enterprise
Item: Query Processor Version: 1.8.21196.1 FriendlyVersion: 2018 SP3 Patch 3
Item: SQL Server Version: 15.0.2080.9 FriendlyVersion: Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64)

Incorrect username/password for connection to PI SQL DAS

The following error message occurs if the credentials for the connection to PI SQL DAS are invalid:

Connection failed. Server returned HTTP response code: 403 for URL:
https://PISQLDAS-server-name:port-number/RTQP/Query2/. HTTP/1.1 403 Forbidden

Kerberos authentication failure

The following error message occurs if Integrated Security is used, but not configured:

Connection failed. Server returned HTTP response code: 401 for URL:
https://PISQLDAS-server-name:port-number/RTQP/Query2/. HTTP/1.1 401 Unauthorized

Incorrect AF database name

The following error message occurs if the specified AF database does not exist:

Connection failed. Server returned HTTP response code: 400 for URL:
https://PISQLDAS-server-name:port-number/RTQP/Query2/.
The specified AF database 'database-name' is not available.

Incorrect PI SQL DAS

The following error message occurs if the PI SQL DAS name provided is not correct:

Connection failed. Unknown PI SQL DAS: PISQLDAS-Server-name

PI SQL DAS not running or incorrect port supplied

The following error message occurs if PI SQL DAS is not installed, not running, or is not listening to the specified port:

Connection failed. Please make sure the PI SQL DAS service is running, and you have supplied the correct port number.
Connection refused: connect

Firewall does not allow inbound connection on PI SQL DAS side

The following error message occurs if the firewall does not allow inbound connections to PI SQL DAS:

Connection failed. Please make sure the PI SQL DAS service is running, and you have supplied the correct port number.
Connection timed out: connect

Invalid or not trusted SSL certificate

The following error message occurs if the SSL certificate used by PI SQL DAS is invalid or not trusted:

Connection failed. SSL error sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

PI SQL DAS and PI SQL Client JDBC are not compatible

The following error message occurs if PI SQL Client JDBC tries to connect to an older version of PI SQL Data Access Server (RTQP Engine) that does not support it:

Connection failed. Protocol Version Mismatch Server protocol version 1.0is incompatible with client protocol version 1.1.