topic Error 10054 When running python script accessing SQL Query Layers in Python Snippets Questions

Error 10054 When running python script accessing SQL Query Layers

Jon-PaulMcCool1 — Fri, 05 Aug 2016 10:44:48 GMT

PROBLEM: I have a python script that replaces an existing feature class within a GDB with new data using the line below (part of a longer script):

arcpy.FeatureClassToFeatureClass_conversion(URD, tempGDB, "URD", urd_selection_expression)

URD is a sql query layer, tempGDB is an established geodatabase, "URD" is a feature class that is deleted in an earlier step to be recreated in this one, the expression simply selects a named subset.

The everythign worked perfectly when using 10.3, but upgrading to 10.4.1 I get the following error when running the script itself: "exceptions.EOFError.[Errno 10054] An existing connection was forcibly closed by the remote host"

Using the exact same code in the python window within ArcMap runs just fine.

Other than updating ArcGIS, nothing has changed. The sql query layer is fine when the map document is opened.

Re: Error 10054 When running python script accessing SQL Query Layers

GabrieleGARNERO1 — Wed, 22 Aug 2018 08:47:11 GMT

I have the same problem.
Were you able to find the solution?

Thanks

Gabriele

Re: Error 10054 When running python script accessing SQL Query Layers

AdrianWelsh — Fri, 12 Oct 2018 20:34:08 GMT

Just checking in too. Any luck with this?

Re: Error 10054 When running python script accessing SQL Query Layers

LarryCosgrove — Thu, 15 Nov 2018 12:34:50 GMT

Just asking for grins, but is anyone having this issue also running Check Point Security Software?