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?
