Error 999999 ошибка выполнения функции arcgis

If you’ve worked with ArcGIS, you’ve certainly had your fair share of errors while running geoprocessing tools – many of them are quite descriptive and tell you exactly what’s wrong, while some are specific but cryptic. But one error message, with error code 999999, is painful to get because it means something went wrong, and even the software isn’t sure what it is. It is usually accompanied by misleading messages such as “the table was not found” or something else. So we have to figure it out ourselves. In this article, I’ll lay out some places to look for the most common solutions to this problem.

Here’s the summary of steps (followed by detailed explanations for each one), in an approximate order of how I try them – though circumstances will vary and you may have a hunch that one of these will work.

1. Restart ArcMap/Your Computer
2. Try the operation in a blank map document or in ArcCatalog
3. Check your input and output workspaces
4. Check the names of your inputs and outputs
5. Disable Background Geoprocessing
6. Check your projections/coordinate systems
7. Check your environment settings for anything unusual
8. Look for any tool specific settings that could create problems – try simplifying your options until the tool runs, which will help you ID the problem
9. Try Repair Geometry

Restart ArcMap/Your Computer

Troubleshooting 101, but we all need a reminder sometimes. Turning it off and back on again can work! If you want to just reboot the software and not your computer, make sure to kill all ArcGIS programs – you can open your task manager and find ArcROT, ArcGIS Connection Manager, and ArcGIS Cache Manager – make sure to kill each of those processes if they are running. The easiest way is to often reboot your whole computer. Then try the operation again.

Try the operation in a blank map document or in ArcCatalog

If you’ve been working with the data in ArcMap, try running it in ArcCatalog instead, or try running it in a new, blank map document. Map documents can occasionally accumulate problems or small issues related to environment settings you’ve changed, and attempting the operation in a new map document can help rule out these issues.

Check your input and output workspaces

To put this another way, check the formats of the data you’re providing as inputs or choosing for outputs, as well as the locations they are stored. While ArcGIS has become much more consistent in the last 5-10 years, occasionally a tool may have trouble working with file geodatabase rasters when an Esri GRID format raster works just fine (for example). You can try copying the data to a new version of the same workspace – so if it’s already in a file geodatabase, try copying it to a brand new file geodatabase as the only item – or you can try converting it to a different format (export a GeoTIFF, GRID, etc). The same rules can apply for outputs – try writing out the results as a different format to see if it resolves the issue. Finally, check the workspace environment settings. For many years, certain raster operations wanted to use folder workspaces rather than geodatabases, though this has also improved.

Check the names of your inputs and outputs

One thing that occasionally creates error 999999 for me is starting a feature class or raster name with a number – this most often happens when I try to start the name with the year the data represents (2016_imagery, for example). This isn’t allowed in a name, but it doesn’t have a specific error message to tell you that, so you just have to know. Another common naming problem in the past was any file path that had spaces – this is less of a problem today than it had been, but it’s often still good to avoid spaces. It’s worth checking the naming rules of whatever workspace you’re reading from and writing to in order to ensure you don’t have any other invalid characters or names. Here are some naming rules for rasters in Spatial Analyst.

Check your inputs for joins and relates

If one of the layers involved in your geoprocessing operation has an active join on it to attach values in the attribute table, that could be the cause of the error. If you need those values attached, one option is to export a copy of that dataset, which permanently writes those values to the attribute table, and then try running your geoprocessing operation again. If you do not need those values, simply remove the joins or relates and try running the operation again.

Disable Background Geoprocessing

Background geoprocessing sends your data to another process on your computer, freeing up ArcGIS to let you do more work while it’s running – occasionally, it has side effects that don’t occur when running “in the foreground” (where a window pops up and blocks you from doing anything else while it runs). You can disable background geoprocessing by going to the Geoprocessing menu in ArcMap, then Geoprocessing Options and unchecking the box next to Enable in the Background Geoprocessing section. Click OK to save your settings, then try running the process again. If this solution works, you might want to reenable background geoprocessing later since there error might still be specific to your current data, or you can choose to leave it disabled.

Check your projections/coordinate systems

ArcGIS is usually great with projections and coordinate systems, and handles reprojecting data into a common coordinate system in the background for each analysis, if they don’t already share one. But occasionally this can go wrong (maybe if a geographic transformation is required to shift datums), so reprojecting the data manually to a common coordinate system will remove this as a factor and can make the tool succeed. I’ve personally seen this be a problem with rasters in geographic coordinate systems, but it applies elsewhere too.

Check your environment settings for anything unusual

This step is less than straightforward – environment settings can make a big difference in your processing, but you might not always be clear on when and how to use them. The first step is to check the tool’s help document and look near the bottom of the page – it will tell you which environment variables apply. If you are getting an error when you set variables, it’s possible that removing them and running it will succeed. That doesn’t fully solve your problem since the environment variable may be important, but it might help you narrow in on the set of parameters that are causing the problem. One example might be setting an invalid extent for the analysis – if I remove the extent environment setting and the analysis succeeds, I may then know that I need to check on the value I was providing for the extent variable and make sure it’s correct and applicable to the data at hand.

Look for any tool specific settings that could create problems

In a similar realm to checking the environment settings, try only setting the minimum number of options in the main geoprocessing tool. For example, I’ve had troubles when running the Buffer tool if I use the dissolve option – leaving it as its default helped me realize my problem was with that option – at which point I could read up on the details of what setting that option does and whether I need it. If you can get it running after setting the minimum set of options (basically, just the required options) you can narrow in what’s wrong with your tool run by selectively setting the remaining options and reading the documentation, then determining if you’re setting appropriate values for those remaining options.

Try Repair Geometry

It’s also possible that there might be something wrong with your data. Running the Repair Geometry tool, if your data is a feature class, will check the data’s spatial information for errors and repair them if they are found. If all else fails, this one can be an important factor.

OK. That’s my list of things to try if you’re getting error 999999 in ArcGIS. If you think I missed something or have other suggestions for what to try, leave it in the comments below!

I am having trouble running some ArcObjects C# code that calls create random points. I would not be doing this in ArcObjects, but I am suffering with the same issue using Arcpy as seen here:
http://forums.arcgis.com/threads/12782-Python-scripting-and-creating-random-points?p=85866&viewfull=1#post85866

Any help as to the cause of this error would be greatly appreciated (Indeed, an official confirmation that create random points is bugged would also be appreciated).

code excerpt:

ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Desktop);
//ESRI License Initializer generated code.
m_AOLicenseInitializer.InitializeApplication(
new esriLicenseProductCode[] { 
esriLicenseProductCode.esriLicenseProductCodeArcInfo }, 
new esriLicenseExtensionCode[] { esriLicenseExtensionCode.esriLicenseExtensionCodeSpatialAnalyst });
//ESRI License Initializer generated code.

//For some reason the license thing above doesn't always do the job so this is here
IAoInitialize ao = new AoInitialize();
ao.Initialize(esriLicenseProductCode.esriLicenseProductCodeArcInfo);

Geoprocessor gp = new Geoprocessor();
gp.OverwriteOutput = true;
gp.LogHistory = true;

//Input parameters
string constrainingFeatures = "lineRoute";
string outFeatures = "test";
string workspace = "\\1.2.3.4\output\Routes.gdb";

//Open workspace
IWorkspaceFactory workspaceFactory = new FileGDBWorkspaceFactoryClass();
IWorkspace gdb;
try
{
    gdb = workspaceFactory.OpenFromFile(workspace, 0);
}
catch
{
    Console.WriteLine("Unable to open geodatabase");
    return;
}
IFeatureWorkspace fws = (IFeatureWorkspace)gdb;

//Get constraining feature class
IFeatureClass fc = fws.OpenFeatureClass(constrainingFeatures);

//Create random points - DOES NOT WORK WITH A PATH TO WORKSPACE OR THE IFeatureWorkspace
//CreateRandomPoints crp = new CreateRandomPoints(fws, outFeatures);
CreateRandomPoints crp = new CreateRandomPoints(workspace, outFeatures);
crp.number_of_points_or_field = "2000";
crp.minimum_allowed_distance = "1 Meter";

//DOES NOT WORK WITH A PATH TO cfc OR the IFeatureClass
//crp.constraining_feature_class = fc;
crp.constraining_feature_class = workspace + "\" + constrainingFeatures;

//this out_feature_class does not seem to make a difference
crp.out_feature_class = workspace + "\" + outFeatures;


try
{
    gp.Execute(crp, null);
}

Here is the log:

<ResultViews>
<ResultView Tool="Create Random Points">
<CommandLine>CreateRandomPoints_management \1.2.3.4OutputRoutes.gdb \1.2.3.4OutputRoutes.gdbtest \1.2.3.4OutputRoutes.gdblineRoute '0 0 250 250' 2000 '1 Meters' POINT 0</CommandLine>
<ToolSource>C:Program Files (x86)ArcGISDesktop10.0ArcToolboxToolboxesData Management Tools.tbxFeature ClassCreateRandomPoints</ToolSource>
<StartTime>Wed Mar 16 14:31:01 2011</StartTime>
<Parameters>
<Inputs>
<Parameter Label="Output Location" Type="Dataset">\1.2.3.4OutputRoutes.gdb</Parameter>
<Parameter Label="Output Point Feature Class" Type="Scalar">\1.2.3.4OutputRoutes.gdbtest</Parameter>
<Parameter Label="Constraining Feature Class" Type="Dataset">\1.2.3.4OutputRoutes.gdblineRoute</Parameter>
<Parameter Label="Constraining Extent" Type="Scalar">0 0 250 250</Parameter>
<Parameter Label="Number of Points [value or field]" Type="Scalar">2000</Parameter>
<Parameter Label="Minimum Allowed Distance [value or field]" Type="Scalar">1 Meters</Parameter>
<Parameter Label="Create Multipoint Output" Type="Scalar">false</Parameter>
<Parameter Label="Maximum Number of Points per Multipoint" Type="Scalar">0</Parameter>
</Inputs>
<Outputs>
<Parameter Label="Output Feature Class" Type="Dataset">\1.2.3.4OutputRoutes.gdb\1.2.3.4OutputRoutes.gdbtest</Parameter>
</Outputs>
</Parameters>
<Environments>
<Environment Label="Precision For New Coverages">SINGLE</Environment>
<Environment Label="Auto Commit">1000</Environment>
<Environment Label="Minimize memory use during analysis on terrains">false</Environment>
<Environment Label="Compression">LZ77</Environment>
<Environment Label="Coincident Points">MEAN</Environment>
<Environment Label="Random number generator">0 ACM599</Environment>
<Environment Label="Raster Statistics">STATISTICS 1 1</Environment>
<Environment Label="Level Of Comparison Between Projection Files">NONE</Environment>
<Environment Label="Output has Z Values">Same As Input</Environment>
<Environment Label="Maintain fully qualified field names">true</Environment>
<Environment Label="Tile Size">128 128</Environment>
<Environment Label="Pyramid">PYRAMIDS -1 NEAREST DEFAULT 75</Environment>
<Environment Label="Default TIN storage version">CURRENT</Environment>
<Environment Label="Output Spatial Grid 1">0</Environment>
<Environment Label="Cell Size">MAXOF</Environment>
<Environment Label="Output has M Values">Same As Input</Environment>
<Environment Label="Output Spatial Grid 2">0</Environment>
<Environment Label="Output Spatial Grid 3">0</Environment>
<Environment Label="Maintain Spatial Index">false</Environment>
<Environment Label="Precision For Derived Coverages">HIGHEST</Environment>
</Environments>
<Errors>
<Error>ERROR 999999: Error executing function.</Error>
<Error>Failed to execute (CreateRandomPoints).</Error>
</Errors>
<EndTime>36.00 seconds)</EndTime>
</ResultView>
</ResultViews>

The only other output message is:

Error HRESULT E_FAIL has been returned from a call to a COM component.

I also posted this here: http://forums.arcgis.com/threads/26029-Create-Random-Points-fails-with-ERROR-999999-Error-executing-function.

Thanks!

I am having trouble running some ArcObjects C# code that calls create random points. I would not be doing this in ArcObjects, but I am suffering with the same issue using Arcpy as seen here:
http://forums.arcgis.com/threads/12782-Python-scripting-and-creating-random-points?p=85866&viewfull=1#post85866

Any help as to the cause of this error would be greatly appreciated (Indeed, an official confirmation that create random points is bugged would also be appreciated).

code excerpt:

ESRI.ArcGIS.RuntimeManager.Bind(ESRI.ArcGIS.ProductCode.Desktop);
//ESRI License Initializer generated code.
m_AOLicenseInitializer.InitializeApplication(
new esriLicenseProductCode[] { 
esriLicenseProductCode.esriLicenseProductCodeArcInfo }, 
new esriLicenseExtensionCode[] { esriLicenseExtensionCode.esriLicenseExtensionCodeSpatialAnalyst });
//ESRI License Initializer generated code.

//For some reason the license thing above doesn't always do the job so this is here
IAoInitialize ao = new AoInitialize();
ao.Initialize(esriLicenseProductCode.esriLicenseProductCodeArcInfo);

Geoprocessor gp = new Geoprocessor();
gp.OverwriteOutput = true;
gp.LogHistory = true;

//Input parameters
string constrainingFeatures = "lineRoute";
string outFeatures = "test";
string workspace = "\\1.2.3.4\output\Routes.gdb";

//Open workspace
IWorkspaceFactory workspaceFactory = new FileGDBWorkspaceFactoryClass();
IWorkspace gdb;
try
{
    gdb = workspaceFactory.OpenFromFile(workspace, 0);
}
catch
{
    Console.WriteLine("Unable to open geodatabase");
    return;
}
IFeatureWorkspace fws = (IFeatureWorkspace)gdb;

//Get constraining feature class
IFeatureClass fc = fws.OpenFeatureClass(constrainingFeatures);

//Create random points - DOES NOT WORK WITH A PATH TO WORKSPACE OR THE IFeatureWorkspace
//CreateRandomPoints crp = new CreateRandomPoints(fws, outFeatures);
CreateRandomPoints crp = new CreateRandomPoints(workspace, outFeatures);
crp.number_of_points_or_field = "2000";
crp.minimum_allowed_distance = "1 Meter";

//DOES NOT WORK WITH A PATH TO cfc OR the IFeatureClass
//crp.constraining_feature_class = fc;
crp.constraining_feature_class = workspace + "\" + constrainingFeatures;

//this out_feature_class does not seem to make a difference
crp.out_feature_class = workspace + "\" + outFeatures;


try
{
    gp.Execute(crp, null);
}

Here is the log:

<ResultViews>
<ResultView Tool="Create Random Points">
<CommandLine>CreateRandomPoints_management \1.2.3.4OutputRoutes.gdb \1.2.3.4OutputRoutes.gdbtest \1.2.3.4OutputRoutes.gdblineRoute '0 0 250 250' 2000 '1 Meters' POINT 0</CommandLine>
<ToolSource>C:Program Files (x86)ArcGISDesktop10.0ArcToolboxToolboxesData Management Tools.tbxFeature ClassCreateRandomPoints</ToolSource>
<StartTime>Wed Mar 16 14:31:01 2011</StartTime>
<Parameters>
<Inputs>
<Parameter Label="Output Location" Type="Dataset">\1.2.3.4OutputRoutes.gdb</Parameter>
<Parameter Label="Output Point Feature Class" Type="Scalar">\1.2.3.4OutputRoutes.gdbtest</Parameter>
<Parameter Label="Constraining Feature Class" Type="Dataset">\1.2.3.4OutputRoutes.gdblineRoute</Parameter>
<Parameter Label="Constraining Extent" Type="Scalar">0 0 250 250</Parameter>
<Parameter Label="Number of Points [value or field]" Type="Scalar">2000</Parameter>
<Parameter Label="Minimum Allowed Distance [value or field]" Type="Scalar">1 Meters</Parameter>
<Parameter Label="Create Multipoint Output" Type="Scalar">false</Parameter>
<Parameter Label="Maximum Number of Points per Multipoint" Type="Scalar">0</Parameter>
</Inputs>
<Outputs>
<Parameter Label="Output Feature Class" Type="Dataset">\1.2.3.4OutputRoutes.gdb\1.2.3.4OutputRoutes.gdbtest</Parameter>
</Outputs>
</Parameters>
<Environments>
<Environment Label="Precision For New Coverages">SINGLE</Environment>
<Environment Label="Auto Commit">1000</Environment>
<Environment Label="Minimize memory use during analysis on terrains">false</Environment>
<Environment Label="Compression">LZ77</Environment>
<Environment Label="Coincident Points">MEAN</Environment>
<Environment Label="Random number generator">0 ACM599</Environment>
<Environment Label="Raster Statistics">STATISTICS 1 1</Environment>
<Environment Label="Level Of Comparison Between Projection Files">NONE</Environment>
<Environment Label="Output has Z Values">Same As Input</Environment>
<Environment Label="Maintain fully qualified field names">true</Environment>
<Environment Label="Tile Size">128 128</Environment>
<Environment Label="Pyramid">PYRAMIDS -1 NEAREST DEFAULT 75</Environment>
<Environment Label="Default TIN storage version">CURRENT</Environment>
<Environment Label="Output Spatial Grid 1">0</Environment>
<Environment Label="Cell Size">MAXOF</Environment>
<Environment Label="Output has M Values">Same As Input</Environment>
<Environment Label="Output Spatial Grid 2">0</Environment>
<Environment Label="Output Spatial Grid 3">0</Environment>
<Environment Label="Maintain Spatial Index">false</Environment>
<Environment Label="Precision For Derived Coverages">HIGHEST</Environment>
</Environments>
<Errors>
<Error>ERROR 999999: Error executing function.</Error>
<Error>Failed to execute (CreateRandomPoints).</Error>
</Errors>
<EndTime>36.00 seconds)</EndTime>
</ResultView>
</ResultViews>

The only other output message is:

Error HRESULT E_FAIL has been returned from a call to a COM component.

I also posted this here: http://forums.arcgis.com/threads/26029-Create-Random-Points-fails-with-ERROR-999999-Error-executing-function.

Thanks!

I am iterating through ~300 raster tiles, using a polygon feature class to extract by mask. The model successfully processes the first ~100 tiles and then I get the following error on the same tile each time:

ERROR 999999: Error executing function.
The table was not found. [VAT_T2001]

ERROR 010092: Invalid output extent.
Failed to execute (ExtractByMask).

I changed the extent parameter of the extract by mask tool from default to «intersection of inputs» and got the same error for the same tile. The tool seems to work fine when I change the extent parameter to «union of inputs» but it takes an extremely long time to process each tile.

I thought that the error might be occurring because there is no overlap between the error tile and the mask feature class, but I confirmed that the tool successfully processes other tiles where there is no overlap.

The tiles and the feature class have the same spatial reference. The error also occurs for a handful of other tiles in the data set.

Does anyone know how to resolve these errors while maintaining efficient processing?

The model is just an iterator sitting in front of the extract by mask tool. So this is a question about why extract by mask works for some raster datasets and not others when the datasets have the same attributes and the tool has the same parameters.

Перепечатано на: https://www.cnblogs.com/dowtowne/p/3466866.html

I’m trying to store a string value obtained from a loop through a tuple into a field called ROW_1. The code goes like this:

for creekclass in listOfClassTuples:

    (classname, Permanency, creekWidth, score) = creekclass
    arcpy.AddMessage(int(score))

    bufferDistance = creekWidth*0.5
    if crossingType == "INTERSECT":
        stringBuffer = ""
    else: 
        stringBuffer = "%s Meters" % str(bufferDistance)
        arcpy.AddMessage(str(bufferDistance))
        arcpy.MakeFeatureLayer_management(sourceLayer, "JUST_SELECTED", fieldName +" = '"+ classname + "'")
        #arcpy.SelectLayerByAttribute_management("JUST_SELECTED", "NEW_SELECTION", fieldName+" = '"+ classname + "'")
        #arcpy.SelectLayerByAttribute_management("JUST_SELECTED", "SUBSET_SELECTION", fieldName2+" = '"+ Permanency + "'")
        #arcpy.CopyFeatures_management("JUST_SELECTED", "A:TemporaryTempLayer1.shp")                           
        arcpy.SelectLayerByLocation_management(targetLayer, crossingType, "JUST_SELECTED", stringBuffer, "NEW_SELECTION")
        ## classname = classname.lower()

        if outputField1 != "":                                        
            arcpy.CalculateField_management(targetLayer, outputField1, classname)
            #arcpy.AddMessage(str(classname))
            #arcpy.AddMessage(str(outputField1))

            arcpy.CalculateField_management(targetLayer, outputField2, int(score) )

            arcpy.Delete_management("Just_selected")
            arcpy.SelectLayerByAttribute_management(targetLayer, "CLEAR_SELECTION")

The problem appears in the following line taken from the code above

if outputField1 != "":                                        
    arcpy.CalculateField_management(targetLayer, outputField1, classname)

when the variable classname is equal to «Virtual Flow»:

classname = "Virtual Flow"

I get the following error:

Executing: CalculateField Big_Pipes ROW_1 «virtual flow» VB #
Start Time: Tue Sep 30 09:40:09 2014
General error executing calculator.
ERROR 999999: Error executing function.
Expected end of statement
Failed to execute (CalculateField).

I’m trying to store a string value obtained from a loop through a tuple into a field called ROW_1. The code goes like this:

for creekclass in listOfClassTuples:

    (classname, Permanency, creekWidth, score) = creekclass
    arcpy.AddMessage(int(score))

    bufferDistance = creekWidth*0.5
    if crossingType == "INTERSECT":
        stringBuffer = ""
    else: 
        stringBuffer = "%s Meters" % str(bufferDistance)
        arcpy.AddMessage(str(bufferDistance))
        arcpy.MakeFeatureLayer_management(sourceLayer, "JUST_SELECTED", fieldName +" = '"+ classname + "'")
        #arcpy.SelectLayerByAttribute_management("JUST_SELECTED", "NEW_SELECTION", fieldName+" = '"+ classname + "'")
        #arcpy.SelectLayerByAttribute_management("JUST_SELECTED", "SUBSET_SELECTION", fieldName2+" = '"+ Permanency + "'")
        #arcpy.CopyFeatures_management("JUST_SELECTED", "A:TemporaryTempLayer1.shp")                           
        arcpy.SelectLayerByLocation_management(targetLayer, crossingType, "JUST_SELECTED", stringBuffer, "NEW_SELECTION")
        ## classname = classname.lower()

        if outputField1 != "":                                        
            arcpy.CalculateField_management(targetLayer, outputField1, classname)
            #arcpy.AddMessage(str(classname))
            #arcpy.AddMessage(str(outputField1))

            arcpy.CalculateField_management(targetLayer, outputField2, int(score) )

            arcpy.Delete_management("Just_selected")
            arcpy.SelectLayerByAttribute_management(targetLayer, "CLEAR_SELECTION")

The problem appears in the following line taken from the code above

if outputField1 != "":                                        
    arcpy.CalculateField_management(targetLayer, outputField1, classname)

when the variable classname is equal to «Virtual Flow»:

classname = "Virtual Flow"

I get the following error:

Executing: CalculateField Big_Pipes ROW_1 «virtual flow» VB #
Start Time: Tue Sep 30 09:40:09 2014
General error executing calculator.
ERROR 999999: Error executing function.
Expected end of statement
Failed to execute (CalculateField).