I've been trying out the new riparian analysis tools from version 3 and have been getting a lot of cryptic 999999 error messages. I have been able to resolve some of these by deleting temporary files in the scratch workspace or changing the geoprocessing settings.
However, this same error has popped up both on ArcGIS 10.6.1 and ArcGIS Pro, which makes me think that there's an issue with Extract by Mask.
Start Time: Monday, September 17, 2018 5:47:44 PM
Running script e. Denitrifying Practices...
Minimum organic matter of 1.7 percent
Maximum coarse soils percentage of 65.0 percent
35.0 percent of area within 20 meters of stream must meet all soils criteria
35.0 percent of area within 90 meters of stream must consist of slopes between 2 and 8 percent
Maximum bank height of 12 feet, or 365.76 cm
Creating non overlapping zones
Calculating bank height
Generating mask where all soils criteria are met:
1. Average organic matter is greater than 1.7 percent from the surface to a depth of 100 cm
2. Maximum coarse soil percentage, defined as the weight percentage of particles greater than .05mm diameter, does not exceed 50% at a depth of 50-150 cm
3. Drainage Class is 'Very Poorly Drained', 'Poorly Drained', 'Somewhat Poorly Drained', or 'Moderately Well Drained'
Failed script e. Denitrifying Practices...
Traceback (most recent call last):
File "C:\GIS\ACPF_V3_Pro\Scripts\DenitrifyingPractices.py", line 701, in <module>
SuitableSoils, OM, Sand, DrainClass = SoilInputs(gSSURGO, SoilProfileTable, elev_mask, MinOM, MaxCoarse)
File "C:\GIS\ACPF_V3_Pro\Scripts\DenitrifyingPractices.py", line 316, in SoilInputs
soils_mask = ExtractByMask(gSSURGO_copy, elev_mask)
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\sa\Functions.py", line 7285, in ExtractByMask
in_mask_data)
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\sa\Utils.py", line 53, in swapper
result = wrapper(*args, **kwargs)
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\sa\Functions.py", line 7281, in Wrapper
out_raster)
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 496, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Please refer to the error help for potential solutions, or contact Esri Technical Support
http://esriurl.com/support.
Function Read Error [Local Function]
Function Read Error [Local Function]
The table was not found.
The table was not found. [fras_blk_reach_ras]
The table was not found. [VAT_reach_ras]
Failed to execute (ExtractByMask).
Failed to execute (e.DenitrifyingPractices).
Failed at Monday, September 17, 2018 5:56:50 PM (Elapsed Time: 9 minutes 5 seconds)