ST_AsText Function Error | Qlik Sense May 2021 Patch 2 | ODBC

[JGMDataAnalysis]

Hello, how are you?

When using the PostGIS function ST_AsText in a query I get the following error:

However, when I run the same query using the DBMS interface, it runs successfully.

It should be noted that the same data was used for both connections, Qlik and DBMS, respectively.

SELECT version():

PostgreSQL 11.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit

@Patric_Nordstrom can you guide me?

[Patric_Nordstrom]

Should work

See connector example (for SQL server but same principle)

https://community.qlik.com/t5/Qlik-Sense-Documents/MS-SQL-Server-and-Qlik-GeoAnalytics-QGA/ta-p/1521...

Thanks,

Patric

[JGMDataAnalysis]

Thank you very much, Patric. I'm going to try installing the QGA Plus connector that allows me to pass the SELECT statement directly to it.