topic Call PostgreSQL procedure from Qlik Automation Block in Qlik Automate

Call PostgreSQL procedure from Qlik Automation Block

kaba — Tue, 13 Jan 2026 21:17:58 GMT

HI, In Qlik Automation I’m calling a PostgreSQL procedure using the Postgre>Do Query block:

I simply put into 'Query *' field:
call schema.procedure_name();

The block usually keeps running for a 2 hours 5 minutes or eventually times out, even though in PostgreSQL the procedure is triggered immediately and finishes in less than a millisecond (based on my logs).

Do you have any experience or recommended block/workaround for this?

Thanks!

Re: Call PostgreSQL procedure from Qlik Automation Block

marksouzacosta — Wed, 14 Jan 2026 13:51:45 GMT

Hi @kaba,

I'm not able to test it but my guess is that the Do Query block is probably expecting your stored procedure to return something. I would try something like this in the Do Query block and see if it works:

CALL schema.procedure_name(); SELECT NOW() AS current_datetime;

Regards,

Mark Costa

Re: Call PostgreSQL procedure from Qlik Automation Block

kaba — Thu, 15 Jan 2026 10:30:43 GMT

Thank you @marksouzacosta,

the problem is its not possible to run 2 queries like this in a in a Do Query block.
I tried to wrap it into a function returning one value, but it doesn't seem to have any effect.

SELECT scheme.run_procedure_name();

Re: Call PostgreSQL procedure from Qlik Automation Block

FaizanMirza — Thu, 29 Jan 2026 09:27:35 GMT

Hi @marksouzacosta @kaba Even I face the Same issue I created an Automation to write Directly into Postgress SQL through Qlik Writeback Table here: I was able to make the connection but the Query Doesn't work nor do the Insertion operation