Trying to use PostGree SQL conector to access some info... but get always an error

kickoff07 — Mon, 07 Nov 2022 12:07:51 GMT

Hi -

I'm trying to get data using the Postgree database conector in qlik cloud. The query run from my laptop works perfectly (it's a test query just to test). But not through qlik conector:

LIB CONNECT TO 'ABX';

LOAD [CUPS] AS [CUPS];
sql
select cups as CUPS from hourly_consumptions_pro limit 10;

Reply:

Connected

The following error occurred:

(Connector error: ERROR [XX000] [Qlik][PostgreSQL] (30) Error occurred while trying to execute a query: [SQLState XX000] ERROR: line 1:7: no viable alternative at input ';declare')

The error occurred here:

sql select cups as CUPS from hourly_consumptions_pro limit 10

Data has not been loaded. Please correct the error and try loading again.

Any thoughts on this ?

Re: Trying to use PostGree SQL conector to access some info... but get always an error

benoithervochon — Mon, 07 Nov 2022 12:48:31 GMT

Hello

When "The query run from my laptop works perfectly " -> with Qlik Sense Desktop ? or other tool ?

Re: Trying to use PostGree SQL conector to access some info... but get always an error

kickoff07 — Mon, 07 Nov 2022 13:33:58 GMT

My Postgre SQL client (outside Qlik)

topic Re: Trying to use PostGree SQL conector to access some info... but get always an error in Integration, Extension & APIs

Trying to use PostGree SQL conector to access some info... but get always an error

Re: Trying to use PostGree SQL conector to access some info... but get always an error

Re: Trying to use PostGree SQL conector to access some info... but get always an error