Error Message: could not open relation with OID

[sandyk]

I am trying to setup a 32-bit ODBC connection via the "Input Data" tool, and am running into an error indicating "could not open relation with OID" when running the test connection. It is just a basic SELECT query to a table. Does anyone know the cause of the issue and how to resolve? Thanks!

[gabrielvilella]

 Alteryx version 2021.2 was the last version that supported 32-bit connections. What is the version that you are running? 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/End-of-Support-for-32-BIT-Database-... 

[sandyk]

I have the 2021.2.3 version installed. 

[gabrielvilella]

Alteryx just leverages the connections settings you have on your ODBC manager in Windows. The error you are getting seems to be while creating the DSN. I encourage you to contact your IT team to understand if the information you are entering to create the connection is correct or not.  

[sandyk]

The ODBC configuration on my Windows laptop shows it is connecting successfully. Also, during the Input Data connection setup in Alteryx Designer, I was able to see all the table structures coming from the Redshift database, it is just at the point of testing the query that I end up getting the error message. 

[gabrielvilella]

I encourage you to try creating a 64-bit connection and see if you get the error.

[sandyk]

I have also tested the 64-bit ODBC connection as well and get the same error message.