AnsweredAssumed Answered

Error 10054 When running python script accessing SQL Query Layers

Question asked by Archaeojp on Aug 5, 2016
Latest reply on Nov 15, 2018 by GeoAppGISCos

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.

Outcomes