topic Re: prepared statement issue in Talend Studio

prepared statement issue

Anonymous — Sat, 16 Nov 2024 05:14:45 GMT

i am using talend 7 big data version ,trying to load data from blob to greenplum data base ,I facing error (prepared statement "S_1" already exists on greenplumoutput).Please provide solution for the above.

Re: prepared statement issue

Anonymous — Thu, 18 Jul 2019 15:41:11 GMT

Please provide me the solution for the above ASAP. I am struck with it.

Re: prepared statement issue

Anonymous — Wed, 14 Aug 2019 08:47:33 GMT

Solution:-run the spil query and find the PID by executing the query which are active and use terminate comanad by placing PID and execute terminate command

@pragnabatchu wrote:

i am using talend 7 big data version ,trying to load data from blob to greenplum data base ,I facing error (prepared statement "S_1" already exists on greenplumoutput).Please provide solution for the above.

Re: prepared statement issue

Anonymous — Wed, 18 Sep 2019 10:01:02 GMT

from pg_stat_activity also we can get PID and keep PID in terminate command