topic Re: ArcGIS Pro 1.4/ArcMap 10.4 crash when using a geoprocessing tools with PostgreSQL layers in Developers Questions

ArcGIS Pro 1.4/ArcMap 10.4 crash when using a geoprocessing tools with PostgreSQL layers

PatricePineault — Thu, 09 Feb 2017 15:15:40 GMT

Hello,

I hope someone can help me out with this one...

Whenever I use a geoprocessing 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.

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 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.

Using:

Server-side:

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

Client-side:

ArcMap 10.4 / ArcGIS Pro 1.4
Windows 10 (64 bits)
PostgreSQL ODBC Driver version 9.05 (32 bits)

I would really appreciate if someone could point me in the right direction to solve the bug!

Patrice

Re: ArcGIS Pro 1.4/ArcMap 10.4 crash when using a geoprocessing tools with PostgreSQL layers

George_Thompson — Thu, 09 Feb 2017 16:00:34 GMT

https://community.esri.com/groups/geodatabase?sr=search&searchId=8bd771a7-a56d-4247-82fb-3240960d2da1&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=da42260d-4ccd-4859-a859-cf5aae1aece7&searchIndex=0‌

Re: ArcGIS Pro 1.4/ArcMap 10.4 crash when using a geoprocessing tools with PostgreSQL layers

jyotiprasad — Wed, 22 Feb 2017 11:09:35 GMT

plz try it in server desktop it will run i think. Means put all data in server. and check the server manager