I am building a tool in ArcGIS Pro Modelbuilder (Pro version 2.2.1) that includes making a drop down list for user input based on the information contained in a domain of a feature class. The three steps are GetWorkspace, Domain to Table, and Choose Peril, as shown here:
GetWorkspace is a brief python script tool consisting of the following lines of code:
# Import system modules import arcpy # Set the parameters InputFeatureClass = arcpy.GetParameterAsText(0) # Get the full path of the feature class and extract the workspace fullpath = arcpy.Describe(InputFeatureClass).path workspace = fullpath.split(".sde") + ".sde" # set the output variable to be the workspace name arcpy.SetParameter(1, workspace)
Domain to Table is a standard ArcPro tool, and Choose Peril is the example script described in this post on how to generate a choice list from a field. I have this same tool running elsewhere in the model with no issues, although in that location it does take a feature class instead of table for the table view input parameter.
When I run each step manually one at a time in Modelbuilder everything works perfectly, including all later steps in the model. However when I try to validate or run the entire model with none of the intermediary files created (which are created when I run the steps individually) I encounter an error saying that the table output in Domain to Table does not exist, even though it should exist once Domain to Table runs. The full error is as follows:
ERROR 032659 updateParameters Execution Error: Traceback (most recent call last): File "C:\Users\myname\Documents\ArcGIS\Projects\ProjectName\ProjectToolbox.tbx#ChoosePeril_CatEvents.UpdateParameters.py", line 4, in <module> File "C:\Users\myname\Documents\ArcGIS\Projects\ProjectName\ProjectToolbox.tbx#ChoosePeril_CatEvents.UpdateParameters.py", line 31, in updateParameters File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\analysis.py", line 1798, in Frequency raise e File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\analysis.py", line 1795, in Frequency retval = convertArcObjectToPythonObject(gp.Frequency_analysis(*gp_fixargs((in_table, out_table, frequency_fields, summary_fields), True))) 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: Failed to execute. Parameters are not valid. ERROR 000732: Input Table: Dataset C:\Users\myname\Documents\ArcGIS\Projects\ProjectName\ProjectGDB.gdb\PerilTypes_DomainToTable does not exist or is not supportedFailed to execute (Frequency).
From what I can find online Error 032659 just means there's an issue that was found in the validation code, and that Error 000732 is more of the issue.
I've found a number of pages with potential answers to Error 000732, but so far none of them have solved my problem. Things I have tried include the following:
- Running Table To Table and Make Table View as intermediate steps between Domain to Table Choose Peril.
- Checking permissions to the write location by trying to write the table to both the default geodatabase and in_memory.
- A number of articles (ESRI technical article 10149, GIS SE 79718, GIS SE 209358, GIS SE 319053) recommend checking path names for poor use of spaces, special characters, and backslashes. My workspace name is a little weird, but I'm not sure how this could be the problem since I'm able to manually run this step successfully. The workspace in question is: "C:\Users\myname\Documents\ArcGIS\Projects\ProjectName\CR41459-PD.prodlb.company.net,41459(1).sde"
- And of course, the good old, try reloading the tool, try restarting ArcPro, and try restarting the computer.
Has anyone else encountered this kind of error before, or have any suggestions of next steps to try?