The following error received when running Tool 5. Identify Existing Visits in the Observations Toolbox is due to the version of ArcGIS Pro. It is known to fail in version 3.1 and run surccessfully in 3.0.1 and 3.4; other versions are unknown. So, if feasible, update your version of Pro or run on a different machine containing a different version of Pro!
5. Identify Existing Visits
=====================
Parameters
Working Directory C:\Temp
Name of odc connection located in Working Directory Biotics.odc
Dataset name in Biotics 'Survey123: Observations'
=====================
Messages
Start Time: Monday, November 18, 2024 3:56:03 PM
dataset: 'Survey123: Observations'
bioticsPilot: C:\Temp\Biotics.odc
table_list: ['C:\\Temp\\Biotics.odc\\BIOTICS_USER.VISIT', 'C:\\Temp\\Biotics.odc\\BIOTICS_USER.EO_SOURCE_FEATURE', 'C:\\Temp\\Biotics.odc\\BIOTICS_USER.D_DATASET']
Traceback (most recent call last):
File "C:\Temp\Observations_v1_4\Observations.atbx#IdentifyExistingVisits_Observations.py", line 67, in <module>
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 10869, in MakeQueryTable
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 10866, in MakeQueryTable
retval = convertArcObjectToPythonObject(gp.MakeQueryTable_management(*gp_fixargs((in_table, out_table, in_key_field_option, in_key_field, in_field, where_clause), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000793: Invalid data element type
ERROR 000840: The value is not a Raster Layer.
ERROR 000793: Invalid data element type
ERROR 000840: The value is not a Raster Layer.
ERROR 000793: Invalid data element type
ERROR 000840: The value is not a Raster Layer.
Failed to execute (MakeQueryTable).