Whenever I use a geoprocessing tool (Clip tool) with a PostgreSQL/PostGIS table, the program crashes. If I make the process run in background, the process fails without any specific error message.
The input feature is a table located in the schema 'data' This is a very large table (~ 40 000 rows). The clip feature is a materialized view also from the schema 'data', but with a 'Definition Query' (ArcMap) applied to it so it returns only one polygon.
I looked at the PostgreSQL logs and everytime I use a geoprocessing tool, there is this error:
2017-02-08 22:43:13 EST LOG: Could not reveive data from client : unrecognized winsock error 10054
The output location is in a scratch file geodatabase on the local computer.
The database connection is working fine. The permissions to write to PostgreSQL are OK (I connect with user 'postgres', which has superuser privilege).
If I run the equivalent process in QGIS (for exemple, Clip) with the exact same tables, everything works perfectly.
- PostgreSQL 9.4.10 (64 bits)
- PostGIS 2.2.3
- Windows Server 2012 R2
- ArcMap 10.4
- Windows 10 (64 bits)
- PostgreSQL ODBC Driver version 9.05 (32 bits)