Geodatabase exception when querying data

BarbaraSchneider2

We are doing stereo aerial image interpretation in ImageAnalyst. Our stereo interpreter receives the following error message about every hour: A geodatabase exception has occurred. This happens in the following function, when executing featLayer.Search(queryFilter):

public static async Task<Feature> GetFeatureAsync(FeatureLayer featLayer, string whereClause)
{		
	try
	{
		Feature feature = await QueuedTask.Run(() =>
		{
			// Query the FC 
			QueryFilter queryFilter = new QueryFilter();
			queryFilter.WhereClause = whereClause;

            using RowCursor rowCursor = featLayer.Search(queryFilter);
			if (rowCursor.MoveNext())
			{
				// Get feature
				Row row = rowCursor.Current;
				feature = row as Feature;
				return feature;
			}
			return null;
		});
		return feature;
	}
	catch (Exception ex)
	{
		ProPopupMessage.Error(MiscUtils.GetMethodName(), ex.Message);
		return null;
	}
}

I would like to explain a bit in more detail what the stereo interpreter is doing. He is recording woody plant coverage in every square of a biotope object:

The workflow looks as follows:

1. He selects a square on the stereo map
2. In the code, the ObjectID of this square (polygon) is retrieved. The ObjectID corresponds to the ID of the point feature.
3. The above function (GetFeatureAsync()) is called to get the corresponding point feature. The whereClause is "ID=" + objectID.
4. After the error has occurred, ArcGIS Pro has to be restarted because the same errors occurs again and again when selecting a polygon.

I doublechecked, the objectID really exists when the error occurs. What could be the cause of the problem?

Should I try to search the feature class instead of the feature layer?

SumitMishra_016

Yes — you should switch to searching on the FeatureClass instead of the FeatureLayer, as it's more robust and avoids rendering-related issues.

public static async Task<Feature> GetFeatureAsync(FeatureLayer featLayer, string whereClause)
{
	try
	{
		Feature feature = await QueuedTask.Run(() =>
		{
			// Access the FeatureClass directly
			FeatureClass featureClass = featLayer.GetFeatureClass();
			if (featureClass == null)
				return null;

			QueryFilter queryFilter = new QueryFilter
			{
				WhereClause = whereClause
			};

			using (RowCursor rowCursor = featureClass.Search(queryFilter, false))
			{
				if (rowCursor.MoveNext())
				{
					return rowCursor.Current as Feature;
				}
			}
			return null;
		});

		return feature;
	}
	catch (Exception ex)
	{
		
		return null;
	}
}