Skip to main content
  • EN

I am trying to convert an old script that loads 100+ tables in Postgres to a FME Server automation. One of the things I am doing is a

INSERT INTO schema1.table SELECT * FROM schema2.table

with a SQLExecutor where schema2 is a Oracle foreign table. This works fine for some smaller tables, but for a large table around 33gb I eventually receive a 'could not receive data from server: Connection timed out' error whether I run it on desktop or server. This worked fine when run from the script. I'm at a loss here, what could be causing the problem?

Hello, have you figured it out? If not yet, I think there will be a timeout settings. The Postgres server or the FME Server may have a connection timeout setting that is too low. An alternative is to create a spatial index if this is not the case.

Reply


Community Stats

30,095
Posts
114,254
Replies
37,725
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.