I am unable to solve a closest facility problem in ArcGIS Desktop 10.2.2 with ArcPy using the sample code provided in help documentation. I get this error: ERROR: A geoprocessing error occurred. ERROR 001156: Failed on input OID 32768, could not write value '32768' to output field ORIG_FID Failed to execute (FeatureClassToFeatureClass). An error occured on line 27 A geoprocessing error occurred. ERROR 001156: Failed on input OID 32768, could not write value '32768' to output field ORIG_FID Failed to execute (FeatureClassToFeatureClass). Failed to execute (FindClosestFacilities). It seems to me this is a bug with field mapping that is occurring internally. Its obvious that ORIG_FID should be a long int and it actually is short int. That is why we are seeing this exception at 32768. I am using the San Francisco network dataset available in ArcGIS tutorial data, with some randomly generated facilities (about 100,000) over the area. This is the code that throws the error. import arcpy from arcpy import env try : # Check out the Network Analyst extension license arcpy . CheckOutExtension ( "Network" ) # Set environment settings env . workspace = r 'C:\arcgis\ArcTutor\Network Analyst\Tutorial\SanFrancisco.gdb' env . overwriteOutput = True # Set local variables inNetworkDataset = r 'C:\arcgis\ArcTutor\Network Analyst\Tutorial\SanFrancisco.gdb\Transportation\Streets_ND' inIncidents = r 'D:\Sample data\sampledata.gdb\incident' inFacilities = r 'D:\Sample data\sampledata.gdb\manholes_sf' outGeodatabase = r 'D:\Sample data\sampledata.gdb' #outGeodatabase = "in_memory" outRoutes = "Routes" outDirections = "Directions" outClosestFacilities = "ClosestFacilities" measurement_units = "Meters" # Run FindClosestFacilities. Choose to find only the closest facility. arcpy . na . FindClosestFacilities ( inIncidents , inFacilities , measurement_units , inNetworkDataset , outGeodatabase , outRoutes , outDirections , outClosestFacilities , Number_of_Facilities_to_Find = 1 ) print "Script completed successfully" except Exception as e : # If an error occurred, print line number and error message import traceback , sys tb = sys . exc_info ( ) [ 2 ] print "An error occured on line %i" % tb . tb_lineno print str ( e )

Thanks George... finally bookmarked!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcPy Bug?- Find closest facility ERROR 001156: could not write value '32768' to output field ORIG_FID

geography-matters

I am unable to solve a closest facility problem in ArcGIS Desktop 10.2.2 with ArcPy using the sample code provided in help documentation.

I get this error:

ERROR: A geoprocessing error occurred.
ERROR 001156: Failed on input OID 32768, could not write value '32768' to output field ORIG_FID
Failed to execute (FeatureClassToFeatureClass).
An error occured on line 27
A geoprocessing error occurred.
ERROR 001156: Failed on input OID 32768, could not write value '32768' to output field ORIG_FID
Failed to execute (FeatureClassToFeatureClass).
Failed to execute (FindClosestFacilities).

It seems to me this is a bug with field mapping that is occurring internally. Its obvious that ORIG_FID should be a long int and it actually is short int. That is why we are seeing this exception at 32768.

I am using the San Francisco network dataset available in ArcGIS tutorial data, with some randomly generated facilities (about 100,000) over the area.

This is the code that throws the error.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Check out the Network Analyst extension license</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set environment settings</SPAN>
&nbsp;&nbsp;&nbsp; env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\arcgis\ArcTutor\Network Analyst\Tutorial\SanFrancisco.gdb'</SPAN>
&nbsp;&nbsp;&nbsp; env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp; inNetworkDataset <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\arcgis\ArcTutor\Network Analyst\Tutorial\SanFrancisco.gdb\Transportation\Streets_ND'</SPAN>
&nbsp;&nbsp;&nbsp; inIncidents <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Sample data\sampledata.gdb\incident'</SPAN>
&nbsp;&nbsp;&nbsp; inFacilities <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Sample data\sampledata.gdb\manholes_sf'</SPAN>
&nbsp;&nbsp;&nbsp; outGeodatabase <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Sample data\sampledata.gdb'</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#outGeodatabase = "in_memory"</SPAN>
&nbsp;&nbsp;&nbsp; outRoutes <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Routes"</SPAN>
&nbsp;&nbsp;&nbsp; outDirections <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Directions"</SPAN>
&nbsp;&nbsp;&nbsp; outClosestFacilities <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ClosestFacilities"</SPAN>
&nbsp;&nbsp;&nbsp; measurement_units <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Meters"</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Run FindClosestFacilities. Choose to find only the closest facility.</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>na<SPAN class="punctuation token">.</SPAN>FindClosestFacilities<SPAN class="punctuation token">(</SPAN>inIncidents<SPAN class="punctuation token">,</SPAN> inFacilities<SPAN class="punctuation token">,</SPAN> measurement_units<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inNetworkDataset<SPAN class="punctuation token">,</SPAN> outGeodatabase<SPAN class="punctuation token">,</SPAN> outRoutes<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outDirections<SPAN class="punctuation token">,</SPAN> outClosestFacilities<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Number_of_Facilities_to_Find<SPAN class="operator token">=</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Script completed successfully"</SPAN>

<SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># If an error occurred, print line number and error message</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> traceback<SPAN class="punctuation token">,</SPAN> sys
&nbsp;&nbsp;&nbsp; tb <SPAN class="operator token">=</SPAN> sys<SPAN class="punctuation token">.</SPAN>exc_info<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"An error occured on line %i"</SPAN> <SPAN class="operator token">%</SPAN> tb<SPAN class="punctuation token">.</SPAN>tb_lineno
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> str<SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

DanPatterson_Retired

You have identified the problem, you will have to delete that field, then re-add it with the appropriate dtype. I suspect the demo was just for that purpose and wasn't designed to handle that many records in the first place.

geography-matters

No Dan, we cannot delete that field as it is part of an intermediate feature class/table that gets generated during the solve process. It is saved in the geodatabase as "TempInput" only because the process crashed out. During normal runs, it gets created and deleted automatically. Only this time, since the process crashed, we see the TempInput featureclass remain in the output gdb.

DanPatterson_Retired

Flag it to support is pretty well the only recourse then. You may want to inquire if this issue had been identified and fixed in more recent versions... I notice that you refer to arcmap 10.2.2 which according to the Product Life cycle has entered 'mature' support (never found a clear definition of that one) so upgrading may be the only option.

George_Thompson

Dan Patterson‌ here is the information on Mature Support: http://downloads2.esri.com/support/TechArticles/Product-Life-Cycle.pdf

DanPatterson_Retired

bug ....http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4OTAzMw==

version fixed 10.4

geography-matters

Thanks Dan,

Adding a screenshot of the bug report

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.