This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Error:"Error SQLPrepare: [Simba][PostgreSQL] (30) Error occurred while trying to execute a query"
PostgreSQL data source is throwing the following after upgrading Alteryx Designer to 2022.3.
Error: Input Data (1): Error SQLPrepare: [Simba][PostgreSQL] (30) Error occurred while trying to execute a query: [SQLState 42P01] ERROR: relation "geometry_columns" does not exist LINE 1: SELECT SRID FROM GEOMETRY_COLUMNS WHERE F_TABLE_NAME
Alteryx Designer, Server
Database version prior to 11.7
Simba PostgreSQL ODBC Driver 22.214.171.1241
PostgreSQL database version prior to 11.7 is not validated with Simba PostgreSQL ODBC Driver 126.96.36.1991