High-Level Issue
Not sure if anyone else has ran into a similar issue with the latest version (2023.2) of Alteryx. I recently upgraded my Alteryx Designer software from version 2021.4.2.47884 (Patch 11) to Designer 2023.2 and was unable to directly connect to my Postgres 15 database. I receive the following error in the results terminal: Error: Input Data (3): Error SQLDriverConnect: SSL SYSCALL error: No error (0x00000000/0)
Critical Version Info
Reproduction Steps
Requirements:
Steps:
Drivers Tested
Name | Version | Date | Successful Connection to Alteryx? |
PostgreSQL ANSI | 16.00.00.00 | 9/16/2023 | False |
PostgreSQL ANSI(x64) | 16.00.00.00 | 9/16/2023 | False |
PostgreSQL Unicode | 16.00.00.00 | 9/16/2023 | False |
PostgreSQL Unicode(x64) | 16.00.00.00 | 9/16/2023 | False |
Note: I was able to make a successful test connection with each of the drivers listed above. The problem occurs when attempting to establish the connection within Alteryx Designer.
Debugging
The TLS connections to the database can be observed using Network Monitor by Windows: https://www.microsoft.com/en-us/download/details.aspx?id=4865
Steps:
When using the 2022.1.1 version (or 2021.4.2) of Alteryx I would see two idential TLS client handshakes:
Picture 1
When using impacted versions of Alteryx (2023.2.1, 2023.1.1, and 2022.3.1) the TLS client handshake when loading the preview was correct:
Picture 2
but the TLS client handshake when running the workbook was missing key data:
Picture 3
The TLS client handshake when running the workbook is missing the following client extension:
Picture 4
The TLS client handshake when running the workbook is missing the following client extension:
ClientHelloExtension: Server Name(0x0000)
ExtensionType: Server Name(0x0000)
ExtensionLength: 81 (0x51)
NameListLength: 79 (0x4F)
NameType: Host Name (0)
NameLength: 76 (0x4C)
ServerName: a843c2b4-adff-4296-9d0d-95de3df4feed-2270ce930d1f.dev-database.optilogic.app
which is preventing Alteryx from connecting to the database.
Database Connection Information
Solved! Go to Solution.
I'm experiencing the exact same issue.
With same User DSN I can access the Postgres database with other utilities like Excel and PowerBI, but not with Alteryx (versions tested: 2023.1 and 2023.2).
Apparently, rolling back to 2021.4.2.47884 would solve the issue, but that's hardly a solution, of course :-)
Update - after working with Alteryx Support, I am happy to state that with the latest Alteryx version of 2024.1 this has been fixed and I was able to successfully connect a postgres database with Alteryx designer. Thank you so much to the Alteryx team for hearing us out and get a fix out!