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.

Following this question as I’ve run into the same issue, and have checked the timeout settings on my database which is disabled.

Reply


Community Stats

30,351
Posts
115,336
Replies
38,078
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.