1

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.

Software used:

Server-side:

  • PostgreSQL 9.4.10 (64 bits)
  • PostGIS 2.2.3
  • Windows Server 2012 R2

Client-side:

  • ArcMap 10.4
  • Windows 10 (64 bits)
  • PostgreSQL ODBC Driver version 9.05 (32 bits)

closed as off-topic by PolyGeo Feb 27 '17 at 5:11

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – PolyGeo
If this question can be reworded to fit the rules in the help center, please edit the question.

  • What happens when you do this in the foreground? Does it give a Serious Application Error or something else? – PolyGeo Feb 9 '17 at 18:18
  • 1
    Does the crash/failure happen immediately? Or does it occur after clip has been running for a while? – Jay Cummins Feb 10 '17 at 1:05
  • @PolyGeo: In the foreground, it does give a Serious Application Error. – Gob Tron Feb 10 '17 at 1:46
  • @JayCummins: The crash happens after a few seconds (maybe 5 seconds) after the geoprocessing is launched. – Gob Tron Feb 10 '17 at 1:48
  • 1
    @PolyGeo: Yes I did send them an email (Send Error Report). Hummm I did not try to export one of those two tables to a ESRI feature class. But I did try to export another table from ArcGIS and it failed too with the error "each grid size must be at least three times larger tan the preceding grid size arcmap" – Gob Tron Feb 10 '17 at 1:51